Hi all
I use a form that has a combo box and a text box.The combo box values are
Email,Cna,Dna.I manage to make users to select values from combo box and show it in the text box.I want to ask if it is possible when user select "Cna" and "Dna" from the combo box the same will appear to text box but the text box will be locked.If you choose email it would be enable.
Thanks
: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 RelatedAutofill text field using combo box selectionHello,
I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.
The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".
A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection
There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:
REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.
I am using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies View RelatedI have 2 forms with 1 combo box in each form. I would like to be able to choose, for ex. a date in 1st combo box and be able to have that displayed in the 2nd form in the 2nd combo box.
View 1 Replies View RelatedHi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused)
Anyway
I have a form which is based on a table that holds all the info for orders placed by customers.
It holds info on all the orders plus some info about the customer
Example of Orders Table
Order ID
Customer No
Suburb
State
Item Number
Qty Ordered
Description
Length
Weight
Order Type
Day Received
Last Dispatch Day
Actual Dispatch Date
Comments
Date Due at Customer
On this form I would like a combo box which is linked to a Customer table which has all the details regarding the customers. When I pick the customer I would like all the other fields relating to the customer on this form (Customer No, State, Suburb) to be auto populated to save entering data individually.
Example of my Customer Table
CustomerID
Customer Name
Customer No (not unique)
State
Suburb
Customer Factory
Rail Terminal code
Destination Rail code
Destination Road code
Cust Code
I have tried many different ways but no success.
Any help or advise would be most appreciated
Tks
Hi, I hope some one can help me with a few questions I have surrounding combo boxes:
I imported a table into Access from Excel. I then created a form based on the table. Here is what I would like my combo boxes to do:
For my records that already exist, I want the combo boxes to list all data for all records in the drop down. So in my DB, I have a state abbreviation in that field, so in record one it may be CA and in record 2 it may be NJ, I want it so that you see NJ and CA when you click on the drop down.
For entering a new state, I want a user to be able to choose from the drop down and it save to the table but also be able to add a new state if it's not listed. Then that new state should be added to the drop down list.
I'm not sure if this is possible but if you can give any suggestions, I would greatly appreciate it.
Thanks
Sorry me again,
I have a combo box for rooms: single, twin, double, suite, grand suite
This is found from a lookup table
In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box when the type of room is selected?
Thanks
Anyone know if an input box can have an autocomplete like Comboboxes? So say I type the string "Blue House, Red Carpet, Green Grass" and enter it. the next time I go to enter in a value and start typing "Green Grass", the form, auto inserts it, and as I start typing "Blue House", it is also auto inserted. anyone know if this is doable?
View 2 Replies View RelatedHello-
I'm new here. I think this is the right place to ask.
I'm on Win98 using Office 2000.
I have a database that I use to run a PERL script for the record store I work at.
The database spits out a text & tabs document via a query that I then run PERL on.
My database has these fields:
date added
e-mail address (Primary Key)
name
wants
destination
In my form to enter, I use keywords that correspond to catagories in my website (I sell music, records & CDs) and also exact terms for if a customer is looking for specific items.
an example would be:
20060308
tim@couch-fort.com
Tim
*clrock~~*clrockcomp~~beach boys~~bob dylan
1
The "~~" is a separater for the PERL job.
Is there a way I can put checkboxes on my form that will auto fill data that repeats often, while leaving space for some hand typed info too?
Hi all,
I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!
Hi all! :D
I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc.
So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box".
The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them.
So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused:
Thanks... :)
I have a form which shows contact information. I have added a combo box which automatically shows the information of the selection in the combo box. So, far no problem.
However, what I would like is that (since there will be a lot of contact in it) you can search inside the combobox. Say, for instance, you have the following info:
1. Albert Einstein
2. Ally McBeal
3. Anastacia
4. Bob Dole
When you enter the 'A', only the first three items stay in the combo box. After entering 'AL', only the first two items stay in the combo box.
How should I go about creating such a combo box? I already saw that when entering characters, it selects the first item that corresponds with the characters entered.
Also, when placing a combo box on the form, linked to the form (a standard function in Access) ... how do I select the first record of the form in the combo box?. Say that Albert Einstein is the first item which is shown in the form, it should also be selected in the combo box. Now, the combo box stays empty.
Any help is appreciated!
Jazz
I have a form for recording site details and have been trying to autofill three of the four categories.
What I have is a Site Index Table that contains the site ID, Name, Description and Type. I want the results to
be recorded in an Affect Table that will also contain text data associated with these fields that I will enter
in manually.
I then have a form with the four fields; the site ID and Type are both bound to the Affect Table that records all the data
associated with each site. The Name and Descritpion source their information from a seperate query of the Site Index Table.
So what I want to do is to select the site ID on the form from a combo box I've created, and once selected it will automatically fill in the relevant text data into the Name, description and type categories on the form. I've been trying scripts with the DLookup function but have continued to encounter errors. If anyone can help PLEASE help me as i'm a novice when it comes to Access
Thanks
Is there anyway or code to autofill a bound text/combo box for instance with the person who is working the database i have this code but doesnt work with bound boxes
Me![Agent] = Forms("loginform")![cbousername]
I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns being used to determine its own possibilities and other combo box possibilities.
I would really just like the text box to work like this, but im still kinda inexperienced in VBA...
If combo box is "F004-001", then text box is "237"
If combo box is "F004-003", then text box is "280"
I know how to add in an "after update" thing, but i do not know how to do If/then statements.
I have been creating a form, based on only one table. Here I am displaying data as text boxes and subfrom from the same table. At the beginning, I was interested in controlling the display of the data according to the combo box (in this case is the PO number). Now, I would like to add another combox box which is the year (I have a column with the date, and also I have a column that shows only the years digits in my table) Also, I have a subform that display the data from the same table specifics records that I want. It means that I want to pick the year first, and then in the combox box of po number shows only option of that year, and hence the text boxes and subforms change accordingly to the two combox boxes.
View 2 Replies View RelatedI am trying to print on report the value of combo box which is based on the query
SELECT qryDept.DeptID, qryDept.Department
FROM qryDept;
with formula
=[Form]![FormName]![comboboxName]
But my problem is its printing ID of the combo box instead of text value which is name of the dept. say HR
Hi,
I have a combo box on a form with three values, when I select one of the values I want a text box to show a corresponding value.
The combo box has three values for different types of memberships; under18, over60, and standard, these have different prices. So what I want is for when one of the values is selected the text box will show the price.
Any help on how to do this? The database is below.
Is there a way whereby I, or another user, can amend the ‘TOP’ value of a query via a Combo or Text box entry on a form? I have searched this Forum for a solution to this very problem but have had no success. I understand how to achieve this via the queries ‘SQL’ view but cant figure out a way to do it by the way that I have already described!!
Your advice or a ‘pointer’ in the right direction would be extremely well received.
Thanks for your time.
Have a nice day...
Kind Regards
CarolW
Hi,
This one is really confusing me!
I have a text box on a form that is bound to a field in a table that is populated by a combo box coded into the table whose data source is a select query.
Everything looks fine in the table, but when I display the data on the form it is displaying a different field of the source select query than the one displayed on the table.
Why is this, and how can I fix it?
I've a form with a combo box "OrderNumber" (to allow the user to select the correct order) and a text box "Date" which displays the date of the order selected.
The problem is that I don't know how to synchronize the boxes.
I know the procedure to do it with two combo-boxes (cmboDate=Null & cboDate.Requery in the after update property of the cbo "Order Number"), but is it possible that when I change the order selected in the combo-box, the text box shows the correct date?
Thanks for your help!
Hey guys
This is the problem,
I have 2 fields in a table. Cityand Country.
City Country
paris.......France
madrid....Spain
london....England
milan.....Italy
Rome.....Italy
ETC
Field "City" is connected to a combo box and field "country" to a textbox on the form.
I would like the user to select a city from the combo box. When this is done the textbox linked to the country field should automatically update to show the correct country. This should update without user intervention.
I would find it better to have the text box look up a value list rather than use a table for its source. the form is being used as data entry. The combobox linked to field "city" is also a value list.
Thanks in advance.
Nitesh
Aaaargh! It's a couple of years since I got my hands dirty in Access and I seem to have forgotten more than I thought! :(
I have a simple database which includes tables STOPS (stopID, stop name, routeID, Cost band), JOURNEY(CustID, routeID, stopID), and ROUTES (routeID, Route name, Bus co).
I have a main form with the customer number on linking to a sub-form on which the user will select the route from a combo box and then the stop from a combo box. All works fine but I want to filter the stop combo box to show only stops on the route already chosen.
I've done similar before but I have tried all sorts and failed to get anything to work. Any help appreciated.
I have a combo box that I use a barcode scanner with. I scan the barcode and it finds the product using the code below:
Private Sub cmbBarCode_Click()
' ADD A TRANSACTION AUTOMATICALLY
Dim RS As ADODB.Recordset
Set RS = New ADODB.Recordset
RS.Open "SELECT * from tblTransactions", Application.CurrentProject.Connection, adOpenStatic, adLockOptimistic
RS.AddNew
RS!OrderID = ID
RS!Barcode = cmbBarcode.Column(0)
RS!Manufacturer = cmbBarcode.Column(1)
RS!ProductName = cmbBarcode.Column(2)
RS!QuantitySold = -1
RS!Cost = cmbBarcode.Column(4)
RS.Update
RS.Close
Set RS = Nothing
lstTransactions.Requery
End Sub
What I need to happen is all the above but after it has finished or before it starts it needs to clear the contents of the box. So the barcode is entered it runs the above script and then removes the barcode from the combo box, so I am ready to scan the next barcode.
Thanks,
Danian
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