473,289 Members | 1,963 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Creating a drop-down box in a Access query

2
Hello,

I am working with Access 2003 and have the following issue:

I have created some queries that will search my employee’s certification database. I search the database base on type certification and number of year’s experience. I place the ID# in one message box and a number representing the years in another parameter box. This will return any employees that match the given criteria. With over 100 various certifications in my company, it is very hard to remember the ID number for the certification. What I want to do is select the actual certification from a drop down to populate the first box and input the year box as usual. I am having a hard time figuring out just how to accomplish this task. Is there anyone out there who knows if this is even possible? I need to select the "Skills/EquipmentID" from a drop down. This is the SQL code that I've used thus far...

Expand|Select|Wrap|Line Numbers
  1. SELECT tblITSkillInfo.SkillID, tblITSkillInfo.[Skills/EquipID], tblITSkillInfo.EmployeeID, tblITSkillInfo.YrsExpr, tblITSkillInfo.MnthExpr
  2. FROM tblITSkillInfo
  3. WHERE (((tblITSkillInfo.[Skills/EquipID])=[Skill/Equipment ID]) AND ((tblITSkillInfo.YrsExpr)=[Years Experience]));

QSligh
Feb 6 '08 #1
3 2508
MMcCarthy
14,534 Expert Mod 8TB
It's not clear from your question exactly what you are trying to do. For the moment all I can suggest is you check out this tutorial on cascading combo boxes and see if it helps.
Feb 6 '08 #2
qsligh
2
It's not clear from your question exactly what you are trying to do. For the moment all I can suggest is you check out this tutorial on cascading combo boxes and see if it helps.
Sorry for the confusion in my opening question. The desired effect is to open a query and instead of having to input the data each time, have the choice of choosing predefined entries from a "drop-down" box. After which I click OK and the query runs.

R,
QSligh
Feb 8 '08 #3
MMcCarthy
14,534 Expert Mod 8TB
You mean you want to set the query criteria to controls on the form?

i.e.

If you had a dropdown box called cboName on a form called frmMain then you could set the criteria as ...

[Forms]![frmMain]![cboName]

The form would have to be open when the query ran.
Feb 8 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: konsu | last post by:
hello, i would like to write a batch file with all sql commands necessary to create a database, its tables, and populate them with initial data. would the experts please help me with these...
4
by: gonzal | last post by:
Hi Dose any body know why a temporary table gets deleted after querying it the first time (using SELECT INTO)? When I run the code bellow I'm getting an error message when open the temp table...
0
by: K Finegan | last post by:
I have an archival process on a large database that runs once a month. At the beginning of the process the triggers and indexes on the tables whose data is moved are dropped, the data is moved and...
0
by: Mary Lei | last post by:
After instaling db2 8.2.2 on a solaris box I ran a script that drops a database and then creates it. This scripts runs fine under db2 8.2.1 on linux. With 8.2.2 I got a mysterious error about...
3
by: Kyle Fitzgerald | last post by:
I've started a web control library project and can build my own controls to add to the toolbox in the .NET environment. The problem I'm having is I want to create a control just like the HTML...
4
by: Coleen | last post by:
Hi All :-) Can anyone give me a URL where I can find a good example of code on how to create a temporary SQL table using VB.net? I've checked the Microsoft site at: ...
2
by: astolpho | last post by:
I am using a slightly outdated reference book on J2EE programming. It gives 2 methods of creating a database used in its casestudies. The first is an ANT script that gives the following output: ...
1
by: DWiggin | last post by:
We are getting deadlock errors (sporadically) on a batch job we've created. This job runs against a SQL Server 2000 back-end. The first step of the batch job is to run a DDL script to drop...
16
by: Joell | last post by:
Hi Guys, Im still new to this SQL stuff and have a question about creating a counter that does not reset if I drop the temp table. Is this possible? I need to add new work order number (counter)...
3
by: Nokao | last post by:
I use db2 9 express-c Hi... I'm having that problem... .....every less-than-10-seconds, a entry like that (I displayed that entry with the command db2evmon -db 'MYDATABASE' -evm...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.