[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.

I'm on it.

Edit: Oops, scratch that. Forgot that I only have 2002. Any way that you could convert it for me to look at?

I will see if i can covert it. I actually changed a few things around so the Search Form now just retrieves results based upon the start/end date. I removed the SQL Where statement where it looks at the Module or issue Status.

Here is the new file. it is in Access 2000 file format.
http://www.megaupload.com/?d=083RWIQR

crossova:
I was unable to open either file due to permissions errors. Sorry I couldn't help.

yeah i realized that when i downloaded it, when i created it i added a custom security group to it. when you run it on your pc does it also ask for the username/password?

No prompt, it just dumps me. Did you figure it out?

i realized that the workgroup administrator is set to my company's network share drive. i tried to save a seperate copy but it keeps directing to the original so i dont want to f it up so imma just leave it as is. thanks for trying to help though