I am creating an orders form based of a query that has joined an orders query and a customer query.
What I want is in the order form when a Customer is selected then the address & contact information is automaticly populated in
following text boxes.
Thanks
- a noob
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies View RelatedI have created a database for tech calls that come into my office.
I have created two tables with information i need on my form
table 1 = Office Location ID and Office Location (ie Chicago and other towns)
table 2 = Employee ID, Employee, and Employee Location Code (ie Chicago = 1)
I have created a form with the fields that i need to record all the data.
What i want to do is create a Combo box for office location and place the 3 office locations via a field list. I then want to setup another combo box that would display only the employees that are part of the office location that was selected in the previous combo box.
If anyone could assist me in this it would be greatly appreciated.
Hello!
I am working a new solution that I figured I would try, I am normally a web based data man. I have worked with a lot of SQL and server side code, but to be honest, I have never really used Access in depth. And so I am facing some problems, that I know are possible, but I am not sure on the syntax or method of doing it. Perhaps I could get some good help:D
Simple example: I have 1 combo box on a form populated with a query, I want to be able to when that cb's data has been selected to populated another list based off of what was selected. How do I accomplish this? Thanks for any help!
I'm creating a database to assist with the sales operations of a hat shop. I have a form for creating new orders called 'Invoice' where the order number and date is set.
Within this form is a subform called 'Invoice_Order' (Continuous layout), this form is used for assigning order items to an order number.
Within the subform there are two combo boxes which search the Stock table.
1st ComboBox- diplays hat styles (E.g- v1/v2/v3/v4...)
Problem is; different hat styles are available in different colours based on the material used. I would like the second CoboBox to display a list of colours depending on the style of hat chosen.
At present i can only get it to display a list of colours for all hat styles.
Does that make sense?
Any help would be most appreciated
I have strange issue when creating auto populated text boxes which displays rows from combo boxes.
In one database auto populates works with simple text box Control Source edit "=[ComboName].[Column](NumberOfColumn)".
Somehow same method doesn't wotk in different database: here one time I have to insert VBA code at On change Event:
Me.TextBoxName = Me.ComboName.Column(NumberOfColumn)
And other time it wont work with On change but only with After Update Event (code is same).
Another thing this morning happens was that when I tried to add new record trough form where combo box and tex boxes are located, MS Office suddenly stopped working after selecting combo box selection (with message Microsoft Office has Stopped Working). It is 2013 version.
I got it work after deleting and re-inserting VBA code to autopopulate text box at After Update Event.
I'm trying to build an database for aircraft operators. I've got the basic tables structure and relationships but I'm stuck on building an search form to filter records by user input.I've got following controls on my form (unbound):
1. AircraftType (combo box) from tblAircrafts
2. CompanyName (combo box) from tblListOfAircraftsOperators
3. TeailNumber (text box) from tblAircraftOperators
4. AirportNameSearch (combo box) from tblAirports
5. PassengersNumber (text box) from tblAircraftOperators
6. ManufactureYear (text box) from tblAircraftOperators
7. SourceSearch (combo box) from tblInfoSource
8. CountrySearch (combo box) from tblCountry
9. CategorySearch (combo box) from tblAircraftCategory
10. EamilToOperator (text box) from tblAircraftOperators
11. InteriorPhoto (Bound object frame) from tblAircraftOperators
12. ExteriorPhot (bound object frame) from AircraftOperators
I need to enable users to search for aircrafts based on those criteria. As I mentioned I'm new to Access and I don't have any advanced coding skills. I have a query build to perform the search and this is the code I've managed to write so far:
SELECT AircraftOperators.RegistrationNumber, AircraftOperators.PassengersNumber, AircraftOperators.ManufactureYear, AircraftOperators.EmailToOperator, AircraftOperators.ExteriorPhoto, AircraftOperators.InteriorPhoto, tblListOfAircraftOperators.OpratorName, tblAircrafts.AircraftType
FROM tblAircrafts INNER JOIN (tblAirports INNER JOIN (AircraftOperators INNER JOIN tblListOfAircraftOperators ON AircraftOperators.CompanyName =
[code]....
Hi all,
i need help regarding linking Access to various Word documents.:confused:
the task consists in choosing a particular Country, Year and Month from Combo Boxes and then view the related reports in Word.
for example : United Kingdom, 2006, January
more than one report can be related to a particular country.
is there a way this can be done? (maybe through the use of LookUp for the folder path?!)
any help will be much appreciated.
thanks.
I am facing a problem. i am very amateur at access. I want to design a form on which there is one combo box and one command button. If i made a selection from the combo box and clik on command button it should show all the details related to that particular selection (say Shop Order) on a report. I dont know how to link this things.
report may be like..
Shop Order Description Length Width Hight..
Ax12 xxxxxx xxx xxx xxx
Ax 12
for a particular shop order selection there may be no. of parts that should show on.
like an assembly thing. Suppose Shop order for a bag is A23 and its different parts are belt and chain...
now
SHOP Order description ......
A23 belt
A23 Chain...
i hope i described my problem..
please do help if you can..
Thank you
Hemendra
Hello
I need to select information from different combo boxes. Using a command button, i would then like the information transferred onto a list box.
I have so far managed to link all my combo boxes so the result comes out on a list box. if one combo box is left blank, i get no information in the list box. is there a simple way of doing this.
Thanks
Dharmesh
there is a way to convert multiple text boxes to combo boxes all at once, rather than right clicking on them one at a time, and selecting Change to.
I have a form with about 50 fields and most of them need to be converted to combo boxes. I'd always done it manually one at a time up to this point, but I'm trying to build up my learning and look for smarter ways to do things.
Another quick request:
What would the code be for a button which clears the contents of a text box or a combo box on a form?
Many thanks,
Paul.
Hi guys, I have a related databes with about 20 tables.
My main table stores the data linking with most of the other tables. This main table stores football match records with player line ups. Initially I had a problem linking the 11 player fields in the main table to the player table, Icould only do it with 1, so someone at work suggested to link it using the lookup function. This worked brilliantly. However, now I am designing a GUI with forms but the forms have combo boxes where the lookup function was used and when i change these to text boxes, the players names are replaced with their ID numbers.
Is there any way of creating the form without the unsightly combo boxes, as they won't be needed, the GUI will be read-only. I look forward to your help!!
I have a table that has client names and addresses. I have designed a form to be able to invoice these clients and everything is fine however what I'd like to do is have the address of the client appear automatically.
I have set the client names in a combo box and would like their address to appear in either a text box or sunken label automatically from the table. Is this possible and how do I do it.
Please keep in mind that I've done basic programming so please be kind to this newbie :D
I have a text box on a subform that I want to use to control a combo box on the main form - I know it's not how things should be done but I've no choice - these are my instructions. I'm using Access 2000.
The text box displays a short data in dd/mm/yyyy format and when data is entered into it, it populates a field in Table 1. The combo box displays all the months of the year which it obtains from another table which only has months in it. The combo box properties have Limit to List set to Yes. Once a Month is selected, it populates the month onto another Table, Table 2. The months have all been assigned with a numeric identifier (i.e. 1 for January and so on) but only the name of the month appears in the combo box.
What I have to do is have the combo box update the month it displays based on the short date in the text box. I've tried the After Update event on the text box to no avail. The code I tried there that didn't work was:
Quote:
Private Sub txtDate1_After Update
Me!txtDate1 = Me!cmbMonth
End Sub
I've tried similar code in the On Enter even for the combo box and this too failed. I've also tried switching off the Limit to List property of the combo box and this didn't work either.
I've also tried to set the combo box so that it links to the exact same fields as the text box and while this did work, all it did was have the date be displayed in the combo box in short date format and not as the name of the month.
I'm struggling to understand if this update is even possible. Can a combo box that has a Row Source limited to options in one table which it then updates onto a field in another table be controlled by just part of the date from a text box?
May I start by saying Hi and that im just embarking on understanding Access 2003. I do know a little about DB as I have built programs in VB6 using databases. But now onto my problem which seems a simple one.
I have a Db called delivery. With columns as below. Mtno being the key.
Mtno Orderno Description Quantity Customer
I populate a combo box with Mtno, but on the click event of the combo box i wish to populate textboxs from the other columns.
Code used.
Private Sub Combo0_Click()
Me!text2 = Combo0.Column(1)
Me!text3 = Combo0.Column(2)
End Sub
text2 gets populated and updates on the click event of the combo box but text3 doesnt. Niether do the other text boxes when I put the code in.
Help me understand this please.
kind Regards
Tony
Hello I hope someone can help me on this one.
This is something I am not getting an understanding on and need some help.
I made a form that holds all information for our customers.
I want to make the Company Name box into a combo box so when I change the
Company Name in the combo box it populates all the text boxes on the form with
the correct data.
I for the life of me do not know where/how to even start to do this.
I would attach my database but I cant seem to get the file small enough. I have deleted the large table and it is still 7megs. How do I get it small enough to attach it?
Thanks for the help.
:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:
View 1 Replies View RelatedI need to populate a text box with data from a single cell contained in a table.Im hoping to use two combo boxes that when selected will select the cell. The combo boxes select data sources from the same table. One combo the row the second the column. One combo is already in use and populates several fields in the form. In the same form I'd like to place the second combo and beneath it have a text box that will populate with that cell detail.
View 3 Replies View RelatedMy form's 10 column combo-box (based on a query) won't break into text cells. Some of the columns contain numbers, some test, some phone #s. All columns show when I click the Combo-box in Form View. Access Help File said to put:
=Forms!Customers!CompanyName.Column(1) in the ControlSource for the text cell. Tried that and was returned #Name? for any of the fields in which I tried it.
My expression was:
=frmSpartanStudentBehaviorLog!Last_FirstUC.Column (3)
The other properties in combo-box are set correctly: ColumnCount=10, Column Widths are correct.
I also tried the expression:
=Last_FirstUC.Column(2) but got the same result #Name?
I'm baffled. As a very new user, I'll appreciate any assistance. Thanks.
I've searched for this everywhere but I haven't yet found a solution, even though I'm sure it should be pretty simple.
I have 2 combo boxes: cboMonth, cboDay
and a text field: txtYear
cboMonth has values: Jan-Dec
cboDay has values: 1-31
After selecting the combo boxes and entering the year, I want the result to be displayed in a text box, with the format of Long Date.
How is this accomplished?
Thanks for any help!
Hi,
I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes.
For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box.
Thanks a bunch!
I have a form with two combo boxes. The first box lists switch names from a query, and the second lists switchports from another query. The switchport query lists all the switchports for whatever switch is selected in the Switch Name combo box, and all the settings for that port (one column per setting). I want each text box to display the corresponding data from the switchport query for the switch selected in the first combo box and the switchport selected in the second combo box.
View 3 Replies View RelatedI am creating a query that should filter records of events based on multiple fields. The filters should work with any combination of field criteria, but only two of the four field are working properly, as follows:
1. a text box for searching with event name (free text) - this is working;
2. a combo box to filter events by country name - this is working;
3. a combo box to filter events by event's keyword (category) - this is NOT working;
4. a combo box to filter events by year - this is NOT working
GOAL: select the IC number from the combo box and have 5 text boxes auto fill.
I have a table made for the IC number drop down. The columns represent the fields that need to be auto filled.
Making some kind of query to link the combo box entry to the text boxes? Some VBA where the control source is equal to my query? I have tried changing the text box control source to equal columns from my drop down but that did not work.
NOTE: the blue font in the first image represents the text boxes that need to auto fill when I select the IC number from the drop down. The second image is my table from which my combo box is generated. The acronyms are for the two tests on this form.
I have a form that our operators use to do their hourly quality audits on. This is getting to be a huge burden on them because right now, they enter the date, the week ending date, the month every time they have to do an entry, and for me it is a nightmare because they can still enter the wrong information. So, what I was wondering is if there is a way that I can have them select the date from a combo box (easy enough), but from that, have the week ending date and the month fields automatically update as well. Any advice? I would really appreciate it! Thanks so much!!!!
View 3 Replies View Related