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
Hello 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,
I have a form that has a field called scope of work which is a combo box that you have 3 options to select from.
I have set up a table called scope of work which has other fields
ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date.
The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date.
I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution..
If anyone has any ideas it would be greatly greatly greatly appreciated!!
Thanks a Bunch
I created a table to allow me to enter automobile information.. year, make model, etc.
Now how can i make certain "drop downs" dependent on next to autofill info?
Such as
make= ford
model= crown victoria
make= chevy
model=impala
such that they could not choose a
make=ford
model=impala
because "impala" would not be on that dropdown selection/choice?
I'm creating a database for a travel agency. There are 2 tables, one for customers and one for their bookings. I have established a relationship between the tables so the AutoNumber for customer ID links to a field on the add booking table.
In practice though, it would be easier to enter the customer NAME into the booking table and have it retrieve their ID that way to link them. This seems like I am missing something simple but can't fathom a way to do it.
The other factor is obviously more than one customer will have the same name so I may need to link first name as well to differentiate?
I am creating an access database for my employer which handles blood donating at different venues. I have come unstuck with a particular request.
They would like to create 3 autofill fields for "dates", which are dependent on the previous field "Venues"
There are different venues, which are visited 3/4 times per year. This data is stored in a separate "Venues" table.
On the main user form, they would like to see the dates available to donate, when the Venue field is selected (this is an autofill box, from the Venue table). So if the London venue is visited on 1/1/13, 2/2/13 and 4/4/13. When the user types London into the "Venue" field then the next 3 cells auto fill with 1/1/13, 2/2/13 and 4/4/13.
I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other).
Field 1Field 2
[facing][DISC_CODE]
un3
up1
dn2
Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry.
My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?
I have combo boxes set up with the different choices for major, minor, year, etc. Is it possible for these fields to have an autocomplete option? For example, there are about 30 different subjects that students can choose for a major, so rather than having to look for it in the drop down menu, could the person entering the data just start typing "ant" and have it automatically fill with "anthropology" for example?
I should also mention that the reason I made these fields into combo boxes is because I built SQL in the row source so that it is bound to the primary key but displays the description instead (with the column widths set to 0; 1).
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 RelatedHi 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
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? :)
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
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 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