I have combo boxes that have all been created using the wizard with the options Yes, No and Not Applicable. There is no default set but they default to the second entered option ("No") every time. I have created the form a second time in the hope this would do something but to no avail. Any ideas??
View RepliesHi All,
I am wondering if it is possible using VBA to update using either an option group or check boxes as shown in the frmDefaultValue in the attached file to update two tables tblLabelNumber and tblMediaType.
The form frmMedia contains two combo boxes. I am trying to use the form frmDefaultValue with an option group and check boxes as shown as not sure what is the best method here to update the values in the two table tblLabelNumber & tblMediaType at the push of a button Update as in the form?
Look forward to any comments on this.
Robert88
Hi Everyone,
I hope someone can help.
I have a form with a combo boxes and a table with relevant list and additional field, fldDefaultDrive (Yes/No Field).
Currently in order to set the default value, I have used the following code for each default;
Private Sub Form_Load()
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """D"""
End Sub
However, I want users to be able to go into the table and change the default value if thier CD player default Drive is anything but D: Drive. I have tried to replace the D above with an SQL statement but with no success.
Private Sub Form_Load()
Dim Drivename As String
Drivename = SELECT tblMediaDrive.fldDrivename FROM tblMediaDrive WHERE (((tblMediaDrive.fldDefaultDrive)=-1));
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """Drivename"""
End Sub
This is definetly not working, can anybody help, I have a feeling it is syntax but not sure where? :confused:
Robert88
I am having a problem with 3 pc's attached to our network but at a different campus. They have been complaining that the Snapshot Views of reports they are running are stopping the print queue by asking to load paper type 'bond' to the printer. I have checked the Snapshot Viewer printer settings on thoses machines and indeed they are defaulting to 'paper type - bond'. Setting the paper type to Plain or Unspecified will only print on that type for that instance. Is there anywhere to set the default paper type, i cannot find anything!!
View 5 Replies View RelatedScenario: I have a combo box in an evaluation db that is set up to return 3 columns - EmpID, Name, JobID. The combo box only shows Name, but properly updates the neccessary fields on the screen.
Problem: I would like to turn the JobID txt box into a combo box that would default to null prior to a Name selection (on a new record) and then default to the recorded JobID after Name selection. 99.9% of the time, this won't be used, but occasionally an employee will receive an evaluation for a JobID they did, but were not officailly assigned.
The right way to do it would be to create a second record in the primary system that I am polling the data from, but that is not feasible given the nature of that system.
Any ideas?
-Brian.
To set the default values for controls, select the control on the tool bar and press F4. The default value properties list will appear. I like to turn off all of the 3D stuff by resetting some the values like 'Special Effect', 'Border Style', etc. This way I don't have to manually change them after the fact...
Thanks Ken have done this - however when I go off and word with a differant mdb file then come back to the original which I had open when I entered the defaults - the defaults have disappeared.
Any suggestions.
Ta
i have set up option groups (using the wizard) with Yes=1, No = 2 and N/A =3 with the default set to 3. After creating the option groups the default does not default even though the properties box clearly shows the default being set to 3 - can anyone suggest why this would be?
View 1 Replies View RelatedIs there a way to reset access to the out-of-the-box defaults?
TIA
Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a backward way of doing things. Does anyone know how to elimate that default value from the format of a number field in general?
Thanks!
Carly
can anyone tell me how i can have the default value of the combo box field as the first value in the combo box drop down list?
View 3 Replies View RelatedHi guys,
I'm obviously doing something stupid in my form :-) If you open the form in the attached sample you will see that I have 2 combo boxes. One of them has a default value showing and the other doesnt, I want to get the second combo to automatically show the value in the list but just cant seem to get this to work...
I cant work out whats different bewteen the two. Been tearing my hair out here so would appreciate some input.
Thanks in advance
Hi guys,
In my form I have a combo box that is bound to a product/specification table.
When clicked, this combo box displays a list of products, each with its respective set of specifications (although I configured it so just the product column can be seen.) The reason I do this, is so that the specification values (against which certain other values in the form is critiqued) will be a static value in the form itself, and not a changeable value in a table.
What I want to do, however, is to let the combo box assume a default value when the form load (it must already have a product selected at start-up.)
How can I do this?
Thanks ahead!
Hi all,
Can some one help me with how to set a default text on a combo box whose record source is set to a query?
I have a form with two combo boxes. The first combo box’s record source is set to the following query:
SELECT chrCategoryID, chrCategoryName
FROM tblGuarCategory;
My 2nd combo box will list all the items based the category I select on the first combo box.
But when the user opens the form, instead of showing both combo boxes blank, I would like to display the following text:
Combo Box1: Select a category
Combo Box2: Select an item…
I tried to use the combo box’s Default Value property like = “Select a category”. It didn’t work. I am not sure what is missing here. I appreciate your help.
I am sure this is a very basic problem but I just can't seem to make it work...
I have a form with a combo box. The values for the combo come from a table listing available month and year of various data. When the vlaue is selected in the combo box, the form refreshes the data to display that month and updates another table with that month that is used for a few different functions. Everything works great except that when you open the form, there is no value displayed in the combo box. What I would like for it to do is display the month that is equal to the value found in the second table, since that is considered to be the current month. I have tried various approaches to setting the default value and using a query in the control source but It still shows no value when opened. Any advice would be appreciated....
Hello,
I have a form with a combobox which has its record source to a table which has 5 records.
Is it possible to open the form so that by default the combo shows a specific record?
I have tried something like this but does not work:
On Open event
Me.Cbo = "ID"
ID is the record I need to show.
Thanks.
:confused: I was wondering if somebody can help with my default combo box problem?
I have a secured database whereby users logon, which is used as a scratch pad for keeping track of Purchase orders. A Form frmUserInput with two relevant fields for this problem 1. User Initials txtUsersInitials and 2. POBook (Purchase Order Book) which is the combo box cboPOBooks both unbound fields on the form.
The txtUsersInitials is generated automaitcally when the form is loaded using a VBA statement txtUsersInitials = Current User.
The list of the combo box is generated from a table tbleUsersPOBook and uses a query qryUsersDefaultPOBook as listed below;
SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[Forms]![frmUserInput]![txtUsersInitials]));
This generates a drop box showing the Different department codes for each individual. So for some it is only one item for others up to three codes, this part works fine... :)
:cool: However here is my problem.
Since some people can sign off more than one Purchase Order book I have had to add an additional field in the table tblUsersPOBook called DefaultUsersPOBook which is a yes/no field, so only one yes exists for each user who logs on. I have created another query qryDefaultPOBook as listed below;
SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[FORMS]![frmInputForm]![txtUsersInitials]) AND ((tblUsersPOBook.UsersPOBookDefault)=Yes));
When I place this query in the Default section of the combo box it gives me no result.
Firstly is it possible to have a varying default like this since each user will have a different default?
Or is there maybe a better way of achieving a default which is variable for each user based on thier default Purchase order book in the table tblUsersPOBook for the field "Yes" in DefaultUsersPOBook ? :confused:
I am trying to set the result of a query as the default value for a text or combo box. I have tried setting the query as the default value in the box's property. I have also tried doing it in VB. The code looks like this
Dim SQL AS String
SQL = "SELECT Address
FROM Table1
WHERE Name = Forms!Main_frm!name_lbx.Value;"
Forms!Address_frm!address_cbx.DefaultValue = SQL
I have also tried
Dim SQL AS String
SQL = DoCmd.OpenQuery([update address_qry])
Forms!Address_frm!address_cbx.Value = SQL
Where update address_qry is the same as the above.
I keep both forms. I know how to do it by setting the queries as values in a list box, then transfering the values to the text or combo boxes. But I was hoping there was an easier way.
Thanks
Alex
I am trying to set the result of a query as the default value for a text or combo box. I have tried setting the query as the default value in the box's property. I have also tried doing it in VB. The code looks like this
Dim SQL AS String
SQL = "SELECT Address
FROM Table1
WHERE Name = Forms!Main_frm!name_lbx.Value;"
Forms!Address_frm!address_cbx.DefaultValue = SQL
I have also tried
Dim SQL AS String
SQL = DoCmd.OpenQuery([update address_qry])
Forms!Address_frm!address_cbx.Value = SQL
Where update address_qry is the same as the above.
I keep both forms open. I know how to do it by setting the queries as values in a list box, then transfering the values to the text or combo boxes. But I was hoping there was an easier way.
Thanks
Alex
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 RelatedHi all,
New to the board and access (2000)
I have been tasked w/ creating a database to schedule and track incoming cases for my job (Dental Lab)
This entire thing is new to me but have developed most of it through reading this forum so thanks for that!
I still have a long way to go...
Here is what I am stuck on -
I have a table of technicians
here you can add the first name, last name, and department (The department is coming from another table called department)
These are working fine,
Now I have a table for the doctors to fill out a form to initiate a new case,
In this table I have a field called techassigned1 which pulls from a query of the technician table where the deptmant is set to plaster bench.
This works fine - I get a dropdown box with the technicians name that is assigned to the plaster bench (This name changes periodically)
But All I want is for that 1 name to be set as a default value - I need it in the table so I know who started the work on the case
I dont want the doctor to have to choose this name
I read in the forum and used
Me!techassign1.DefaultValue = Me!techassign1.ItemData(0)
in the forms ONOpen event
But this is what happens
The form just displays #Name? in the dropdown box but the correct name is under it if I click the arrow
But if I right click and look at the property sheet the name is in the default value property but it still doesnt update the techassign1 field in the table.
Is there a way to have this automatically add the technician from the query to the table? without haveing to select it?
Any help is greatly appreciated -
If I am not making sense plese let me know and I will try to explain it better.
Hi all...I have a combo drop down box that has the 50 states in it. I would like the list to pop to the first state that starts with a letter typed in. For exampe, you type 'C', takes you right to CA.
Anyone now how to do this? (silly question )
I got a COMBO BOX with 2 columns , for instance code and name.
CODE NAME
123 JOHN
124 JACK
125 BILLY
126 MARY
In the OPEN form action which the form using this combo to do some query action, I want to put a default value to this combo box after a VBA query result of which should return a name to this form. Just want to know how to put the result to this combo box, e.g. when the VBA query return a name Billy. What's the syntax to make this combo box equal to Billy and do corresponding query?? Thans a lot!! FOr the time being I just know the following syntax, but since the combo box got 2 columns and how can I know Billy is located in the third record?
Me.Combo24.DefaultValue = "FORMS![Master]![combo24].itemdata(0)"
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list.
View 3 Replies View RelatedIs there a way to force a combo box to display the first value in the list as its default value?
To be more specific the combo box needs to display this value when the parent form is opened or when you use VBA to change or add the row source.
When ever I use a saved query as the row source the default value is always Null.
Thanks Everyone,
Joe
Me!ComboName.DefaultValue = Me!ComboName.ItemData(0)
this assigns the first value in the combo box to the default.
can this be changed to always assign the last possible record in the list as the default.
i have a combo box on my form that uses UNION query to put "<select>" as part of the list items.right now "<select>" appears on top of the list but what i mtrying to do is when the form loads i want the combo box to have "<select>" selected and not just show blank unless someone click on the down arrow. i m sure there is a way/propoerty to do it but i cant figure it out. Also how can i make my combo box so user cant type in a combo box but select from the list.
View 2 Replies View Related