Modules & VBA :: Auto-fill On Variables

Apr 9, 2015

I have a Change Management database with several fields, the key fields that I need to talk to work together are as follows:

[Patch] , [CVE] & [Patch Approved]

When opening a form I have I can sort it by the patch number which will then sort out all other CVE's that are not associated with that patch. What I would like to be able to do is approve one patch under the [Patch Approved] field and have it carried through the rest of the filtered CVE's that have the same [Patch] number/ field.

View Replies

Modules & VBA :: Auto Fill Between Two Tables?

Jun 21, 2013

I am in Access 2007. I have two tables (Employer Contacts and Employer Followup). I have been successful in linking the "Employer Name" sections between the tables, and I have added to the "Employer Followup" table a combo box for the "Employer Name" field that when clicked successfully shows all the companies we added to "Employer Contacts" table in the field of the name "employer name". This is what I want. Now the trouble comes with trying to get the data from the fields; Location, contact name, original contact date, phone and email to auto fill into "employer follow up" using the information captured from the "Employer Contact" table. I can see it all in the drop down box but cannot get it to auto fill.

View 2 Replies View Related

Modules & VBA :: How To Auto Fill Excel Template

Jun 19, 2013

I have info on my access form which is located here....

Code : Forms![Front Page]![Site 2 Owner]

and here

Code : Forms![Front Page]![Postcode S2]

I would like to export this information into cells B2 & C2( individually and respectively) on the excel spreadsheet which I have saved as a template here...

Code : C:UsersmedesktopAutoExcel Auto

Is this easily achievable? To be honest I will be using it to fill in about 12 cells but how it would be done for the first two i can just modify it as necessary.

View 6 Replies View Related

Modules & VBA :: ComboBox Pulls From Table Will Not Auto-fill

Nov 5, 2013

I am having problems having my combo box auto fill the next text box. The table it pulls from is called Code-LeaseProvision and it has only 2 columns in it. So when built the combo box it pulls the both rows. One is labeled "Code" and other other "ProvisionDescription" I have it set when you use the combo box it fills Code but it will not fill the next text box labeled "ProvisionDescription". So when I put the event into the ProvisionDescription afterupdate as a VBA code. This is what I have:

Private Sub desc_AfterUpdate()
Me.[ProvisionDescription] = Me.[Code].Column(1)
End Sub

It fills the combo box but will not fill and update the LeaseProvision Text box.

View 9 Replies View Related

Create Textbox To Fill In A Set Term For Multiple Variables?

Mar 18, 2014

I am building a database for a martial arts program for older/elderly adults. I have a section that measures their physical capabilities. I need to create a text box that will fill in if their abilities are below average, average, or above average on one of the tests. The problem is, the test measurements are based on age and a range of repetitions.

For example, men 60-64 need to do 14-19 reps of the exercise to be average and women of 60-64 need to do 12-17 reps of the exercise. Men from 65-69 need 12-17 reps and women of the same age need 11-16 reps of the exercise. I have a box for their age (on a separate table from the rest of the information) but I need to figure out how to allow someone to fill in the number of reps a person did and have if they were average, above average, or below average filled into the last box based on that number, their age and their gender.

I tried a combo box, but I can't seem to figure out how to create the table to get it to work.

View 5 Replies View Related

Auto Fill

Jun 8, 2005

I've tried googling this, but I can't find anything helpful. I have five columns in my 'Main' table. In each row, column B, C & D are solely dependant on column A. And column E is completely independant of all of them. I want to be able to select a choice in column A using a drop-down menu (which I know how to do) and have columns B, C, & D automatically fill themselves in (which I don't know how to do). Column E I would just manually enter.

How do I get columns B, C, & D to automatically fill themselves in my 'Main' table. I would select a value from a drop-down menu in column A and want everything else to fill in. The values for A,B,C,& D are all in seperate tables with an ID and linked to their respective fields in the 'Main' table. Appreciate any help.

View 1 Replies View Related

Auto Fill

Aug 14, 2007

Hi

Does anyone know how I can auto fill all the records of a field by just entering it once

Thanks

View 2 Replies View Related

Auto Fill

Jan 17, 2008

I am looking to find the experssion that will allow me to put a date in a query under date completed and have it fill another field for schedule.

I know that in Excel it would be =sum(A1 +90 ) and this will give a date 90 days after the date inputed into field A1 and so on down the column. and it would auto fill the next column for me

View 2 Replies View Related

Auto Fill? Help Me Please!!

Sep 27, 2005

In using a form to input new information, I want to utilize the autofill feature, but I don't know how.

For example. When someone inputs a month, I want the season to be automatically entered in, in the following entry.

Can someone please give me some direction or help me to do this!?

:D Thanks!

View 1 Replies View Related

Auto Fill

Dec 12, 2007

I have an access database with information that is posted to through a form. On the form I have a dropdown box with a list. After choosing an options I want a text box to auto fill from data in a separate table in the same access file. I have been trying different things for about a week, and I have done alot of reading.

View 2 Replies View Related

Auto-fill Question

Jul 15, 2005

I have a subform and when the controls on it are updated, changed from previous info, then I need a control(called dtmUpdate) to show the current date (=Date()).

How would I go about doing this?

Thank you

View 5 Replies View Related

Auto Fill Problem

Mar 31, 2006

I am trying to auto fill feilds when I select from a combo box. I have tried to use help, but I can't get it right.

View 1 Replies View Related

Auto Fill Yes/No Field

Mar 7, 2006

hi. this might be simple for others but i'm new with access. how can i automatically fill a YES/NO field referring to a Text field. which means, if the field is EMPTY, it will automatically say "No or False" in the Yes/No field, or vice versa.

thank you people of great minds and kind heart. more power to you all.

View 6 Replies View Related

Auto Fill Problem

Mar 9, 2006

Hi,

I am trying to write a database that has one table for companies and another for the services they hire.

The objective is to end up with a managable excel sheet that imoprt into an accountancy package. (Using Acess to eliminate several sheets in current procedure and also free up 1.5 days PCM data entry time).

I have set an auto look up that will autofill the required fields into the form ( =MYQUERY.column(1) ). This works fine and does what i need it to. My problem is that it does not write back to the table so I can not run an outputto command.

I do not know of any other way to produce the autofill to try another way. I have looked at the setup and can not find any problems.

Does anyone have any ideas to help me out?

craig@lenihan.me.uk

Thanks

Craig

View 1 Replies View Related

DLookUP Vs Auto Fill

Mar 28, 2005

Alright, I've tried just about everything else, now I need to tap into the grapevine for some help. I've read every thread about auto pop info, DLookUP and auto fill. I'm so lost and confused. I'm an Access 97 beginner and can't seem to get my form to do the things I need. I'm working with an existing form and trying to get text fields to auto fill with an "After Update" command. I'm not familiar with VB coding and the function isn't working. If someone out there can help me, I'd really appreciate it.

View 12 Replies View Related

DLookUP Vs Auto Fill

Mar 28, 2005

View 3 Replies View Related

Need Help With Auto Fill In A Form

Apr 24, 2005

I am a new access user and need some help. I have created an auto fill query to fill in information on a sales order table from my customer table based on CustomerID.

I have also created a sales order form. When I enter the customer ID in the form the rest of the data does not fill in. Actually nothing happens.

How do I link the form to the query so that the form knows where or how to look for the auto fill customer data.

Thanks

Darrell R

View 1 Replies View Related

Auto Fill In A Subform?

Aug 9, 2005

Here is what I have so far. Table 1 has employee info. Table 2 is for the courses that employees take. Table 3 is a listing of available training courses. What I have done is created a form with all the employee info and linked it to table 2 by ss #'s. What I am wondering is if I can create a field, lets say course #, in table 2 and table 3. That way when I input the course number into the subform, then the corresponding info from table 3 is inserted, ie course name and course hours. Any suggestions or help would be great.

View 1 Replies View Related

Form Auto Fill?

Oct 25, 2004

I have a database with a table of all our records. I created a form, and would like to be able to type in the last name in the last field and have it bring up the record. Also, this could be a problem because there are several people with the same last name. How do I do this? Thanks!

View 1 Replies View Related

Auto Fill Problem

May 1, 2006

I am desperate for some help. I have 2 forms.

1. School
2. Venue

I am entering school names into the school field in the school form. I want that information to automatically appear in the school field in the venue form. I know nothing about VB. Can anyone help me?

For a temporary solution I put a refresh button on the school form so after the information is entered into the school field you have to hit refresh and then that adds the data to the school combo box in the venue form.

Martha

View 2 Replies View Related

Auto Fill Form

Aug 7, 2006

can I have fields in a form auto filled from fields in another table?

View 1 Replies View Related

Need Help With Auto-Fill In Forms

Mar 21, 2007

Hello,

First post!

I'm looking for help with auto-fill (more specifically, I believe I need to use the "After Update" function.

What I have is an order form where I will be putting customer orders. I have a form and a subform, and the line items for the actual order go in the subform. Therefore the subform has a combo box for "products" which references the "products" table by fetching "productname" through "productID"

What I need to happen is when I select a specific product in that combo box (which works), I would like the "price" to be auto-filled into the "Price" box I have to the right of "product" and "quantity"

However I can't figure this out for the life of me, and I've searched places and tried different things, but I always end up with it not working. I can do this in Visual Studio with a DDL and a Label and a small function, but Access is way different from what I can tell with my little knowledge.

Any help would be appreciated!!

Thanks!

View 2 Replies View Related

How To Auto Fill Value From Another Table

Mar 23, 2013

How to auto fill value from table3 to table1 and 2 ? for exmple, ShareID and Contract#, move from table3 to table1 and 2.

Table1

ShareID
ShareName

Table2

ShareID
Contract#

Table3

Date
2/2/2013
Contract#
123
ShareID
AAPL
ShareName
Apple
Cost
Quantity

View 3 Replies View Related

Auto Fill A Product Code

Aug 23, 2006

Hi

In my database i have a field called product code which the user enters the code as T0001, T0002, T0003 and so on for each record.

would it be possible when adding a new record for that field to auto fill the product code as T0004 for example, so the user doesnt have to type the code in all the time.

please help, ty

View 1 Replies View Related

Auto Fill On Table Field

Mar 6, 2006

Please help

I have 2 tables:-

1 Master Input Table.
1 Job Lookup table - (contains Job Number and Name)

When in-putting job details into the Master Input table i would like to enter the job number only and have the job name appear automatically without running a query, much the same as a 'vLookup' command in excel.

Is this possible?

Can anyone help?

View 3 Replies View Related

Auto Fill In Data From One Table To The Other

Jan 9, 2008

Its been a long time since I did dB work - stopped back in the days of dBase IV.

Still, using Access 2007 is not that difficult - except right now. I have 2 tables; one with customer contacts, the other with project details. Heres what I want - hopefully someone can help:

Within the project table, select from a lookup into customer contacts a name, which then auto fills in the fields for phone and email in the project table. I want to do this in the table or form, but have the data deposited into the table for sure!

Any help really appreciated.

View 2 Replies View Related