Tilted Forum Project Discussion Community  

Go Back   Tilted Forum Project Discussion Community > Interests > Tilted Technology


 
 
LinkBack Thread Tools
Old 06-14-2005, 11:50 AM   #1 (permalink)
Psycho
 
crossova's Avatar
 
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..
crossova is offline  
Old 06-20-2005, 01:27 PM   #2 (permalink)
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..
Ripsaw is offline  
Old 06-21-2005, 05:39 AM   #3 (permalink)
Psycho
 
crossova's Avatar
 
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..
crossova is offline  
Old 06-28-2005, 06:42 AM   #4 (permalink)
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.
Ripsaw is offline  
Old 06-28-2005, 06:48 AM   #5 (permalink)
Psycho
 
crossova's Avatar
 
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?
crossova is offline  
Old 06-29-2005, 06:32 AM   #6 (permalink)
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.
Ripsaw is offline  
Old 06-29-2005, 06:45 AM   #7 (permalink)
Psycho
 
crossova's Avatar
 
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..
crossova is offline  
 

Tags
access, creating, form, search


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -8. The time now is 03:36 AM.

Tilted Forum Project

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43