Solved

Using a list to pull a parameter

Posted on 2014-04-29
6
55 Views
Last Modified: 2014-11-28
I have two tables: T_Students, T_Times (date/time)
I have another table that is created from those two, called T_Attendance

I'd like to be able to use a query to create a mailing list for students that attended a specific class.  Because the time field is a date/time field, it's hard to prompt the user for that parameter.

Is there a way to have a drop down list appear to select the date/time and use it as the parameter for the query?
0
Comment
Question by:BBlu
6 Comments
 
LVL 35

Expert Comment

by:Bembi
ID: 40030404
Access provides a calendar control, which can be placed on a form and you can use the value property to buidl your query.....
Is this wht you asked for?
Means you build a form to give the user the possiblility to limit the results....
0
 

Author Comment

by:BBlu
ID: 40030409
Thanks, Bembi.  I want to be able to access this through a mail (email actually) merge, though.  I don't think I can do that with a form, right?
0
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 200 total points
ID: 40030472
Rather than prompting, use a combo on a form which is probably how you are populating the field to begin with.

Prompting causes problems because it requires the user to enter values multiple times plus there is no way for you to validate them so you can't tell if the user entered an invalid value.  The user would be prompted the first time when he opened the report to preview and a second time if he printed it.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:BBlu
ID: 40030946
I'll try that, PatHartman.  I'm not that strong in forms, but I'll give it a try.
0
 
LVL 1

Accepted Solution

by:
DexterFan earned 200 total points
ID: 40072314
You need a form with a combo box that is based on unique values for the dates in your T_Attendance table.  Then you create your query that includes the date field and use the builder wizard to create criteria that refers to the content of your combo box in your form.  The last requirement on your form is a command button that runs the query.
0
 

Author Closing Comment

by:BBlu
ID: 40471271
Thanks, guys.  Sorry for the delay in closing the question.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question