Tilted Forum Project Discussion Community - View Single Post

crossova · 06-14-2005, 11:50 AM

I was successful in creating a search form for another work-related DB. However an older database needed a search form, because we recently had an internal audit and the auditors wanted to review incoming tasks for the past 6 months. however without an easy search feature it meant looking at all the tasks and then organizing them...very tedious work.

Since it is an old database i really didn't want to go about deleting old tables and/or renaming them. I tried to create a form (frmReportSearch). Right now you should be able to enter a time period and a Module. Then clicking the OK button should open a report with the requested data. However each time I click okay a parameter box appears stating, Module.ModuleName. I have been having this problem all day. When I click okay or enter a module name it will generate data but not exclusive to the module name entered from the form's drop down module section or the parameter pop-up.

There is also another drop down menu on the form labeled 'Status'. I was having the same problem with that, as I was with the Module drop down menu. I gave up trying to fix that and removed it from my macro's SQL Where statement.

The file can be located below, its about 1.8Mb

http://www.megaupload.com/?d=10X00M02

I'd greatly appreciate any help you can give me on this.

06-14-2005, 11:50 AM	#1 (permalink)
crossova Psycho Location: new york	[MS Access '03] Creating a Search Form I was successful in creating a search form for another work-related DB. However an older database needed a search form, because we recently had an internal audit and the auditors wanted to review incoming tasks for the past 6 months. however without an easy search feature it meant looking at all the tasks and then organizing them...very tedious work. Since it is an old database i really didn't want to go about deleting old tables and/or renaming them. I tried to create a form (frmReportSearch). Right now you should be able to enter a time period and a Module. Then clicking the OK button should open a report with the requested data. However each time I click okay a parameter box appears stating, Module.ModuleName. I have been having this problem all day. When I click okay or enter a module name it will generate data but not exclusive to the module name entered from the form's drop down module section or the parameter pop-up. There is also another drop down menu on the form labeled 'Status'. I was having the same problem with that, as I was with the Module drop down menu. I gave up trying to fix that and removed it from my macro's SQL Where statement. The file can be located below, its about 1.8Mb http://www.megaupload.com/?d=10X00M02 I'd greatly appreciate any help you can give me on this. Last edited by crossova; 06-14-2005 at 11:54 AM..