Search results for query: *

I am trying to recreate the wheel , as the saying goes. I have access to a form that has an unbound combo box where a code is entered and the resultant search gives you the rest of the info. We are trying to do the same thing for our applicaion, however, we enter an airline code instead...

THANK YOU, Anthony! This worked, and has solved my problem! H. Jessen "Now I know more, and I feel dummer"

I have a form with about 5 sub-forms which are accessed via tab control. Once I reach the last field of a sub-form how can I (1)continue to the next sub-form/tab. OR (2)if I am on the last field of the last sub-form how do I either stop going anywhere, or go the the next record on the main...

THANK YOU ALL!! I got it to work! However, the problem was on my side. I was using the work field name. OOPS!!!! You ALL were a great help! H. Jessen "Now I know more, and I feel dummer"

TO: mstrmage1768 Tried your suggestion - still get problems. The current code is: ========== If IsNull("Data-Basic.[SSN]") Then stLinkCriteria = "[E_Month] = '" & Me![Month] & "' and " & "[E_Year] = '2003'" Else: ' THIS IF...

Could you PLEASE take 5 minutes to look at this code? I can not get the IF statements to execute. If "[Data-Basic.SSN]" Then stLinkCriteria = "E_Month ='" & Me![Month] & "' and " & "[E_Year] = '2003'" Else: If...

Okay, Paul. But what I am trying to do is report ONLY those who have events to report. Otherwise I get a page with the individuals name and the rest of the page is blank - a real waste of paper and toner from the laser printer. Somehow, I need to code that if there is no event then go to the...

TO: PaulBricker Tried that - same result. I am frustrated with this. It seems so simple, but I can't get it to work! Print the info from table_1 once, and then put the subreport in with all the details for that one person. But if I have 12 events in table_2, I get 12 events printed 12...

FIRST A THANK YOU TO EVERYONE WHO HAS HELPED ME IN THIS NEW ENDEAVOR OF MINE! WITHOUT YOUR HELP, I WOULD STILL BE ON PAGE ONE! Now to my current problem: I have a report with a Sub-Reports inside of it. The query for the main part of the report is a link between table_1 and Table_2 as...

TO: KenReay THANK YOU! Couldn't figure out what or why, but I had more or less determined that it had to be individual settings somewhere. That worked for me. I never used the format function before, but I will remember it now! Again, THANKS. H. Jessen "Now I know more, and I feel...

I hope this is the place for this question. We have a report that is supposed to print out individuals who have birthdays for the month selected in a form. When I run the request - it works. When others run the request - they get 'data type mismatch'. Here is the basic info: TABLE-1...

MichaelRed You approach may seem easier for you; however, I am not a programmer nor do I have much VBA experience. Additionally, I am not using any MS Access security, so the permissions is a null subject here. Could you give me a sample of what you did with regards to the "generate an...

Thank You ALL for your help. Now it is time to dive in and see what happens! H. Jessen "Now I know more, and I feel dummer"

VicM That would work - however, I usually give the user the last option to 'EXIT/QUIT'. And drilling down for these users is not something they can easily handle. They were the testers for the 'KISS' method of user interface - if it has more than two steps they get lost. As for changing the...

Is it possible to increase the number of switchboard options from the default 8? I tried to change the properities, but when I went to the switchboard manager it still limited me to eight entries. I need at least 4 more for a total of 12. THANKS. H. Jessen "Now I know more, and I feel...

Geekmomz Right, it would except that there would be no record until a score was entered. Therefore it won't work. That is my problem - I am trying to find what is not there in two fields. H. Jessen "Now I know more, and I feel dummer"

Can anyone recommend an online course, or book learning course, for VBA? I am having to use it more and more, and would like to become educated in the right way rather than in the 'fire fighting' mode. THANK YOU. H. Jessen "Now I know more, and I feel dummer"

I can't figure out the logic needed for this query and I am sure once I see it, I will feel really dumb! I have a table that has the following fields: Name ID Topic Date Score FY/Qtr The problem is, I need to see who missed specific training for a particular quarter of a fical...

This is not good! Guess I will have to find another way to display the information for the managers. Thanks Anyway. H. Jessen "Now I know more, and I feel dummer"

chrissie1: I am using a continuious form; however, the conditional formatting on the tool bar will not work for me. The colors are dependent on the subject and the score. Unfortunately, each subject has a different range of acceptable, and not aceptable - it would be a LOT easier if every...