I'm currently use the statement below in a query.
Like [Please Enter the Cluster you wish to view] & "*"
This prompts you to enter in the information.
Is there a statement, that will prompt to select from drop down choices when quering?
For example, I have a database that tracks test scores. I want to be prompted when I run the query to select from a drop down 'Pass' or 'Fail'
Can anyone help me?
Per the instructions detailed here...
http://www.fontstuff.com/access/acctut08.htm
...I created a parameter query in the form of a drop down box that, once an
option is selected, should display a form with a number of fields pre-filled
from a record chosen by the drop-down selection.
The drop down has a command button with the following code in the Onclick
event:
Private Sub cmdCreateReport_Click()
DoCmd.OpenQuery "qryUIRFollowUp", acViewNormal, acEdit
DoCmd.Close acForm, "frmOpenUIRLookUp"
As it now stands when I click the button I get the form but none of the
selected data is filled in. The fields are blank.
What code to I need to add to the above to make the form hold the data
selected from the drop down?
Thanks,
David
Is there a way to add a drop down list to the message box in a parameter query so that users can enter a value(s) from the list in prompt? Thanks.
View 2 Replies View RelatedCo-worker asked me if there was a way to add a drop down selection menu to a parameter box. Seems like ACCESS can do a lot of neat things.
View 14 Replies View RelatedI want to be able to choose an item from a drop down list (based on a query i.e. distinct products) and have the item chosen to be automatically used as a parameter in another query.
Thank you
When creating a query I have set up a parameter query as instructed (in this case searching for a name) but when I run the query it returns the error 'this expression is typed incorrectly etc.'
I have worked out that this must be due to the fact that the names are not typed in by a front-end user but need to be chosen from a dropdown list (which i have stored in a separate table) - So, the query seems to fail based on that.
I have created a query with the parameter for the Domain field. however on the form the user enters this information via a drop down menu. i was just wondering could the parameter box be set to a drop down box as well to save the user entering in the full Domain field name?
View 6 Replies View RelatedIs there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?
View 1 Replies View RelatedI have a query which check assignement of vehicles.
Is it possible to have combo box with all employee names ,and acording to that choice to execute query.
So when i open my report I want to be asked to pick name of 1 employee in drop down menu and then get his records.
If its doable please be gentle cause i am new in all this
thx
I have two addressess, primary and secondary.
I would like to make an option button on the form that indicates (when selected) which address to use for mailings? Although, 9 times of 10, mailings are sent to the primary address, but there are those exceptions...
Can someone direct me to an example code to perform this?
I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
View 2 Replies View RelatedI am trying to create a query that capture all the possible choice of a fields and do some math on them. let me make it clearer.
I have two fields that i need to create a query from forecast type(backup, hardcore) and win percent(76 to 100, 50 to 75, 26 to 49 and 0 to 25).
Forecast type is a drop down that has the following choice hardcore, backup or could be null. Win percent is just a number fields holds value between 0 and 100. One of the criteria for the range of number is when either backup or hardcore is null.i need them to line up as rows or columns so they either look like this
row view
Hardcore
Backup
76 - 100
50 - 75
26 - 49
0 - 25
column view
[Hardcore] [Backup] [76-100] [50-75] [26-49] [0-25]
I am currently using six queries to get the values for each group then joining them to get the final results. the problem with this is the values wont come out correctly. I know there is an easier solution to what i am doing right now.
I need some guidance and help to approach this issue. This will be use in a report so hopefully this provide more alternative to solve this problem.
thanks in advance
I'm trying to setup a parameter that has a multiple choice so to speak. Rather then the user being able to enter whatever data they want.. I would like them to have a choice between two items.
Is it possible? if so.. how do I do it?
Thanks!
I have a form which deals with complaints against employees.
One of the selections is a yes/no checkbox stating "No Merit" indicating the complaint has no merit.
If this checkbox is checked for Yes, I wish to require that data (an explanation) be entered as to why in your opinion the complaint has no merit.
This data would be entered in a text field called Comments.
On the "Close Form" command button I have tried to place the coding
If [nomerit]=yes And [comments]=" " then
run the message box.
I can't seem to get it to work. Any ideas gratefully received.
I used a combo box to let user select "Proejct Status" such as active, completed, cancled. I want to set active as a default selection if user does not choose other status. How can I do that? Thank you very much for your help.
View 2 Replies View Relatedi have a two column that one stores a professions and other stores a number of the profession like that:
number
professions
1
singer
2
police man
3
teacher
"number" column is a combo box, that boundColumn property is two.
i want that in the form when i choose a value in a combo box i will see the profession in other text box in my form.if i choose 2 in combo box i see in a other text box in my form police man.
Hi all,
I have a main form containing client details (tbl_Client) and a sub form containing notes (tbl_notes). tbl_Notes contains a foreign key field (Client_ID) which is obviously the primary key in tbl_Client.
The client is chosen on the main form using a combo box where the user selects the clients name. the id is not visable to the user. How can i get it so that the id (Client_ID) of the selected user is inserted into the Client_ID field of tbl_notes.
Thanks
Can any one do this i need it real fast let me know!!
View 5 Replies View RelatedHi.
I am creating av quiz database, that are supposed to handle about 50 users.
It's about 50 questions, and the answers will be long, more than 255 signs.
I have som issues on how to go so far.
The quiz respondents will answer in a dap (or maybe Asp) web page on the intranet. The structure, shown below doestn seem right.
So far I got this:
tblQuiz
-------
quizID
Title
PassScore
introText
tblQuizPart
-----------
quizPartID
partName
sorting
quizID
tblQuizQuest
-------------
questionID
question
correctAnsw
maxPoints
sorting
quizPartID
tblQuizAnsw
--------------
answID
questionID
answer
username
timestamp
pointsGiven
sensured (yes/no)
======================
This is not a satisfying structure, but i'm not sure on where my mistake is.
Does anyone have a suggestion?
I'm making a project in VB, and I need it to link to a Database,I already know how to do this
the project is a bit like who wants to be a millionaire with all the questions in an access table,
I know I need the following fields;
the auto number
the question
Answer A
answer B
answer C
the problem is I need to be able to select which answer is correct ?
I have a table called Contacts and a form with two combo boxes for searching for records either by name or property name. The following code works fine for finding the first record, but I want to be able to show on the form all (and only) those records which match the combo box entry. Currently rowsource for name box is:
************************************************** *
SELECT [Last Name1] FROM Contacts UNION SELECT [Last Name2] FROM Contacts
ORDER BY Contacts.[Last Name1];
************************************************** *
and code is:
************************************************** *
Private Sub Combo214_AfterUpdate()
' Find the record that matches the control for Last Name search
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
rs.FindNext "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo214.Value = ""
txtFirstName1.SetFocus
End Sub
************************************************** *
Rowsource for property box is:
************************************************** *
SELECT Contacts.PropertyID, Contacts.PropertyName
FROM Contacts
ORDER BY Contacts.PropertyName;
************************************************** *
and code is:
************************************************** *
Private Sub Combo212_AfterUpdate()
' Find the record that matches the control for Property Name search
Dim rs As dao.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst "[PropertyID] = " & Str(Nz(Me![Combo212], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo212.Value = ""
cboPropertyName.SetFocus
End Sub
************************************************** **
Any help is appreciated!
Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text box called (txtridgetot) that has a calculation in it, but I need different calculations per option/field that's picked. Can each option/record that is chosen have a different calculation associated with it in the (txtridgetot) text box.
In other words if the user selects the third option/field called shake ridge could I have a calculation that would run and have it display the sum of this calculation in the text box (txtridgetot).
If so could you please describe how?
Thanks-- Any help will be greatly appreciated.
How do I programmatically force an error dialog to make a certain choice?
I'm able to trap the dialog via the following code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 7787 Then 'record updated by another "user" (subform)
MsgBox "Error trapped!"
Response = acDataErrContinue
Else
Response = acDataErrDisplay
End If
End Sub
Problem is, if I bypass the 7787 error in this manner, it defaults to dropping the changes, rather than saving the record, which is what I want. (Both are choices on the dialog.)
Any help would be most appreciated.
Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text box called (txtridgetot) that has a calculation in it, but I need different calculations per option/field that's picked. Can each option/record that is chosen have a different calculation associated with it in the (txtridgetot) text box.
In other words if the user selects the third option/field called shake ridge could I have a calculation that would run and have it display the sum of this calculation in the text box (txtridgetot).
If so could you please describe how?
Thanks-- Any help will be greatly appreciated.http://forums.aspfree.com/newthread.php?do=newthread&f=18#
Hello!
I have several menus defined for Access 2010. However, only one is set with the visible property set to true.The user is able to show and bring up the other menus by right-clicking in the menu area. How can I disable this so the user may not bring up these menus? An example is shown in the picture below. I don't want to give the user access to the "CPLAccess" and "Datasheet column removed" menus, but I do want to keep them so that I can make them visible via VBA.
View 8 Replies View RelatedI have question regarding multiple choices fields. I would like to store constrained but multiple values in a single field. I used the assistant to create the multiple choice field in the table, but I'd like to have it displayed in my form with check boxes (more readable in my tabular form) instead of drop down list. Is it possible ...
View 6 Replies View Related