Test: Multiple Choice Template
Feb 18, 2006Can any one do this i need it real fast let me know!!
View RepliesCan any one do this i need it real fast let me know!!
View RepliesI 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'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 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 Relatedmy issue is i have multilble text box in my form & based on change in one of this text box i need the code to compare between data in the form & table & returm Msg if it is not matching. attached screen FYI.
i look in the internet but i could not figuer out the VBA code since i do not know VBA. what comes to my mind to to use select case.
I currently write (very long) reports for work, which have a lot of standard text in them - but the standard text varies according to the client's history.
I want to create a report-writing application for myself, composed of series of yes/no/maybe buttons
and depending on whether I click yes/no/maybe in each section, a different segment of text is inserted into the report.
Ideally the application would be able to insert, or create, formatted text - such as headings, bullet point lists etc - I would need to be able to export this report into Word
I started out by making a table, with each section being a different field, and the various paragraph options as different cells in the field, but I am stuck at present on the basic functionality of "click button , insert text"...
I have been trying to create a report to count equipment tested between two dates:
I am using Access 2000 (old I know) and I have 21 different tables with the fields laid out the same. For the moment, I will list five of the tables: Servers, Laptops, Printers, Workstations, and Monitors. The criteria I draw from each table are the fields Model#, Part#, Serial#, Test Date, Retest Date, and Technician.
I can create a report from a query (say laptops). The criteria I is BETWEEN[Enter Start Date]AND[Enter End Date] under the TEST DATE field. Works great! In my report I use =Count(*)&" "&"Unit(s) tested" & "Between "&[Enter Start Date] & " and" & [Enter End Date].
That works great too.
I am trying to create ONE REPORT using ONE Date range and display how many units were tested:
Example:
Units Tested between March 1, 2014 and March 31, 2014
Servers 9
Laptops 23
Workstations 15
Printers 18
Monitors 31
If I can get these five tables, hopefully I can add additional tables to the same report as I need them. I am not savy with VB code, but will give it a go with some direction as to where to put it and how to add to it.
I'm trying to build up a database for Multiple choice questions quiz in MS access 2010.My requirement are as follows
My quiz consist of 15 questions. Each questions carry some weightage. Suppose a question carries a weightage of 5 and there are two correct options like A & C. If user selects option A then he gets half marks.Multiple users can access the test at the same time.
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 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 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'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?
i 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
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?
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 RelatedHi 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?
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
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
How does one change the characters shown on a text box to *. For example if i enter 12345, it displays ***** in the textbox.
View 3 Replies View Related