By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Printing a single record at a time

P: 1
Hi I am creating a microsoft database and am currently stuck. I need to print one record at a time when in form view. to do so, I need to create a script which uses a value in the table which is a autonumber primary key. Unfortunately, when i create this field, and then open the form and try to append a report, it gives me an error saying that there is a key violation. I am stuck and dont know what to do. Please help!
Aug 8 '07 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,324
Hi I am creating a microsoft database and am currently stuck. I need to print one record at a time when in form view. to do so, I need to create a script which uses a value in the table which is a autonumber primary key. Unfortunately, when i create this field, and then open the form and try to append a report, it gives me an error saying that there is a key violation. I am stuck and dont know what to do. Please help!
Why do you "need to create a script which uses a value in the table which is a autonumber primary key". Just create a report and have the report display only the one record.

"Unfortunately, when i create this field, and then open the form and try to append a report"
I'm just confused by this. You're appending a report to a field? Why would you want to store a report in the table?
Aug 20 '07 #2

MGrowneyARSI
P: 90
Create a query for your report and in the P.K. or Autonumber field put critiria like =[Forms]![My_Form]![P.K.] then build your report off of that query and put a button on your form to run that report keep it simple.
Aug 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.