Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







One Form - Want To Populate Two Tables At Once


Hi

I have a form created from Table1

I have another Table2 - which is identical to Table2

I want Table2 to automatically update with the information put on the form (which currently only populates Table1) without asking the user whether they want to do this. And when I say update, if a user adds a new record to the form, I want that new record to be put on Table1 and Table 2.

I am using Access 97....

Help :)))

Thanks

Maria


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Populate Form From Other Tables
I have 5 tables (Client, Driver, Appointment, LessonType & Booking). The Booking table is empty as it is made up from the other 4 tables. I want to have a form (Booking) which collects data from the 4 tables to create a record.

I want this to be automated as much as possible rather than typing the data into a textbox, because this would be difficult for the user and there would be conflict.

The Booking form will be split into 4 sections relevant to the above tables. For example, select ClientID from a combo and the other fields populate, such as forename, surname, address1, address2. And then select DriverID and this populates the relevant fields and so on, until a booking is created.

Ive tried After_update and couldnt get that to work. Any suggestions or help will be much appreciated as this has been a headache for a few weeks now. Thanks

View Replies !   View Related
Populate Three Tables From One Form
I am having the hardest time with this.

Tables: Employee Record
HR Record
Orientation Record
Certification Record
Optional Certifications

All are related.

I have a form where I do data entry, with all of the fields from these tables on the form.
I want to type in the name only once, at the top of the form, and then have it populate the
Name field in EACH of the above tables. Can anyone help me with this? I've been working on
it for two weeks now. I'm sure it's an easy fix that I haven't thought of.

I've already tried using subforms, but unless I type in the name in each of the subforms for
the above tables, I end up with blank name fields in all the tables, except for the one I pointed
the data to go to.

I'd be SO grateful if someone could help me figure this out. Thanks!

Kelly

View Replies !   View Related
Populate Form From Other Tables
I have 5 tables (Client, Driver, Appointment, LessonType & Booking). The Booking table is empty as it is made up from the other 4 tables. I want to have a form (Booking) which collects data from the 4 tables to create a record.

I want this to be automated as much as possible rather than typing the data into a textbox, because this would be difficult for the user and there would be conflict.

The Booking form will be split into 4 sections relevant to the above tables. For example, select ClientID from a combo and the other fields populate, such as forename, surname, address1, address2. And then select DriverID and this populates the relevant fields and so on, until a booking is created.

Ive tried After_update and couldnt get that to work. Any suggestions or help will be much appreciated as this has been a headache for a few weeks now. Thanks

View Replies !   View Related
Using List Boxes To Populate Tables
Hi all,

I need some help with regards to a small db application im developing.

I currently have a form that contains two separate list boxes.

The first contains "Measures" and the second "Dimensions". They are based on the underlying tables Measures and Dimensions respectively.

My intention is to be able to select whatever Measures I want and select the dimensions they relate to in the other list box then click on a command button to run a query that would update/append my underlying table, Measures2Dimensions, which is linked to the tables that the list boxes are based on.

I hope I've described my problem well enough for someone to provide me with some help.

Many thanks in advance!

View Replies !   View Related
Populate Form
I have a simple question I am sure for others.

I have two forms.

Entry form--it is used to load data as well as I want it to be populated and show data when called upon.

Pending form--it shows all pending groups.

The pending form is a continuous form and it has a button with a double click event.

When that button is doubled click, I want the 'Entry Form' load and to be populated with the data that is in the Pending form.
The pending form only shows the EntryId(PK), Group name, and date. The 'Entry form' shows everything.

Since the entry form is used to add/update records in my tables, I wanted to use it to allow the user double click the record in the pending form and bring up that entry form for updating.

MAkeing a long story short, how do I populate the entry form with the records based on the entryID in the pending form.

I've attached a copy of the db incase I don't make sense.

View Replies !   View Related
Use SQL In VBA To Populate A Text Box On A Form
I know how to do this with a combo box. After defining the SQLtext and WClause something like:

with me.cbocombobox
____.rowsource = SQLtext & Wclause
____.requery
end with

How do I (can I?) use the SQL in VBA to populate a text box in a similar manner? I have tried various versions of me.textbox = sqltext & Wclause etc, but to no avail.

Cheers.

View Replies !   View Related
Auto Populate Next Form
Hey all,

Maybe im just having a brain fart, but I cant get this method to work.

There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the second one is open.

What I would like to do is pass the info from the first form on to the second one. The second one uses the bride's info and the wedding date.

I tried using the query to fill it in but I havent had any luck. Been a long day.. maybe just not thinking clearly.


Any help would be appreicated, and thank you in advance to any replies!

Thanks!
Mateo

View Replies !   View Related
How To Populate A Field In A New Form
I have attached a sample of my DB so you can see for yourself what i am trying to do. I want to capture the SSN on the search page so when I go to P1 or P2 that persons info is all ready populated on the right side of the page, but still allows for a search after I have updated the record.

Any help is greatly appreciated.

View Replies !   View Related
How To Populate A Form From A Combo Box
I'm creating a form that will have a combo box and several other fields on it. From the combo box, I want to be able to select a line from the combo box, click on the line and then have the form's other fields get populated.

I know I have to have the combo box and fields tied to either a table or to an underlying query, but what might be my best way to get the form populated?

Should I, in code tied to the form, run some coded SQL based on what I select and use the SQL results, or should I use something like recordsetclone, of which I have no experince?

Thanks inadvance to thoe who respond!! I reallyappreciate your help!!

View Replies !   View Related
Using A Query To Populate Fields In A Form??
I have very minimal knowledge of MS Access and I have to create a database to input, update and display project information. How do I write a query to populate fields on a form, from either a single table or multiple tables?

View Replies !   View Related
Auto Populate A Text Box On Form
I have a form with a text box named HRName.

When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!

Here's my code:
+++
Private Sub BusOrgCode_AfterUpdate()

Dim strFilter As String

' Evaluate filter before it's passed to DLookup function.
strFilter = "BusOrgCode = " & Me!BusOrgCode

' Look up HR Partner Name and assign it to HRName control.
Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)

Exit_BusOrgCode_AfterUpdate:
Exit Sub

End Sub
+++

View Replies !   View Related
Auto Populate A Form Field
I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.

View Replies !   View Related
Populate Form By Entering Data
I have a form with two fields, EMPLNO and SURNAME.

By entering the employee number in EMPLNO or by entering the name in SURNAME I wish to get the correct record onto the form.

This is probably covered in the archive, but I'm not sure what to look for.

Any suggestions.

View Replies !   View Related
Using A Table To Populate 3 Form Fields
Hi

I have a form with 3 combo boxes part No, Description, Cost. I have created a table with this information in I want to be able to select the information from either one of the three drop down boxes and the other two to automatically collect the information from the other colums of the table. Can anyone help please?

View Replies !   View Related
Populate Form Fields On Open
Hi all,

I'm sure this must be a well used function by many access users but I can't find anything about it online at all - please help!

I want to open a subform "AddReservation" and populate three fields with data taken from the relevant record in the main form. So in the btnOpenAddReservation_Click event to open the subform I set global variables, then in the form_open event I have this:

Private Sub Form_Open(Cancel As Integer)

Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID

End Sub

But I get the error 2448 'Can't assign a value to this object'.

However if I put the same three lines into the start of the subform's btnARSave_Click event it works fine:

Private Sub btnARSave_Click()
On Error GoTo Err_btnARSave_Click

Dim stDocName As String
Dim stDocName2 As String
stDocName = "OwnersAndCats"
stDocName2 = "AddReservation"

Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

YesNo = MsgBox("This reservation has been added successfully, do you want to add another?", vbYesNo + vbQuestion, "Add More Reservations?")
Select Case YesNo
Case vbYes
DoCmd.GoToRecord , , acNext
Case vbNo
DoCmd.Close acForm, stDocName2
DoCmd.Close acForm, stDocName
DoCmd.OpenForm stDocName
DoCmd.GoToRecord , , acGoTo, stRecordNo
End Select

Exit_btnARSave_Click:
Exit Sub

Err_btnARSave_Click:
MsgBox Err.Description
Resume Exit_btnARSave_Click

End Sub

What am I doing wrong? Why can't I populate the fields on open?

Many thanks
PT

View Replies !   View Related
Populate A Form From Existing Data
Hi
I cant get my head around this one,

I have a Form that enters all details for an Order.

On that form is a Tick Box that says Repeatable.

If that box is ticked in the future I am able to repeat on that stock item.

I have created a form with a List boxea that Lists all Suppliers Stock that is Repeatable

I want to be able to double click a Stock Item from that list, then let it populate another Order ( Unique Key ), fill in all the field from the previous order, so all I have to do is enter the Quantity I want to re-order.

How do I do this?

please help

Hightower

View Replies !   View Related
Auto Populate User Name In Form
I am need of something that will help me auto populate the user name on a form. What I am thinking of is setting something that is diplayed when the form is open, asking users to enter their name. I then want this name to be populated in the user name of each record they update.

Can anyone help me? This sounds like a pretty easy thing to do , but sometimes what I think should be easy turns out to not do-able!

View Replies !   View Related
Can You Populate A Unbound Continious Form
Can you populate a unbound continuous form. If yes how do I do it

Phil.t

View Replies !   View Related
Auto-populate Form Field!
Hi, just a quick question that i hopes not too hard.

Basically i want one of the fields on my form to get automiatically filled in. I'd like it to take the first letter from one field and the first letter from another field. What im trying to do is make a primary key field up from other fields they have entered.

So for adding new customer i want it to take the firstletter of the firstname and first let of the surname.

SO for myself Luke Tarrant it would be LT. Then i suppose i'll need to add some unique so there no duplicates as it a primary key field im trying to populate.

So for instance Luke Tarrant would = L + T +001

Then Lucy Tarrant would = L + T + 002

Any help wouild be brill!

View Replies !   View Related
Populate Form Fields From A Combo
Trying to update fields (bound) on a form (built using the wizard) from value selected in a combo box. I can get this to work with unbound text boxes using an After Update event handler and a code query along the lines of:

Me!TxtJobCode1 = Me!CboJobDesc.Column(1)

But this doesn't work where the form field is bound to a table.

So qu is - how do I achieve the same result using table fields instead of text boxes?

I could use text boxes but not sure then how I can save that data as a record in the table if it is not bound to fields.

Any help appreciated

Andy

View Replies !   View Related
Populate One Form With Info From Another Form
I want to populate certain Fields on Form2 with information from certain fields on Form1 (current record) when form 2 is opened from a yes/no box on Form. How can I do this?

View Replies !   View Related
Populate One Form With Info From Another Form
I want to populate certain Fields on Form2 with information from certain fields on Form1 (current record) when form 2 is opened from a yes/no box on Form. How can I do this?

View Replies !   View Related
Populate Form With Data From Excel Spreadsheet
Hello.

I currently have a data-entry form that users fill-out with data (duh!). The data comes an excel spreadsheet that is created during the work-flow process.

I would like to add an "Import" button the field that, when clicked, would prompt the user to select a spreadsheet (different each time) and once that was selected import data into the form (and ultimately the table). The data will always be in the same location (cells and sheet) within every speadsheet.

Any ideas?

Thanks in advance.

Sean

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved