Help In Auto Filling A Subform

Nov 11, 2005

I need to auto populate a sub form.

Main Form
ID
Top Assembly Part Number
Top Assembly Serial Number

Sub Form (continuous form)
ID
Part Number
Part Name
Part Serial Number
Main Form and Sub Form linked by ID


(There is a separate table that has sub form part numbers for each main form part number)

Based upon the part number in Main Form I need to automatically populate the sub form with Part Number and Part Name.

Some Main Form Part Numbers have 85 sub form part numbers others as few as 3 sub form part numbers

Main Form
______________________________________
|
| ID [123 ] |
| |
| Part Number: |9999999 |
| Serial Number: |ABC-9999 |


Sub Form
_____________________________________
|
| ID [123 ]
||Part Number | Part Name | Serial Number |
|| 1111 | Widget 1 | A11111 |
|| 2222 | Widget 2 | B1234 |
|_____________________________________

View Replies


ADVERTISEMENT

Auto-filling Fields Based On Another Field

Dec 7, 2004

hi all...

i am the biggest of all newbies when it comes to access and understand only the graphical parts of the process (no SQL knowledge etc.).

how would i go about auto filling a certain field based on what's in another field? for example, i have a field called TimeZone that i want filled with either West, East, Central, or Mountain based on another field for State. can i build a query to automatically take care of any empty fields for TimeZone that haven't already been filled out by me manually?

if i need to use SQL, that's fine too as long as the directions are clear and precise as i have no prior knowledge.

thanks a bunch.

View 4 Replies View Related

Forms :: Drop Down Box Auto Filling Other Entries

Apr 26, 2013

I've created a drop-down box on a form, that allows a user to choose from three names.

However, when I choose say name A, it then populates all the other entries with name A.

For example:

record 1 has name A
record 2 has name b
record 3 has name a

if i then enter a new record, and enter name C in it, it changes records 1, 2 and 3 to show name C too.

is there a setting i need to change or something?

View 1 Replies View Related

Forms :: Combo Box And Auto Filling Fields

Jul 6, 2015

MS Access 2010

I have a form "Admin" used to create new records in a table "RCJ"

I have a table called "Projects" that contains detailed information for projects.

I have a table called "Waterfall" that contains basic information and schedule information for each particular project.

I have a combo box "Contract" that selects information based on a query "Core" that gathers certain information I want to use of form "Admin"

I understand it's generally not a good idea to duplicate data in tables, but for specific reasons I am here. My combo button "Contract" has an event "On Click" that gathers information I want copied from table "Waterfall" via query "Core" is:

Private Sub Lookup1_Click()

Me![Project Description] = Lookup1.Column(1) =>goes to a text box
Me![TContract] = Lookup1.Column(3) => goes to a text box
Me![Requestor] = Lookup1.Column(5) => goes to a combo box
Me![AEM] = Lookup1.Column(4) => goes to a combo box
Me![AE] = Lookup1.Column(6) => goes to a combo box
Me![Priority] = Lookup1.Column(12) => goes to a combo box
End Sub

Now, the items listed above are sometimes just a text box and sometimes a combo box (because there are times, when items get entered that don't fit the original combo box.

Now, here's the rub. When I select the pull down on the combo box it lists all available projects. You find the one you want and select it. At that point, only Columns 1 (text box) and 6 (combo box) auto fill. The other information does not fill in .. BUT, if I more to the prior record and back, all information shows up OR if I click on any of the particular fields, the information shows up in that field. In theory, everything should show up right away.

I thought it might be because it doesn't like to autofill a combo box, but one of the combo boxes fills fine. And all of the information is acutally going to the various boxes, it just doesn't show up right away.

View 10 Replies View Related

Queries :: Auto Filling User Details

Nov 4, 2013

I have been managing a database system for a homeless shelter in my volunteer role. There is a certain feature that would improve accuracy of the inputted records, as well as freeing up time for staff. That is - auto filling a user's Gender and Nationality when inputting a record for the drop-in centre.

Currently, when a forename and surname is inputted in the "DropIn_Input" form, it is checked against the stored 'service users' table and checks for the name combination. If the name combination is not present then the forename and surname fields change to 'New'.

What I would like is to keep this, but if the service user name is stored in the 'Service User's table then I would like their Gender and Nationality to be automatically filled into the fields on the 'DropIn_Input' from the relevant information in the 'Service Users' table.

View 2 Replies View Related

User Login And Have Their INITIALS Auto-Filled When Filling Out Forms

Apr 17, 2013

I have a database where multiple users log in and work in 1 of 2 different forms. The 1st form in for initial data entry where users enter data then senter there initials and save each record. the other form is for QC'ing data that has been entered and they will add additional data to the form, then enter their initials and save the record.

How can I make it so that I can have a user once they log in to the database, it will autofill their initials? I have used a dropdown box before but it is not useful for people who have the same first name initial or worst, the same first and second initial because they end up selecting the wrong initials.

I do not currently have it set up where I have a login screen, I just have only forms visible to users when they enter data. Any easiest way to go about making this happen (I am just trying to shorten the amount of data entry that gets done).

View 9 Replies View Related

Access 2010 Selecting Data From A Table And Auto-filling Fields

Aug 14, 2015

I have staff table which is a lookup field on the phone call table.when the phonecall form opens I want the employee field to auto fill in the employees name from the lookup field according to there security level.so something like this

On Open
Select Case Forms!frmLogin!cboUser.Column(4)
Case X = 4'the employees security level'
Case X = Insert Table_tblPhoneCalls!EmployeeID"4" into Form_frmPhoneCalls!Employee.
End Select

of course this is a syntax error as I do not know the correct code words.

View 1 Replies View Related

Forms :: Subform Not Filling Required Info Into Table

Mar 15, 2013

I have a database which has been in production for quite a few years, it even made the swap from .mdb and .accdb without losing any of the functionality. Well I just had to export from access to new access to start a new file for one of our projects and now one of the subforms is not adding information into the table. The way the subform functions is it feeds information to the table Lease Tracts, at the same time it has another table Xrf Property Tracts Leases (I didn't pick the name and it drives me nuts too!)

When a user starts to add information into the subform the table lease tracts generates an auto number "tracref" which it adds onto the line where the user is inputting the rest of their information. The relationship is set as all alike between xrf and lease tracts to input in both tables, well the xrf lease num1 is being filled in by the master/child setting but the lease num1 on the lease tract is the only field not autofilling.

View 3 Replies View Related

Auto-filling A Field Based On Entry In A Separate Field

Jul 17, 2015

I am creating a database tracking physicians and their contracts. I currently have two tables: PhysicianT and ContractsT, with corresponding forms to enter information in them. I have an issue with the Contracts form; I want to be able to select a physician from a dropdown list (looked up from PhysicianT) and have Access autofill their Physician ID #.

PhysiciansT looks like this:

physicianID (AutoNum) name (Calculated)
1 Barker, Bob
2 Burgundy, Ron
3 Stark, Tony

Upon selecting Barker, Bob from my dropdown list, I want "1" to appear in the Physician ID # field in my Contracts form.

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

Auto Count On Subform

Sep 5, 2006

Hi,

I have 2 databases. One is Personal Details and the other linked via their PersNumber is Appointment times.

What I need to do in the the Subform, is everytime the client comes to a new appointment where we record the dates and times etc I need it to show in a text box the number of appointments.

So for example if its their 3rd appointment it shows 3 if 4th then 4. Does that make sense?

Autonumber in the Database design doesnt work.

Thanks

Travis

View 3 Replies View Related

Auto-width For Columns In SubForm

Jul 10, 2014

I have developed an Access app, which has different navigational tabs which open up different forms. e.g. Tab A has Form A inside it and Form A has SubForm A1 inside it.

For some reason, the following code is not working on any of the fields Me.YourFieldName.ColumnWidth = -2...

What to do that all the fields in the subforms will have auto width adjustable to fit in the text.

View 13 Replies View Related

Forms :: Auto Height Of Subform On Base Of Records

Apr 28, 2015

i have a subform (A) which shows records after an query..i want to set height of subform on base of records as some time query shows 2 records and some time it shows 10 records..how can i set auto height of sub form

View 5 Replies View Related

Modules & VBA :: Auto Resize Memo Field In Subform

Apr 28, 2015

I have a subform that I use in a few different ways on my database. It has a comment log with a memo field for people to insert their comments. The struggle is some can be long some can be short. Is there any way to have each record height adjust to the length of the memo?

If it cannot be done for the subform in regular use, my main concern is having it formatted for reports that are generated for clients.

I clipped and attached an example from a report. Its not the best example but the extra column height is adding additional pages to my report to accommodate one long comment.

View 4 Replies View Related

Forms :: Auto Height Of Subform Based On Record Display

Nov 16, 2013

i have a subform name(SUBSAL)in this subform i get reocrds for some employee as select combobox Name(CMBEMP).some employee having 2 record or some having 6 record as their transaction

i have sum of transaction at subform footer field but when only 2 records shows in subform it shows a major gap or blank space in subform detail section.

View 2 Replies View Related

Forms :: Auto Populate Subform Based On Selection In Parent Form

Apr 30, 2015

I've got a Parent form (frmProspectDetails) with a subform linked (fsubProspectSkill).

This form is for users to enter general information on a prospect (names, position, height, weight, etc) on the parent form and skill levels on the subform.

Currently the subform is set so the user has to manually select the specific skill set for the prospects position, and then enter a value for each skill level(1-99).

I'm trying to get the subform to auto populate with a specific skill set based on the position selected in the parent form, so the user only needs to input the skill level without selecting each specific skill.

This data is then stored in a table (tblProspectSkill)

To add, I've created a form (frmPosition) that lists the specific skills set for each position.

I'm not sure how to get this subform (fsubProspectSkill) to auto populate with the specified skill set from frmPosition.

View 6 Replies View Related

Filling Up A Table From Another

May 23, 2007

Hi all:

I have an inventory table, and I wish to pick items from that inventory table and populate an order placement table.

In oracle, clicking one of the item windows in the form provide with a LOV (List of Values), and usually items are picked from there.

How do I achieve this in Access, and it does not have to be LOV as in Oracle.

I shall be thankful for your kind help.

Regards - Prabir.

View 4 Replies View Related

Filling In TextBoxes

Nov 10, 2005

I have a table with names of people and the cars they own. I made a form with a combobox which everytime i choose the name of the person in my combobox, it will list the cars they owned. That works fine. Problem i have is that i have to show how many cars they own. So i made a query to count the number of cars for each person. Then I made a textbox on the form to show this count. However I can't seem to link this textbox to the query since my form has a record source to the table of ppl and cars. How do i link my textbox to my query of counts of cars?

I tried changing the control source pointing to the field of the query but it doesn't work. I have linked the combobox selection so that my query filters to wat i select on the form. Anyone can help :( , its a simple process but i keep trying and doesn't work, and also dont wanna use a subform.

View 1 Replies View Related

Filling A Form

Dec 5, 2005

hi
is there anyway to temporarily store the information being entered into a form before actually writing it to a table. i want information to be added to the table only once the save button is pressed. i dont want the table to be used even as the scratch pad.
Thanks

View 3 Replies View Related

Filling In The Blanks

Jul 27, 2006

Hi all,

I have been trying to create a database that looks after staff holidays.

Here's how it looks at present

TBL_Holidays:

Staff_Index
Staff_Name (From a lookup)
Start_Date
Number_of_days

TBL_Holidays_Booked:

Staff_Name
Dates_Booked

Once the form (FRM_Holidays) is filled out I had (until I gave up and decided to ask for help - 2 weeks) a button that went off and run a append query.

Here's my problem. Once the button is pressed I need the TBL_Holidays_Booked to fill with the Dates_Booked.

ie.

John Smith wants his holiday to start on the 1st August for 10 days.

The resulting TBL_Holidays_Booked would look like the following:

John Smith 01/08/06
John Smith 02/08/06
John Smith 03/08/06
..
John Smith 10/08/06

Is there a way to do this? or is there a simplier way of doing it?

Regards

Mark

View 3 Replies View Related

Filling In A Form

Feb 11, 2005

I have a form, which is used to create proposals. The form has form headers and footers, as well as a page footer.

In the Detail area of the form there are only two fields, Description and Amount, which only take up one line. I want the detail area to determine how many pages the form will be when printed. Can a new description/amount fields line be automatically inserted after I complete one? I guess the question is, can the Detail area of the form grow automatically? If so, how is it done.

Naturally, I only want the Form Header and Footer to be printed once, regardless of the amount of pages the proposal becomes. And, likewise, I want the page footer to be printed on each page. So, if the detail area only has one line completed then only one page will be printed. However, if there are 20 lines in the detail area then two pages or more will be printed.

Any help would be greatly appreciated.

MrAviator

View 1 Replies View Related

Filling Table?

May 30, 2005

I have a table:

Product:
Code | Name | Description | Price

I have a form with a text box. i want whatever i write in the text box to be inserted in the table Product under Code.
Its like im inserting a new product.

How can i do that? Im new to Access and VB, so bare with me.

Thanks alot

View 1 Replies View Related

Filling A Field

Nov 14, 2007

Hello!

What I am trying to do is fill a field with a date until a new date is encountered. Basically, I have imported some csv data which only has the date when it changes. I have created a new field and have a row with only the date in it. Is there a way to fill the rows below the date row with that date until the next date row is found and then continue on with the next date and so on. Here's what the database looks like, basically:

Date Field1 Field2 Field3
01/01/01 null null null
null DATA DATA DATA
null DATA DATA DATA
null DATA DATA DATA
null DATA DATA DATA
01/02/01 null null null

Hopefully this makes sense and someone can give me a hand with this! Thanks so much!!

View 14 Replies View Related

Filling A Table Using Combo Box

Dec 21, 2004

I have one table (tblComplete) with a listing of 30-50 company names and associated information...

"tblComplete" has fields: AutoNumber, Company, Address, City, State, Zip, Phone

On a form I created a combo box linked to AutoNumber and Company to drop down the list. Once the 'company' is selected, I would like it and the rest of the fields (address, city, state, zip, and phone) to go into the blank table (tblSelected).

Could I use a Macro to do this or should it be a query?

View 9 Replies View Related

Filling Combo Box Through Code

Feb 16, 2005

Does anyone have a quick sample code on how to load a combo box using ADO? Currently I set the row source type to Table/Query and the row source to a query within the program. I would like to fill my combo box using code instead.

View 5 Replies View Related

Pre-Filling Forms On Web Sites

Feb 18, 2005

Is it possible to write an event procedure attached to a command button in a Microsoft Access database that would use data from an established query to pre-fill data in to a form on a web site? Has anyone tried this?

View 3 Replies View Related







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