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 Replies


ADVERTISEMENT

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

Form/Subform With Autofill In Both

Jul 22, 2005

I am creating an ostensibly simple database, but I need help trying to get it to work. There are three tables.

1.Users – UserID, Dept Code, LName, FName
2.Boxes – BoxNumber, Description, Contents, and many other fields
3.CheckOut (junction table) – UserID, BoxNumber, Description, DateIn, DateOut

I want to create a form that would have the User fields at the top and a subform with the checkout fields.

I need the user fields to autopopulate after filling in the UserID (primary key).

I need the box Description to autopopulate after filling in the BoxNumber (primary key). At the moment, the form thinks that I am trying to ADD new records. There are no new records (boxes) being added. I simply want to use the form to check out and check out boxes.

Any help is appreciated. Thank you in advance.

View 5 Replies View Related

Autofill 3 Text Categories In Subform

Nov 11, 2004

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

View 3 Replies View Related

Forms :: Autofill Multiple Rows From One Subform To Second Subgroup

Jul 1, 2014

So I have a master form, with multiple subforms on different tabs within the master form. This form is not used to look up data, just to only enter data in. In one of the tabs, I have a subform in the form of a data table where the person filling it in can put multiple locations of one dealership. In the next tab, I want these loctions to autofill into the next subform on the second tab in the data sheet. If I were to go with the solution of using an unbound textbox on the parent/master form to refernece the first subform and then have the second subform reference the textbox, how would I go about doing this? Just with the expression builder and conrol source? Am I able to autofill multiple rows of data from one subform to the other for one recond?

View 6 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 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 4 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

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.

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 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

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 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 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







Copyrights 2005-15 www.BigResource.com, All rights reserved