HELP! I set out over 7 days ago to accomplish what I thought was a fairly simple task; to add another search tool to our database. And here I am in the Access help forums!
First off I am using Access 2010. It is also necessary to note that I am very new to Access altogether.
My project is as follows:
Also, I have spent way to long trying to do this task, so please don't be shy with information. While I have stumbled along thus far without a ton of help, I am not trying to learn the process for this task. I really don't see me needing it again any time soon. I tried it with a parameter query, a form filter, VBA (several different ways), etc., and nothing to this point has worked.
Thanks for the help guys!
dgaletar
First off I am using Access 2010. It is also necessary to note that I am very new to Access altogether.
My project is as follows:
I work at the Catholic University of America in Washington, DC. Strangely enough I am a mechanic here. We have about 80 vehicles that belong to the University itself, and are used by University staff members on a daily basis to perform different types of jobs. Our job is to keep all of them running.
The University has about 6 different tools to track different aspects of the vehicles, but none are synched together in any way. That is why I decided to "try" and design a database using Access 2010; to combine all of these details in one location.
So far everything has gone quite well... that is until this task came along.
Important information: While all of the vehicles are issued a number (CUA#) from our department when we get them, some of the departments re-number them with their own numbering system. Therefore ALL vehicles have a "CUA#", while some ALSO have an "Alternate ID" (ALT ID).
This task is to allow the team members to look up the vehicles information (which is located on the main form, frmVEHICLE_DETAILS_All) using either the vehicles CUA# or the Alt ID.
What have I done thus far:The University has about 6 different tools to track different aspects of the vehicles, but none are synched together in any way. That is why I decided to "try" and design a database using Access 2010; to combine all of these details in one location.
So far everything has gone quite well... that is until this task came along.
Important information: While all of the vehicles are issued a number (CUA#) from our department when we get them, some of the departments re-number them with their own numbering system. Therefore ALL vehicles have a "CUA#", while some ALSO have an "Alternate ID" (ALT ID).
This task is to allow the team members to look up the vehicles information (which is located on the main form, frmVEHICLE_DETAILS_All) using either the vehicles CUA# or the Alt ID.
- Created the main form, frmVEHICLE_DETAILS_All, which contains the CUA# as the primary key, and the Alt ID as it's own column. T(Note: the CUA# field in a number field, while the Alt ID is a text field)
- Created a form named frmALTID_LIST, which is a modal popup form
- it consists of one Combobox, which is is CAPTIONED: "Select an Alternate ID#:", and is NAMED: Alt ID. (Right now it is not connected to anything, so it doesn't do anything.)
- it also has a "CANCEL" button on it that is not set up yet. (But that part I can figure out.)
Also, I have spent way to long trying to do this task, so please don't be shy with information. While I have stumbled along thus far without a ton of help, I am not trying to learn the process for this task. I really don't see me needing it again any time soon. I tried it with a parameter query, a form filter, VBA (several different ways), etc., and nothing to this point has worked.
Thanks for the help guys!
dgaletar
