I have designed a report named report by Recruiter. I have made a form called frmRecruitmentR eports, on this form I have created a pair of combo boxes .
1.Beggining Date (both are unbound)
2.Ending Date.
A query called recruitment query
The table being used is tblRecruitment the Field were criteria is initcontactdate
Argument:
Between [forms].[frmRecruitmentR eports].[BeginningDate] And [forms].[frmRecruitmentR eports].[EndingDate]
.
All this works fine when I enter dates. Once I pass the date fields I'm prompted
to enter a parameter value = Field Division and Recruiter ID. If I enter them manualy I get the results I want. But I want to place two combo boxes, Field Division and Recruiter Id so they can be selected right from the form.
On my report (Report by Recruiter) I have Field Division and Recruiter Id as Group Headers. I assume thats why I'm getting prompted to enter the paramater values. What I've done is ;
Created a query named FieldDivision From Field Division Table.
Created an unbound cbo box Named it Field Division.
At Row Source;
SELECT qryFieldDivisio n.FieldDivision FROM qryFieldDivisio n;
After all this has been done I'm still prompted to enter paramater values.
Can someone tell me what im doing wrong? What am I missing ?
Thanks
2 1581
I think parameter promts in forms happen when your source isn't spelled exactly the same way.
On my report (Report by Recruiter) I have Field Division and Recruiter Id as Group Headers. I assume thats why I'm getting prompted to enter the paramater values. What I've done is ;
Created a query named FieldDivision From Field Division Table.
Created an unbound cbo box Named it Field Division.
At Row Source;
SELECT qryFieldDivisio n.FieldDivision FROM qryFieldDivisio n;
You are probably getting your parameter prompts because your RowSource isn't set quite right. In your query named qryFieldDivisio n, you will normally select two fields/columns to display, in this order: FieldDivisionID , FieldDivision. Then set the RowSource to qryFieldDivisio n. Give it 2 columns, make the column widths 0", 1.5", set bound column to 1, limit to list = yes, column headings = no.
In the row source you have listed, you are trying to essentially duplicate the select query that you have already created.
The two ways to set your row source are: set row source to query name like I first mentioned OR use a SELECT statement in the row source itself, in this way: SELECT FieldDivisionID , FieldDivision FROM tblFieldDivisio n.
Hope this helps!
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: B Love |
last post by:
I would like to display a drop-down list on a form conditional on the value
of another field on the same form. I am not sure if this is good form or
not. I am using Access97, but have access to 2000 also. The specific
scenario is this: I have 2 fields on a form. One is called "Manufacturer."
The other is called "ProductLine." I would like to display specific product
lines of the selected Manufacturer. Now, here's the bad news: my SQL and VB...
|
by: B Blue |
last post by:
here's the situation:
a produce dept at a grocery store needs to generate a weekly sheet for
ordering. This is how it looks:
5 columns across with the following headings:
Product Description, UPC code, Case Quantity, Case Price, Retail Price
- Product Description, UPC code, Case Quantity, are all to be drawn
from a table containing 100 records.
-Case Price, Retail Price are fields which will appear empty but allow
data entry
|
by: Sami |
last post by:
I hope someone will tell me how to do this without having to do any VB
as I know nothing in that area. I am a rank beginner in using Access.
I have created a database consisting of student athletes. I have now
learned how to join two different tables in a query so that I might
generate a report.
Specifically, student athletes at a community college are required to
graduate with an AA or AS degree. Consequently, various steps are in...
|
by: Kathy |
last post by:
What is the standard technique for handling the fields in the following
scenario on a continuous form?
Multiple Divisions. Each Division has multiple Buildings. Each Building has
a Supervisor.
Tables: (abbreviated)
TblDivision
DivisionID
|
by: Chittaranjan |
last post by:
Hi All,
I have a problem and hope I can get the better solution from here.
I have a form written in HTML and I need to write that in perl so the main problem I am facing is that I need to generate some fields according the data I will select from the drop down list so basically I have drop down list which will ask for the number of students information I want to enter and after selecting a value from the number of students drop down it...
| |
by: rynato |
last post by:
I have a form which the user fills out to enter some data.
If there already exists an uncompleted session - say, the user started
entering some data but had to stop to do something else - the user has
the option of selecting that session from a drop-down menu (think
<form><select><option>....</option></select></form>). The method for
that particular form is set to 'GET' and the action is
$_SERVER. The <selecttag has a bit of javascript...
|
by: metalaniac |
last post by:
Hi there
I have been sitting with this for a while now and can't seem to get the correct script online. I get a lot of scripts being able to change a line of text, or input field by selecting an option in a drop-down box.
What i want is to be able to select an option from a drop-down box, which then changes a whole fieldset of 3 or more form field options, depending on the option chosen in the list.
Can anyone help with something like...
|
by: Iain Wilson |
last post by:
Hi All
I am trying my hand at printing from a web page for the first time. I
have been asked to print what amounts to many pages of data in
response to a button click. The scenario is as follows.
1. The user will select a Product from a Drop Down List.
2. The user will press the print button
3. Based upon the product selected in the Drop Down List I need to
print data gathered
|
by: bytenut |
last post by:
I would like to display two field values in a combo after selecting from the list items...
i.e. my drop-down shows two fields from a lookup, but when I select the item, only the first field value is shown in the combo text area (at the top)...
(bound field is invisible)
e.g. Currently seeing (standard behavior)
drop-down | 1
drop-down | 2
drop-down | 3
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |