Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Test: Multiple Choice Template


Can any one do this i need it real fast let me know!!


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Multiple Choice
I 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

View Replies !   View Related
Multiple Choice Parameters???
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!

View Replies !   View Related
Choice... ActiveX Or DLL
If you had a choice of using either an ActiveX or a DLL object in an application that is used on various systems, what would you choose?

This is going on a .MDE project and my main concern is stability or compatibility.
I am more interested in general practices of what you would use (either an ActiveX or a DLL object) to add functionality to your Access application.

If we had to go into something specific... then lets just generalize it into 2 catagories:
1) General added functionality.
2) Security

I would like to hear pros and cons about both.

Thanks.

View Replies !   View Related
Choice Of Address?
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?

View Replies !   View Related
Query Different Choice In The Same Fields.
I 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

View Replies !   View Related
Date Required After A Choice
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.

View Replies !   View Related
Set A Default Choice In A Combo Box
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 Replies !   View Related
Parameter Drop Down Choice
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?

View Replies !   View Related
Inserting A Value Based On Combo Box Choice
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

View Replies !   View Related
Creating Quiz DB, NOT Mutliple Choice.
Hi.

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?

View Replies !   View Related
How Do I Create Mutiple Choice Questions
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 ?

View Replies !   View Related
Create Recordset From Combo Choice
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!

View Replies !   View Related
Figuring Different Calculations Per Choice In Combo Box
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.

View Replies !   View Related
How To Trap An Error (and Force A Choice)?
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.

View Replies !   View Related
Figuring Different Calculations Per Choice In Combo Box
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!

View Replies !   View Related
Some Newbie Queries About Choice Dependant Fields
I have a database i am playing around with in Access 2003

I should state im new to Access

Anyway i have a field with a dropdown menu with the choice of Yes or No

I want another field to be populated from an entry in the table Extras called ElectricityCharge but only when the Yes is chosen above

Had a look around and cant see any sort of If then type function or anything of that ilk, how can i do this ?

View Replies !   View Related
Select Query Based On A User Choice
Hi,

I would like to run a simple select query, where the CRITERIA is based on the user choice.
I have a form with a combo box, with a few choices, and a button that will trigger a macro with one query for now. I can store the choice in to a variable e.g. "town", using Microsoft VB code.
How can I transfer the variable to the CRITERIA field in the query, so whenever I chose a specific "town", my query will select the records for that specific town.
I want to use one query, and I don't want to have to "hard type the criteria in to the cells' query", but I would like to use a variable that can change and will be read it from the user choice through combo box.

If I am not clear enough, please let me know.

Thank you!

View Replies !   View Related
Filled Text Boxes Based On Combobox Choice
Hi
I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me.
I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields.
I have tried =DLookUp("[PropertyAddress]","tblProperty","[Property]") in the address textbox which will only bring up the first recod's address from the table, if I change the name in the combobox the address doesn't change.
What am I doing wrong, I have designing databases in Access for a total of 7 days now and have been going fairly well with some tips and code snippets from this forum but this has got me stumped.

Cheers
optidisk

View Replies !   View Related
Test For New Employees
Hi Folks!

I've been asked to make a 5 questions test to evaluation potential new employees' knowledge of MS-Access. Honestly, I need your input on what to ask. The goal is not to make a very hard test, but rather to see if somebody as at least basic knowledge of SQL and Ms-Access.

Some background information of what we do with MS-Access
We use MS-Access as a central hub for different download from different systems. We make a lot of daily imports. We export queries in Ms-Excel. We open it from Access and format the report. We make hundreds of reports every day. We don't really use forms or reports.

What questions to ask?
I was thinking of having 2 questions about SQL. One simple query with a formula, and a query with 2 tables (perhaps a left join). On what should my other questions be?

View Replies !   View Related
Test / Servey
Hey all, I'm trying to design a Test / Survey database.

I have posted regarding this problem before if it looks familiar to you.

Please look at the .jpg attached

I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.
The main problem is how to tell which answer/OptionDetail is the correct answer for both Surveys and Tests. Maybe it would be better to separate the two? All suggestions welcomed.

Case Survey
Here is what i am trying to do. When a user decides to make a new question for a survey they will have to choose what type of question the question will be. For example say the user wants to make a survey with a answer grid question. They would choose Answer Grid from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Satisfy3) from the tQuestionTypeOptionsMaster combo box. Say the user chose Satisfy3 then they would be presented with a list of all possible answers that the test taker would see for the Satisfy3 choice ( Very Satisfied, Somewhat Satisfied, Not Satisfied).

This is what i want as far as the survey section goes.


Case Test
A user decides to make a new question for a test they will have to choose what type of question the question will be. For example say the user wants to make a test with a Multiple Choice question. They would choose Multiple Choice from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Single Answer, Multiple Answer) from the tQuestionTypeOptionsMaster combo box. Now comes the part where im stuck. I have to somehow get the Multiple choice selections that the test maker is entering into the tAnswers table and figure out how to tell the program to look at tAnswers insted of tQuestionTypeOptionsMasterDetails when the test taker opens up the form. I also need to figure out how to tell which multiple choice selection is the correct answer.

I hope this makes sense to everyone.


Thanks Hooks

View Replies !   View Related
Test For 'n'th Record
AC2000
I have a continuous Subform which list the entrants in a 'Knock out' competition.
The competition could be Darts, Bowls, Pool etc.
Each discipline could be Singles, Pairs, Triples or Foursomes.
I would like to show a spliter between teams and between groups.
controls are [Sort](num), txtName, chkWin and two overlapping thin controls below these, txtTeamSep and txtGrpSep both normally visible = False
In a Pairs comp. say, I would like to achieve what I THINK this would achieve with OnCurrent Event?

Case "Pairs"
If (count of records to this point/2 = Mod(count of records to this point/2)) then
Me.txtTeemSep.Visible = True
If (count of records to this point/4 = Mod(count of records to this point/4)) then
Me.txtTeemSep.Visible = False
Me.txtGrpSep.Visible = True
End If
Case "Triples" etc.

Any help really appreciated
Don

View Replies !   View Related
IF Statement With More Than One Test
I need to evaluate a string, if the string is ?-* or ???-*, then I return the string, if not I use the Left function.

I would like to do this with IIF statement in my query, or a VBA function that I could place is my query.

This is what I have so far:


VBA:

Function change()

Dim str_sku As String

If str_sku = "???-*" Then

str_sku = str_sku

Else

str_sku = Left("str_sku", 5)

End If

End Function


I get a type mismatch error. I tested on change(Function change(983-00245)

In the IIF statement, I am not able to figure out the Or part.

SKU: IIf([ITEM] Like "???-*",[ITEM],Left([ITEM],5))

Missing the "1-*" part.


Any help would be appreciated.

Thanks

View Replies !   View Related
Password Test Box
How does one change the characters shown on a text box to *. For example if i enter 12345, it displays ***** in the textbox.

View Replies !   View Related
Command Button To Produce Form Based On Drop Down Choice?
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

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved