Modules & VBA :: Automatically Fill In The Fields Using Combo Box

Jun 10, 2013

I have a form (Project Form) with (Project_ID,Applicant_ID,Project_description, etc). To make it easier for the user who may not know the Applicant _ID when he/she is adding a new project for the applicant, I want to put a combo box with the Applicant Names in it, and once the Applicant Name is chosen, the Applicant ID will be filled out automatically and be saved in the Project Table.

My Approach so far was adding a combo box with two columns(Applicant ID, Applicant Name), and basically adding the following code:

Private Sub Combo36_AfterUpdate()
Me.Applicant_ID = Me.Combo36.Column(0)
End Sub

This approach works well, when I select an applicant, the Applicant ID will pop up correctly. However, This ID is not being saved in the Project Table.

View Replies


ADVERTISEMENT

Automatically Fill Fields

Nov 7, 2007

hello all, any help greatly appreciated.....

I have two tables in the same Access 2003 database.

Table1 is called "Clients" and has address type fields, e.g. street_name, postcode, etc. It also has a field called CYPAN_area.

Table 2 is called CYPAN_Postcodes and has two fields; postcodes and the CYPAN area that postcode belongs to.

I want to create a function so that when someone enters the postcode in table1, the database searches Table2 and identifies which CYPAN area that postcode belongs to and automatically populates the "CYPAN_area" field in Table 1.


any tips greatly appreciated

Harry

PS I'm only a novice so I don't know anything about VBA etc, but I understand excel type formula

View 3 Replies View Related

Automatically Fill Fields

Nov 21, 2005

I'm kinda new at ACCESS, and I've accepted an assignment that is giving me some trouble. For beginners, I could use some help as follows:
I am constructing a data entry form that is keyed on PID (Personal ID). I would like to be able to have certain fields in my form (Name, Title, Department, etc.) fill in automatically from information already stored in a different table, also containing the PID (which I can set as key). I would like this action to occur either when the PID field has reached 3 characters or when the PID field has LostFocus.

Thanks for any help in advance.
MAE:

View 2 Replies View Related

Automatically Fill Fields

Jan 16, 2006

Is it possible to have some fields filled in automatically as soon as a certain value has been entered into another field. e.g. if a town is entered in one field, then the postcode is automatically entered into the next field.

View 1 Replies View Related

New User - Automatically Fill Fields

Dec 16, 2005

I am new to Access, but have an urgent need. I want to have certain fields (Yes/No type) to be selected based on a certain field (also a Yes/No) being selected.

It's very straight forward. Select West Coast, and the states CA, OR, and WA are selected. De-Select West Coast and the states CA, OR and WA are deselected.

Any thoughts? thanks in advance.

Warren

View 3 Replies View Related

Automatically Fill Fields With Related Data

Nov 30, 2005

Hi!
I have a table with several fields. I would like to have a lookup in one field (combo list - get data from another table field) and for 2 other related field have the coressponding data appear automatically according to the selection in the lookup field.

eg.
Table1
|Field1...................|Field2...............|F ield3...............|
|LookupField1Table2 |AutoField2Table2|AutoField3Table2|

Table2
Field1...|Field2... |Field3...|
Data1...|Data2...|Data3...|

I am not quite sure if my question is clear... I had trouble in describing it in my post...

View 2 Replies View Related

Is It Possible To Automatically Fill In Fields With Previous Entries?

Jun 15, 2007

Let's say in one table (called Employees) I have two columns, Name (the Primary Key) and Job (Both are text fields). One row contains "Jack" and "Gardener" in each column respectively. If I were to have a form for a different table where I select Jack's name from a drop down menu of all the "Names" in "Employees" and it then automatically fill in the next field with his Job (which would be "Gardener").

I really hope I'm making sense... Is this possible?

View 14 Replies View Related

Forms :: Students Details - Form View Automatically Fill Fields

Oct 25, 2014

I prepared students details in access, but when i look the form view students particulars looks automatically (like name, age, weight and address). But what i need is students details has to come after I enter the name.

View 1 Replies View Related

Field To Automatically Fill With Correct Value Based On Information In Multiple Fields

Apr 16, 2012

I have a database in which we are trying to have a field "Headcount" automatically fill with the correct value based on information in multiple fields. The "Headcount" field will be based on about 6 or 7 rules. Most of the rules i can figure out, but im having trouble figuring out what the best way would be to search for a single individual's projects when they are on more than one project at a time. I thought about using a counter of sorts to count how many projects someone was one, but how do I pick them out of the entire table once i have found out the number of projects? Would a for loop work best or just many if statements?

View 5 Replies View Related

Modules & VBA :: Automatically Fill In A Textbox On A Subform On Button Click

May 4, 2014

I have a mainform with a combobox and a button. What i want is when i click on the combobox and then on the button I want that the textbox in the subform automatically fill in.

The mainform name is FrmTakenInvoerenEnToewijzenAanEenMonteur,

The combobox name is Keuzelijst1,

The subform name is SubTakenInvoeren,

And the textbox name is txtOpdrachtnr.

I tried this code in on button click:

Me.SubTakenInvoeren.txtOpdrachtnr = Me.Keuzelijst1

But that doesn't work.

View 7 Replies View Related

Using Combo Box Selection To Fill Other Fields

Mar 12, 2005

I am new to Acces programming and have been tasked with making a database for work. I is a very simple database. What I need it to do though that I can't figure out is. Once the table is populated with information I want the user to be able to select a record from my combo box and then all the rest of the information from the record will automatically display in the correct text field so any changes can be made to it. So I have say Combo Box John Smith and when he is selected I want text field DOB to automatically fill with 01/01/1960 as that is what was put in there when he was first entered.

Thanks.

View 1 Replies View Related

Combo Box To Fill 3 Fields On Form

Oct 5, 2006

I have the fields City, State and Postcode in my Member's table. My Member's form has the same 3 fields.

I have the CityLookup table which contains the City name and relevant State and Postcode.

I want my users to be able to either select from the combo dropdown list to select a City or start typing the name and the name will be autofilled from the list - then the correct City name, State and Poscode will automatically fill the fields on my form.

i have looked at a number of combo box methods and can not get one to work for me.

Any help would be appreciated.

View 5 Replies View Related

Auto Fill Fields In A Form Using A Combo Field

Mar 21, 2012

I am trying to auto-fill address info from a combo field. I'm using a select query on a table for the information. It appears to work for the first field (Firm Address1), but then stops working on all the other fields.

View 3 Replies View Related

Modules & VBA :: Fill In Values In Column After Selecting A Value From Combo Box

Jun 4, 2015

I have a form that is a datasheet. it contains multiple records. One of the fields in that datasheet is a combo box. I would like to make it so when I select a value from the combo box it changes all the values of the other records in that column/field to what was chosen from that combo box. is that possible?

View 4 Replies View Related

Modules & VBA :: DLookup Fill Textbox After Combo Selection

Apr 29, 2014

I'm a novice when it comes to Access 2010, and I'm having trouble with DLookup syntax, and am going nuts. I have tblLookup, tblFees and Costs, and frmFees and Costs. All data entry is done in frmFees and Costs.

The tblLookup lists plaintiffs and the matter related to them. In the form, I made a combo box [Combo13] for plaintiffs and a text box for Matter [Matter], but whenever I enter the plaintiff, I get an error.

The error is:
Run-time error '3075':
Syntax error (comma) in query expression '[PlaintiffName]=The Plaintiff I Typed in'

The code I'm trying to use:

Private Sub Combo13_AfterUpdate()
Me.Matter = DLookup ("[Matter]", "tblLookup", "[PlaintiffName] =" & Me.Combo13)
End Sub

[PlaintiffName] is the column name in the tblLookup.

I looked around the forums but couldn't find anything that matched my setup.

View 3 Replies View Related

Modules & VBA :: How To Use Form Fields To Fill Numerous Records Under Same Column

Feb 2, 2015

I am using .FormFields to fill a quotation template in Word, but the subform I am retrieving the data from has rows of records under each column and I need to send more than just the first row to fill the required bookmarks in Word.

The code I'm using is

Set doc = appWord.Documents.Open("S:TemplatesQuotation Template - Test.doc", , True)
With doc
.FormFields("FirstName").Result = Me!FirstName
.FormFields("FirstName2").Result = Me!FirstName
.FormFields("LastName").Result = Me!LastName
.FormFields("LastName2").Result = Me!LastName

[Code] ......

View 4 Replies View Related

Modules & VBA :: Automatically Check A Box If Certain Fields Are Within Range Of Numbers?

Nov 2, 2013

I have 3 fields on a form PU_POINTS, SU_POINTS & 2_MILE_RUN_POINTS. The user enters a number 1-100 in each of these fields. If the user enters a number in any of the 3 fields of anything less than 60 then I want it to check a fail box. If the user enters all numbers 60 or more then i want it to check a pass box.

View 2 Replies View Related

Automatically Fill In Field

Aug 12, 2005

Hi everybody,

I have a table that has 4 columns as shown below:

(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)



-------------------------------------------------------------------
Store Name Invoice Number Customer Name Customer Address
Store1 1 Bob PO Box 55
Store1 2 Joe PO Box 789
Store2 3 Chris PO Box 1254
-------------------------------------------------------------------
On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.

I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.

Does anyone have any ideas?

-Chris

View 14 Replies View Related

Automatically Fill In The Values With Search

Aug 3, 2005

I have a table with date,item number,quantity,price.and so on...
Im using form to input new record and is there a way to automatically search the table and if I enter the item number, it will fill in the rest of the values with the previous record of the specific item number?
since the only thing that will change would be, most of the time, quantity and price? and also date and invoice number but I have that set up to repeat previous record until updated...

Thanks In Advance.

View 14 Replies View Related

Automatically Fill A Date In A Record

Mar 30, 2006

I've created a table.
Id= autonumber
tDate=date

Now I need something to fill this table with 365 records where tDate starts at 1-jan-2006 and ends at...you've got it!

I've got a Query that will add a date but I don't want to edit this 365 times.
Probably very stupid simple but please help

View 2 Replies View Related

Automatically Fill Field In A Form

Feb 3, 2007

I have inherited a database where the structure is that everyone has a People ID which is unique and is stored in a central table. However to create a person you create their People ID in the People table (the ID is generated by autonumber) and to make the rest of the database work you have to manually type the People ID into a separate field in the form to allow you to do anything further. How can I automatically add this new number to the people ID list?

Hope this makes sense

Wendy

View 1 Replies View Related

Fill HTML With Access Data Automatically?

Nov 18, 2004

Could anyone explain me the best way to fill external HTML pages automatically with data from an Access dbase?
I have spotted several commercial tools that use macro recording. Surely there must be another way using visual basic for example?

View 2 Replies View Related

Automatically Fill A Table From Data In Other Tables

Mar 20, 2006

I have 3 tables:

Student Info:
Student ID (Primary Key)
Name etc.

Assignment Info:
Assignment ID (Primary Key)
Assignment Number
Criteria Number

Grades:
ID (Primary Key)
Student ID - Linked to [Student ID]
Assignment ID
Criteria Number
Grade

What I would like to do is be able to link the tables in such a way that for each student entered in the Student Info table, entries are automatically entered into the grades table for each assignment criteria.

For example:
Assignment 1 has criteria 1.1, 6.3, 7.2, Assignment 2 has 4.2, 3.3

When John Smith is entered in student info, the grades table is automatically updated with 5 new entries in the form:

John Smith - 1 - 1.1 - Enter Grade
John Smith - 1 - 6.3 - Enter Grade
John Smith - 1 - 7.2 - Enter Grade
John Smith - 2 - 4.2 - Enter Grade
John Smith - 2 - 3.3 - Enter Grade

That way I can have a form that automatically shows the possible criteria for each assignment on the sub form for each available student without having to type it in each time.

Your help would be wonderful

View 2 Replies View Related

General :: Fill In Date Automatically When New Record Is Created

Dec 18, 2012

I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.

View 2 Replies View Related

Forms :: Automatically Fill Field Based On User ID

Jun 30, 2015

I have a table called tbl_post_staff, within this table I have an id number (autonumber), user id (text) and user full name(text). Then I have a form called ec_main with a combobox linked to tbl_post_staff, but stores its value in a field called officer_is in a table called tbl_extensions. also on the ec_main form is a text box that displays current user.

What I am trying to do is; on my form ec_main; default the combobox (Called officeris) to the staff full name based on there userid that is logged in. how can I do this?

View 12 Replies View Related

Tables :: Choose Number From Field1 To Automatically Fill Field2 With Appropriate Data

Jun 30, 2015

I have 2 fields in access table. In one field i fill numbers eg (1,2,3,4,5) drop down list. In the second field I need to fill another data. When I chose one of the numbers from Field 1, I want automatically fill the second field with appropriate data.

1 = 24857
2 = 24869
3 = 24899
4 = 24944
5 = 24994
6 = 24903
7 = 15480
8 = 15164
9 = 15482
10 = 15479
11 = 15468
12 = 15476
13 = 15489
14 = 15494
15 = 7524
16 = 7537
17 = 7523
18 = 7544
19 = 7533
20 = 7536
21 = 7539
22 = 7534

View 2 Replies View Related







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