Only thing left is a combobox (dropdown) with predefined values. What i want is, as soon you have picked a value from the combobox, save the record and go to the new blank record, the last picked value of that combobox auto appears in the combobox for the new record.
View RepliesI have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.
Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...
I have a continuous form which has 1 field in which is a combo box which has a list of names. Once you select a name, the next record down is available for selection. This is because my tables PK is a autonumber. How do i filter the records to only show the names which have not been previously entered in my above records.
View 11 Replies View RelatedOn tab 1 of my navigation field i have a combo box which i use to select the record i want to look at.
but then if i click on another tab in my navigation form to have a look at another set of forms (not related) and i click back on the first tab with my combo box the combo box has reset it'self to be blank - not selected.
Is there a way that i can get the combo box to remember the last record that was selected and automatically go to it when i go back to the first tab?
I have a form that has four combo boxes on it that enable the user to select entrants in a golf tournament for tee off times and tee. (I have attached part of this database to this post) It all works fine but after selecting the first player in the first combo box and then selecting the second combo player I would like the player selected previously not to show up. Is this possible or do I have to rethink the way players are selected.
View 5 Replies View RelatedI have a combo: cmb_TrainingType. The sql is:
Code:
SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;
My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:
Code:
SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];
Both of the tables that are referenced have the fields TypeID and Type.
I have a text box in a form. When the value in the text box is changed, a message box appears asking if the user wants to change the value in the text box. If they select "Yes", all is good and it goes on well, but when they select "No" is it possible for the text box to retain its previous value?
For example.
The value in the text box is "1". The user changes this value to "2". A message box pops up asking if the user wants to change the value, the user select "No" and so the value in the text box goes back to "1", the number it started with before it changed.
i have a label and a combobox (the combobox is invisibile). in a form.
how do i make the combobox visibile when i click on the label?
I want to disable the previous row in the subform the moment I do a new row to prevent the user from editing information other users put before. Is it possible.
View 4 Replies View RelatedHi everyone,
I have two combo boxes on the same form bound to a table. I want the contents of the next combo box to change based on the previous combo selection e.g
cboContinent cboCountry
Africa Zambia
Africa Congo
Africa South africa
Europe England
Europe Holland
If I choose Africa in cboContinent, I want to see only Zambia, South Africa and Congo under cboCountry and if I choose Europe I want to see only England and Holland
Thanks
Humphrey
I have a database and one of the functions is to track the purchase of fuel. Part of purchasing fuel is registering what the current odometer reads. My query gets the Vehicle ID, Date of Transaction and Odometer reading. I want to show a report that shows how many miles the vehicle is has traveled for a certain amount of time. If it's for 2013 then I'll put the criteria for 2014 in the date. This will give me a list of all vehicles and their odometer readings. I then sort the date by ascending.
In the report I group on vehicle ID and then I want to show all their transactions and add up how many miles were driven.
Vehicle 1
1/2/201
1/5/2013
1/15/2013
ETC...
Total Miles Driven in 2014: XXXXXX
I'm having trouble with a Form and getting a text box entry box (Date entry) default to the date entered on the last record, which is linked to a table.
The only way I can get it to work is to type the date into the Text Box's Default property, for example, #11/13/13".
How to get the correct syntax or code into the Default property of the Text Box to make this work? I only want the entry to change versus the previous record/entry if the User changes / enters a new date.
Hi All,
I have an Access DB, which keeps having a problem with resources.
When I go in and refresh the resource, it works fine.. For a while then same problem comes up again.
I've had to refresh the references several times this week. Is this down to a bigger problem?
- Elfman
Hi, I have a simple form that requests to enter date using a textbox.
How can make the date textbox to display last entered data (in this case last entered date like 2006.05.05) after used pushes button "new record"?
HI
If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query.
How the smeg do i get it to remember the print settings?
Please help me im running out of hair!
Thanks
Hi all,
I had a small problem with combo box . Is there any way to store the previous value of the combo box. Last time Pat showed me a way to collect the value by .oldvalue property of the combo box and it worked fine. But it working only for saved record and one time only. If I choose different value one more time without saving the record, the .oldvalue is not changing..Is there any way to make this happen. I am attaching a sample db with this. If someone can clear this please update the db or show me the code to do that.....
Thanks in advance
Thanks
I have the following query that has been developed for me but it constantly asks for the password. Is there a way of storing/automating this for reporting?
Code:
SELECT dbo.tbl_staff.Name, dbo.tbl_function.funct, dbo.tbl_dates.CalendarDate, dbo.tbl_activity.Details
FROM dbo.tbl_staff INNER JOIN dbo.tbl_function ON dbo.tbl_staff.Funct = dbo.tbl_function.id
CROSS JOIN dbo.tbl_dates
LEFT JOIN dbo.tbl_activity ON dbo.tbl_activity.idstaff = dbo.tbl_staff.id AND dbo.tbl_activity.startdate = dbo.tbl_dates.CalendarDate
[Code] .....
I need directions on Cascade Combo Box, So when I select:
CD Group
Displays only the CD's in that Group that are related to that Name
So what fields would I have to set up for CD Group and CD NAme with that Table.
Someone emailed me an article on Cascade combo boxes what fields so I need for the coding.......
I have a combo box where I select a Hardware store. I want the address for the store to come up if a hardware store is selected. If one is not selected I want to be able to enter an address.
I have a vendor (hardware store) table, which contains the Hardware store and it's address. I can get the combo box to show the store selections but I can't get the address to come up after I select the store.
Is there a way to link text boxs to a combo box??
Thanks, Joe
Hello!
I have honestly spent the better part of the past two days searching this forum and trying (but failing) to find a solution to my problem.
I know that my question has been asked many times, and several possible solutions have been given... however, none of them work for me:-( Oh, by the way, I just started using Access (2003) this Monday, so please IF there are anyone that can offer assistance, please do so in silly detail...
I have a form with several combos. One combo I would like to enable only if one specific choice is selcted in the previous combo. The solution given to many before me is to enter the following in the After_Update field of the first Combo:
Private Sub Source_AfterUpdate()
If Source = "Contracted Operator/Agent" Then
AgentOperator.enabled = True
Else
AgentOperator.enabled = False
End If
End Sub
After I have done this, the AgentOperator combo does become disabled, but it is also disabled when "Contracted Operator/Agent" is chosen in the Source Combo. I thought the code was supposed to leave the "Contracted Operator/Agent" enabled??? Why is it not doing this? Why is it disabling with all choices?
I would be really grateful if someone can be kind enough to help me. I feel so stupid not being able to handle this one on my own. It really is hard to over the years have become somewhat of an Excel professional, but now I am a complete novice....
Thank you so much in advance!!!
G'day. I've been browsing the forum trying to find a solution to a problem, without much luck, and am hoping that someone might be kind enough to help me more directly.
I'm a biologist and a newbie to access: with the distinction of being completely clueless about VBA. Nonetheless, I have been tasked with creating a database for storing data obtained from biological surveys of juvenile salmon and harvest/spawner surveys of adult salmon.
The bones of the db are in place and functional. The problem I have is streamlining the data entry process to minimise keystrokes/mouse clicks.
I have a subform for entering fish records with attributes such as 'species_name', 'fork_length', 'count', 'presence of tags, etc. The idea is that fish can be entered as individuals (count=1) or groups (count>1) with attribute data at the appropriate level (eg, fork lengths only entered for individuals. We typically measure the fork lengths of the first 20 individuals of each species and then tally the remainder).
One problem I face is that fish often occur in schools, and it becomes quite tiresome to click and select the same species_name combo box value for each record when entering multiple individuals of fish of the same species.
What I would like to do is set the default value for that combo box (on the fish subform) to match the value entered for the previous record.
I suspect that you could use the after update trigger to execute some code to change the default value each time something is entered manually into the combo box. Unfortunately, I know nothing about how to write the appropriate code.
Can anyone offer me some guidance?
Thanks in anticipation.
Sincerely,
Craig Dolphin
I made a form for users to go back and see saved records as and when required. However my cascading combo box are not showing the saved information. Information is saved in back end.
View 5 Replies View RelatedAccess 2003
Database for tracking job search/applications
I have three tables: Job (includes employer, contact) and Contact (First name, Last name, employer), and Employer (Employer name)
Form.Job is the main data entry mechanism. On this form, I enter the job details. I select the employer from a combo-box that draws from the Employer table. I would like to select the contact from a combo-box that filters contacts and shows only those that match the Job.Employer selection.
:confused: 1. How can I make a bi-directional link so that a new entry in the employer combo-box creates a new entry in the employer table? At the moment, I get around this with a "New employer" button on Form.Job that just opens up the employer table, but there seems to be an updating issue - new names don't show up in the combo-box for a while
:confused: 2. How can I get the contact combo-box to show only contacts with an employer that matches the employer selected in the employer combo-box?
Note that I got this to work once by using a sub-form, but I don't really understand how (presumably Access defaults that did what I wanted), and I don't want to have to use a sub-form.
Ben
I have two combo boxes in my form. The first one has the option of selecting a or b. If the user selects a, the second combo box will have the options of c and d, if b is selected the options in the second one will be e and f. How can i do this?
View 2 Replies View RelatedHi,
Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES.
Thanks any help with be greatly appreciated
I am very new to Access and all that it entails but I have really learned a lot viewing everyones posts. I cannot seem to get my current problem solved.
I am trying to have a combo box appear depending on a preivous combo box selection.
1st combo box is "ApplianceCombo"
2nd combo box is "SpeedCombo" Set to Visible = No
1st Combo Box has
Dishwasher
Vacuum
Washing Machine etc
If they choose Washing Machine I would like my 2nd combo box to appear which they can then choose
1000
1100
1200
1300
Hope I have explained this well enough.
Thank you in advance for any help
Kim