Passing Information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drum2001@gmail.com - 18 Jan 2006 17:01 GMT

It would be great if someone could help me solve this.

Here is my situation..

I have have 2 databases containing these the following two,
subsequently.

Database I
TABLE: Requests:
- *Tracking#
- Requestedby
- DateRecvd
- Approvedby
- DateComplted

Database II
TABLE: RequestInfomation:
- *RequestIDNumber
- SubmittersEmailAddress
- DateReceived
- Approver
- DateProcessed

The "Requests" Table of DATABASE I is the main table accessed via form.
However, when I use Database II, I would like the RequestIDNumber,
SubmittersEmailAddress, DateRecieved, Approver, and DateProcessed to be
populated from the Requests Table, and update accordingly.

Tracking# = RequestIDNumber
Requestedb = SubmittersEmailAddress
DateRecvd = DateReceived
Approvedby = Approver
DateComplted = DateProcessed

Can this be done?

Reply to this Message

MGFoster - 18 Jan 2006 22:07 GMT

Use the Form's AfterUpdate event to run an INSERT command into the table
in DB II. E.g.:

Private Sub Form_AfterUpdate()

' The path to DB II
Const PATH = "C:\My Documents\DB_II.mdb"

Dim db As DAO.Database

Set db = CurrentDb

db.Execute "INSERT INTO RequestInfomation IN "" & PATH & "" (" & _
(RequestIDNumber,SubmitersEmailAddress,DateReceived," & _
Approver,DateProcessed) " & _
VALUES (" & Me!Tracking# & ",'" & _
Me!Requestedby & "',#" & _
Me!DateRecvd & "#,'" & _
Me!Approvedby & "',#" & _
Me!DateComplted & "#)", dbFailOnError

End Sub

Add error handling.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

> It would be great if someone could help me solve this.
>
[quoted text clipped - 31 lines]
>
> Can this be done?

Reply to this Message