Autofill Query?

Jun 16, 2006

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

View Replies

Need: To AutoFill Value From Table/Query

Jan 28, 2005

I'm hoping someone here can help me out with existing code or at least point me in the right direction... In one of the databases I am developing, I need to set up the ability for one field in NEW records to be autofilled with the next value from a table or query.

Details
My database includes the following objects:
tblSupervisors - supervisor information (including an indicator if they are 'active')
tblCases - case information including name of supervisor assigned to review this case
frmNewCases - allows data entry of new information to tblCases
If someone enters a new case, the Supervisor field would (in an ideal world) automatically fill in with the name of the next active supervisor from tblSupervisors.

Example
The active supervisors in tblSupervisors are Joan, Mark, Lisa, and Gary.

Case #1 is entered and the Supervisor field is automatically pre-filled as Joan.

When Case #2 is entered later, the Supervisor field shows Mark.

When Case #3 is entered later, the Supervisor field shows Lisa. However, because the person entering the case knows Lisa is on vacation, s/he can click a button and Lisa's name is replaced with Gary.

Finally (for this example), Case #4 is entered and Joan is assigned as Supervisor again.

Whew!

Okay. That's it. (I hope.) Any and all help would be GREATLY appreciated!

View 2 Replies View Related

General :: Autofill Using Query

Jan 21, 2015

How to do an autofill using a query. e.g. if the product code is entered it will complete the price of product (lookup and coding not an option)...

View 1 Replies View Related

Query Expression To Autofill Given Other Criteria

Jul 10, 2007

I have a grades_table with data regarding a grade a person gets.
It contains like Name, Date, Grade, Grader_Name, Month, Year...

I have another table (grader_table) that contains the Grader_Name, and how many Grades that grader needs done in a given month (i'm using two numbers to indicate month and year).

What I would like to do is I have a form where all info for the grades_table is entered. When the query is run, I would like to have the month and Year field use the date given to auto fill numbers.

So I picture it as like 6/5/07 is given, so the query records the date, but also stores the 5 and 7 in other columns. I tried this in my query for i think its title - Month: Month([Date]) but it says there one too many ")".

I have a feeling I may also need help with the actual retrieval of a months score since it will cross tables, but this is the big question for now. Any help is appreciated.

View 13 Replies View Related

Autofill

Mar 29, 2005

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.

View 1 Replies View Related

Autofill

Dec 10, 2005

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?

View 1 Replies View Related

Autofill

Apr 22, 2006

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

View 2 Replies View Related

Autofill

Feb 12, 2005

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

View 1 Replies View Related

Autofill

Apr 16, 2008

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.

View 7 Replies View Related

Autofill Help

Apr 3, 2007

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!

View 1 Replies View Related

Help!! Autofill Troubles

Dec 1, 2005

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 Related

Autofill Fields

Oct 22, 2007

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

View 5 Replies View Related

Autofill Fields

Mar 11, 2005

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

View 1 Replies View Related

Autofill Dept

Mar 28, 2005

View 2 Replies View Related

Validation Autofill ?

Mar 30, 2005

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:

View 5 Replies View Related

Autofill Subform

Feb 22, 2006

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? :)

View 1 Replies View Related

Autofill Text Box

May 5, 2006

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

View 4 Replies View Related

Autofill Form

May 24, 2006

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. :)

View 1 Replies View Related

Autofill Form

May 24, 2006

View 1 Replies View Related

Autofill On Checkbox

Jun 18, 2006

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.

View 2 Replies View Related

Desperate Autofill Help

Jul 21, 2006

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.

View 2 Replies View Related

Autofill Combo Box

Aug 15, 2006

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

Autofill Via A Combo Box

Sep 9, 2006

Hi 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

View 2 Replies View Related

Autofill In A Subform

Oct 12, 2006

I manage a self-made database of property deeds for my business. Since it often happens that there are multiple owners and multiple buyers of these properties, and that many of the owners and buyers are the same people from time to time, I think I can manage this database more efficiently by using subforms that autofill when I start to type a person's name. I hope this is possible.

My main table and form are based on the deed description. Each deed will have unique buyers and sellers and each buyer and seller can be on many deeds. Thus far I have created tables and queries for sellers and buyers. The seller subform is set up and can accept entries in the form view. When I scroll from record to record, the names seem to show up where they belong, so I'm happy with that. The problem is that when a name comes up a second (or more often) time, I end up typing the entire name in again. This sort of defeats the purpose of having related tables. How can I get it to recognize that the name is already there and perform an autofill for me? What am I missing?

View 14 Replies View Related

Autofill Problem

Dec 1, 2006

Hello friends,

I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box.

I have a table with the following fields:
PK - autonumber
Frequency - text
TimeD - text
TimeN - text

The frequency entry describes the frequency at which paramaters are to be measured, and Time1/Time2 are the times that are set by each frequency for Day and Night resp.

I know this has been discussed ad nauseam, but I have spent almost a week searching this forum as well as a couple of others, and just keep coming up short.

I have uploaded a zipped db that will better illustrate where I'm at with this project. Please have a look.

thanks in advance.

View 3 Replies View Related

Autofill From A Previous Value

Sep 1, 2004

Okay,

What I need to do is two fold. I have a table in which I track clinets coming in and using our services.

Question 1: I want to be able to have a a date field default to the date I first type in when I open the form and remain there in all
subsequent records till I change it. The data is only entered once a week and we usually have 400 client visits per week
with about 75 - 120 per day. So it kind of gets repeatitive to keep typing in the date. I am aware of the CTRL+', but the staff who use this database do not even want to do that.

Question 2: Next problem....How would I create an autocorrect function that will automatically fill in a name...i.e. I begin to type jo and it will automatically fill in the hn...but I want the values to come from previously entered data from past records, similar to the way Excel does it in spreadsheets.

Any Ideas would be greatly appreciated.

View 1 Replies View Related