[MS Access '03] Creating a Search Form - Tilted Forum Project Discussion Community

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.

Ripsaw · 06-20-2005, 01:27 PM

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?

crossova · 06-21-2005, 05:39 AM

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

Ripsaw · 06-28-2005, 06:42 AM

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

crossova · 06-28-2005, 06:48 AM

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?

Ripsaw · 06-29-2005, 06:32 AM

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

crossova · 06-29-2005, 06:45 AM

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

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

06-20-2005, 01:27 PM	#2 (permalink)
Ripsaw Chef in Training	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? __________________ "We are supposed to be masters of space, but we cant even line up our shoes?" One life, one chance, one opportunity. Last edited by Ripsaw; 06-20-2005 at 01:48 PM..

06-21-2005, 05:39 AM	#3 (permalink)
crossova Psycho Location: new york	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 Last edited by crossova; 06-21-2005 at 05:44 AM..

06-28-2005, 06:42 AM	#4 (permalink)
Ripsaw Chef in Training	crossova: I was unable to open either file due to permissions errors. Sorry I couldn't help. __________________ "We are supposed to be masters of space, but we cant even line up our shoes?" One life, one chance, one opportunity.

06-29-2005, 06:32 AM	#6 (permalink)
Ripsaw Chef in Training	No prompt, it just dumps me. Did you figure it out? __________________ "We are supposed to be masters of space, but we cant even line up our shoes?" One life, one chance, one opportunity.

06-28-2005, 06:48 AM	#5 (permalink)
crossova Psycho Location: new york	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?

06-29-2005, 06:45 AM	#7 (permalink)
crossova Psycho Location: new york	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 Last edited by crossova; 06-29-2005 at 06:49 AM..