Search results for query: *

Hello TheAceMan1, I know you had to spend a lot of time reviewing my BD and I do appreciate your comments. I will read over the links you suggested. My back is against the wall with this DB and it has to work. As of right now, the system works but from reading your comments, it appears that...

Hi TheAceMan1, Thanks for the update. I enjoy working in Access and would like to know what I did wrong. I'm hoping to take what I learn here and apply it to other programs I would like to write in Access. Thanks again for all your help. Take care, Neup44

TheAceMan1, Just checking in to see if you received my program and if so, did you have a chance to look at it. Thanks again for you help. I hope you have a great weekend. Neup44

TheAceMan1, I'm taking you advise and relaxing.....the program was just sent. I do appreciate all your help. I'm looking forward to your comments. Neup44

Richard, I will read and post. Thanks Neup44

Good evening TheAceMan1, I know this makes me look stupid but I could not find your profile. After spending several hours searching, I decided to email Tek-Tips for help but no return e-mail. I could use some help posting my program. Sorry for the trouble. Neup44

Hello TheAceMan1, I'm having some trouble posting my work for you to review. If you don't mind, please give me some instructions on how to post my work. Thanks for all your help Neup44

Happy 4th of July TheAceMan1, I do appreciate your help and will be happy to send you a copy of the program that I am working on. I have several versions so give me a day or two to clean it up and I'll be happy to send you the final copy. I'm not sure how to post my work since this will be my...

Good Evening TheAceMan1, The link was helpful and I spent most of the day thinking about the table relationships. This is what I came up with and did. I will have two types of tables. The first set of tables will relate to the customers while the second set of tables will relate to warranty...

Good morning TheAceMan1, Thanks for you insight. I will read the article and give some thought to the relationships. I'll let you know if I am successful this evening. Take care and have a great weekend. Neup44

Hi GymRatPA, Thanks for your response. Please foregive me for not completely understanding your answer but I have limited (but growing) experience with Access. I was trying to link tables 2, 3 & 4 either by warranty ticket number (which is an autonumber in table 2) or by customer ID...

I don't know if what I am trying to do is possible. I have 4 tables: Table 1 - Contains customer information. Table 2 - Contains Warranty information Warranty ticket number (autonumber) Customer ID (lookup in table 1) Table 3 - Contains Warranty Repair for a cetain...

dcurtis, Sounds simple, I'll give it a try. Another question, if a have table with the person's fax number and e-mail address, can I have the report sent automatically or do have have to re-type the fax number and or the email addrss? Thanks for your help. Neup44

I know you can e-mail a report out of access but can I fax the report also? If this is possible, how do I do it? Neup44

Good Morning PHV, When I asked the wizard for the "Form and report specifications" I did get a list of the specifications but I do not belive my database has reached the max. Any suggestions? Neup44

I have 5 tables with 31 items (some yes/no and text). When I add a 6th table with yes/no items and text, my form does not work. Does this make senses? Is there a limit of the number of tables a form will populate? Neup44

Randy, All looks good except I don't want the plumbing box to appear on the report. Only those boxes that were checked or if a text box, only if something was entered. Report. Lot 123 Roof Repair Yes or a checked box Repair Description "The roof is leaking in the master bedroom."...

randy700 I started doing what you recommended but then I relized that may not get the results I was looking for. Here is the application. A construction company builds houses and when they sell a house, the house is under warranty for 12 months. That is, if something is wrong, the...

randy700 I will give it a try and let you know the results (may not have the opportunity to try it out until tonight). Again, thanks for your help. Have a great day. Neup44

randy700, Thanks again for the information. I did try the Yes on the criteria line (for every item) but when I did this and re-ran the query, only those entries that had Yes for all the entries were displayed. That is, if I have 5 boxes and 10 entries, by putting Yes on the criteria line for...