Help - Printing a letter in a form

[iProRyan]

Hello,

I am new to the forums so sorry if this has already been posted somewhere or it is in the wrong section, but I really could do with some help.

For a project, I am making a database for a DVD Rental Store, and I have a form that adds new guests, on this form I would like a button to print a letter that I have in word but for each different guests so it prints them a letter confirming there registration and include account numbers which will be different everytime, any idea how I would do this, if it makes sense.

Any help will be much appreciated.

Ryan

[pbaldy]

Generally you can mix fixed text and data in a textbox:

="Your confirmation number is " & [ConfirmationNumberField] & " for your rental on " & [RentalDateField] & "."

[robsworld78]

Hi, welcome to the forum!

I'm not the best with access but this is what I would do.

Create a query with all the fields you need to show up in the letter, make sure you have the GuestID in the query.

Then create a report and use the query you created as the record source. Then type out your letter and place text boxes where you want to insert the account numbers, etc... The query will show all records in the table and when you open the report normally it will likely repeat the letter for every record in the table, don't be worried about that the magic comes on the form you want to print from.

Now on the form you add the guest add a button and on the "on click" event use the code builder and add the following code.

DoCmd.OpenReport "REPORTNAME", acViewReport, , "[GuestID]='" & Me.GuestID & "'"

Now when you click the button it should open the report with only the info you see on your screen.

"acViewReport" in the code above will show the letter in a form view on the screen, you can change that to make it print directly to printer and not show on screen.