MS Access ??s|Sundance Business VOIP Telephone Help

Print Thread

Rate Thread

MS Access ??s #252579 04/29/08 11:18 AM
Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA metelcom OP Admin
OP metelcom Admin Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA	Anyone familiar with working with relationships between tables and forms with linked tables and subforms. I have some questions and would gladly pay for some support on getting through a project I am working on. Also whats a good source for learning SQL Merritt Business Telephones & Equipment + Commercial Audio/Video Products Commercial Communications . . . Turner, Maine If it was built after 1980 don't expect it to work right.

Atcom VoIP Phones

Best VoIP Phones Canada

Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.

Re: MS Access ??s #252580 04/30/08 12:52 AM
Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA metelcom OP Admin
OP metelcom Admin Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA	bump Merritt Business Telephones & Equipment + Commercial Audio/Video Products Commercial Communications . . . Turner, Maine If it was built after 1980 don't expect it to work right.

Re: MS Access ??s #252581 04/30/08 06:40 AM
Joined: Feb 2006 Posts: 826 Kelowna BC Clinton Member
Clinton Member Joined: Feb 2006 Posts: 826 Kelowna BC	The Microsoft Official Academic Course books are decent enough. The books I've worked with all come with lab manuals. https://ca.wiley.com/WileyCDA/WileyTitle/productCd-047006966X.html I haven't worked with Access in about 2 years, but I might be able to jog my memory. If you want to email your files and questions to me I can see what I can do this evening.

Re: MS Access ??s #252582 04/30/08 08:08 AM
Joined: May 2007 Posts: 5,058 Likes: 5 NYC Silversam Moderator-1A2, Cabling
Silversam Moderator-1A2, Cabling Joined: May 2007 Posts: 5,058 Likes: 5 NYC	Merritt - Are you locked into Access? I used to work with dBase - mostly with their DOS version but I did some work with their Windows products. It was a lot cleaner than Access for my money. Sam "Where are we going and why are we in this hand basket?"

Re: MS Access ??s #252583 04/30/08 11:00 AM
Joined: Jun 2007 Posts: 2,106 Tampa Bay, FL Kumba Member
Kumba Member Joined: Jun 2007 Posts: 2,106 Tampa Bay, FL	I'll help ya Merritt, when ya got time? Learning access will help you get a basic understanding of SQL such as Tables, Relationships, SQL Queries, etc. It'd be like taking an SQL 101 class.

Re: MS Access ??s #252584 05/01/08 12:34 AM
Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA metelcom OP Admin
OP metelcom Admin Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA	Sam I have been working with dBase sine DBII then went to Foxbase then FoxPro but my programs won't run with XP so I want to move my files to Access. What I I'm working on at this point is I have the following tables calls address customer invoices material_sold I want to have one form that views the info from all the tables that relate to that customer. I am having trouble getting all the data to show from each table. Merritt Business Telephones & Equipment + Commercial Audio/Video Products Commercial Communications . . . Turner, Maine If it was built after 1980 don't expect it to work right.

Re: MS Access ??s #252585 05/01/08 01:05 PM
Joined: Jun 2007 Posts: 2,106 Tampa Bay, FL Kumba Member
Kumba Member Joined: Jun 2007 Posts: 2,106 Tampa Bay, FL	Well, it'd take me 3-pages to explain it, or I can show ya pretty quickly on your computer. Anyways, if you click on the title bar of the form, and open the properties dialog box, there should be an option to set the form source. This is where you can add tables and create relationships. If you have global relationships (like calls will always relate to a customer), then you want to define those in the database itself, and it will inherit to the forms.

Re: MS Access ??s #252586 05/01/08 01:31 PM
Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA metelcom OP Admin
OP metelcom Admin Joined: Sep 2005 Posts: 9,285 Likes: 6 Maine, USA	Quote Originally posted by Kumba: or I can show ya pretty quickly on your computer. OK your place or mine I would be glad to get a plane ticket and pay you for a day to get a few lessons. Merritt Business Telephones & Equipment + Commercial Audio/Video Products Commercial Communications . . . Turner, Maine If it was built after 1980 don't expect it to work right.

Re: MS Access ??s #252587 05/01/08 04:23 PM
Joined: May 2007 Posts: 5,058 Likes: 5 NYC Silversam Moderator-1A2, Cabling
Silversam Moderator-1A2, Cabling Joined: May 2007 Posts: 5,058 Likes: 5 NYC	Merritt - I'm running dBase IV for DOS and dBase 5.7 for Windows on XP now. Correction: Actually, I haven't run the WIndows one in a while, but I did run it for about a year. No problems. Sam But if James will show you Access - go for it. Personally I hate it, but I've been spoiled. "Where are we going and why are we in this hand basket?"

Moderated by MooreTel

Hop To

Link Copied to Clipboard

atcomsystems.ca/forum Forums Computers & Programming Computers, Software, Accessories MS Access ??s