Search results for query: *

Ok stupid question- I am trying to do something which is essentially If form is open, then do this. And i can't seem to figure out how to determine with VBA coding if the form is open or not. ARGH... help!!!???? Rachel, Compensation Analyst

Ok... dumb question. I have a report which needs to have a certain section snapped to the bottom of the last page of the report (and kept together). I have tried a variety of things, but nothing really works. So here is the lastest idea: have an unbound text box above the section which would...

Alrighty... i used to use this method when we had Access 97 and now i can't find the solution in 2000 + XP. Basically what i am trying to do is when a user enters an employee ID in the form, it runs an update query which grabs other employee data from a different table and updates the fields in...

Ok... this is very VERY odd and i can't figure out why it is doing this. Please keep in mind this is someone else's access database that i am trying to update and clean up. Basically there is a field which tracks the start date of a health care benefit called COBRA, a field which tracks the...

Ok... so I am trying to figure out the code to create an intelligent "order number" which would be in the format of "MMYY-0001" which would reset the "0001" back to one at the start of the next month. The way i was going to go about doing this was to basically use the today function and cull...

Alrighty, I am feeling like an idiot. I have a series of subforms which corolate to months (don't ask its a silly way of doing it but its what the client wants :P) and the subforms happen to be quite long... so when i tab through, the form itself doesn't move. I have to manually drag the...

Ok... i have been beating my brains out trying to figure out how to keep the header with the detail of multiple subreports. Anyone have any idea? The KeepTogether Property is not helping me for some reason. The background on this project is that it is a Job Description that has many sections...

Ok... ya ya... i know it's me again. This time I have been trying to keep a series of subreports together.... I have the Keep Together property set to "Whole Group" on all the subreports (there are 12). The series of subreports are actually sitting in the report footer section...

Anyone know how to make the Page Footer only appear on the last page of a report? And I can't use Report Footer..... thx!

Ok... i am feeling like an idiot. I am a self taught Access VBA developer and I am trying to get a string value to be passed to a report. Basically the user makes a selection of which report he wants to run, and I want the proper title to populate in the Report. I thought the way to do this...