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
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 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 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
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]
: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 have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
I am not a programmer so if specific code is required, I would need to know exactly what it is.
Your assistance is appreciated.
Two questions,
1. After my relationship table is built, is it possible to have some tables automatics fill in according to what another field in the table is inputed? EX: I have a Ordertable(orderID,itemID,Itemdesc), and a Inventory table(ItemID,Itemdesc), When you select an Itemid to put in the order form, the order Description from Inventory would appear in the Itemdesc of the order form.
Is this possible? If so how?
2. In tables, is it possible to make a cell = to something? So like if I wanted to add a subtotal and a final total after tax, I could use = * .08 or something?
Can I fill all cells in a column that dont contain any data with the same value?
I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".
Any Ideas?
Thomas
I have 2 tables tblcontact and tblinfo.
tblcontact
contactID-PK
Customer
Contact
tblinfo
infoID-PK
PONumber
location
I want to build a form and have a combo box autofill these fields on the form. how can i do this?
Thanks,
Tim
I am trying to self teach myself and I am sure I am going about his wrong.
I have a form with a fillable text box called ProcessCode, a drop down box called CostContainerSize, and a fillable text box called disposal cost. Their are dozens of possible process codes and container sizes of 55,30,15,5,P,Y etc... I want the disposal cost box to auto fill based on Process code and disposal cost. I wrote the following in the control source IIf([ProcessCode]="LF" and [CostContainerSize]="55","$65.00") THis works to auto fill, but obviously only for that particular set of parameters. I have tried adding "or " comments to include other sizes for that particular process code with limited success. I have tried IIf([ProcessCode]="LF" and [CostContainerSize]="55"or"30","$65.00"or"$50.00") among other variations.
Any help is appreciated.
Ok, basically I have enough Microsoft Access knowledge to be dangerous.
I'm in the military and built a database that keeps track of the members who misuse their government travel card.
What I'm trying to do is enter a SSN into my form and have it fill in their name, rank, unit, etc if they are already in the data base.
I'm pretty sure it is possible, but not sure how to do it. Any help would be much appreciated!
I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant figure it out. Anyone?? Im not very good with code but if thats what it takes thats what it takes.
View 2 Replies View RelatedHello everybody!
Im new in Access as well as in this Forum! Glad to be here :)
Im currently developping a small application in Access 2003 and here is my problem:
I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber"
Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox.
Note: SupplierName values are from other table: Suppliers
Any help is highly appreciated,
Thanks in Advance
Hi everyone,
I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:
API# Current Operator
---------------------------------
1 |
1 |
2 | Bob
3 | Joe
1 | Mike
3 |
2 |
I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.
Thanks,
Chris
Hi
Need some help with a table, or possible more to do with a form design..
I'm looking to autofill in a field depending on data that's in the previous field.
E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list.
It's probably a simple query or something I need to do..
can anyone help..
Thanks
Saifon
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
Your assistance is appreciated.
Hello !
I am having some headache trying to figure out how to autofill or validate some fields in a form. (pardon my english)
This is what i want to do:
I have a form with these fields
combobox named "status" (contains 3 values)
textbox named "date"
What i want to do in the form is to automatically set the status to a value when date is filled.
If someone could help me with this i would appreciate it alot.
:confused:
Can anyone please help:confused: . I am setting up a database for events for local companies, I have an events table (event title, date, time etc) and a company table (name, address, postcode, tel, etc) They have a one to many relationship, with the events table being 1 and the company table being many.
I have a main form with the event details and I want to add a subform for companys, but would like this form to autofill the companies address and contact details when I enter the company name. Is there a way you can do this? :)
Hello
I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.
Well I created a Form and what I want to do is this:
If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).
Can you please give me ideas on how to do this? Thanks a lot. :)
Hello
I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.
Well I created a Form and what I want to do is this:
If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).
Can you please give me ideas on how to do this? Thanks a lot. :)
I've searched the forums and Google. I've possibly come close to finding a solution, but can't quite get it right.
I have a checkbox that I want, when it's checked, to put the current date in a Date Completed field.
I know I have to edit the OnClick event, but the code has puzzled me.
Thanks for your help.
Ok here goes
I need some help with getting my form(form 2) to autofill from another form(form 1).
Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.
Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.
p.s why is it access books tell you everything except what you want to know.
thanks.
I 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 Related