INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Apend information After An Even For Multiple Records

Apend information After An Even For Multiple Records

(OP)
Afternoon All,

I was wondering if someone could help as its driving me crazy.

I have a report (rptLetterAll) after I click a command button the report is generated based on parameters that are on the same form as the button.  

What i want to happen is after the reports are generated or button clicked, i need certain information from the record source of the report to be sent to tblHistory.

So this is the scenario:

cmdOK is clicked 4 letters are generated.
CaseID, Date() from qryReport (the underlying datasource of the report) are appended to tblHistory for each letter that is produced.  So 4 lines are appended to the history.

I have tried using the below after DoCmd.OpenReport.....

SQL = "INSERT INTO tblHistory ([CaseID], [HistoryDate]) & _
" Values('" & CaseID & "','" & strDate & "')"
CurrentProject.Connection.Execute SQL

But cant get it working!

Any help would be appreciated.

Cheers

Mike
 

RE: Apend information After An Even For Multiple Records

(OP)
Sorry about the typo on Append!  Please dont hold that mistake against me!

Cheers

RE: Apend information After An Even For Multiple Records

SQL = "INSERT INTO tblHistory ([CaseID], [HistoryDate])" & _

Also, this is an MS Access question which belongs in one of those forums, such as forum703: Microsoft: Access Reports

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close