report printing

[accessissofrustratin]

yahoo. thank you will try this immediately.

 

[accessissofrustratin]

i have no "ON LOAD" option in the report properties event tab.

 

[accessissofrustratin]

is there such a thing as a stamp of some sort. so when i press the print button it just stamps a number in the report. this seems like it would be easier for me to implement as i have absolutely zero programming skills.

 

[accessissofrustratin]

time to draw a line under this now. thanks for those who genuinely tried to help. and to those who did not, try to remember we are on here because we have not got the knowledge you have. Do not want a programming lesson just an answer to a problem. if you cant do it just say so. Do not take the " Msgbox ""mick"" ". wanted to put a swear word but someone might tell the moderator.
going to print reports without numbers and write manually. will keep a record of numbers on a piece of paper. now time to log out and never log in again.

 

[melissa_may1]

Hi,

This really isn't complicated, though for anyone new to Access, everything seems complicated!

All you need to do is create a new table with one row, and one column called ReportNumber. This table will hold the number of the last report printed.

Then write a query to go and grab that number, add one to it, and write the new number back. The query will return the next number.

Each time you print, your report will call that query in the report header, update the report number, and return the updated number to your report for printing in the header.

Note that you will need to put this in the report header (which prints only once for each report) and not in the page header (which prints once for each page.)

You'll need to play around with this a little in order to get it to work, but that's the fun of programming, right?

I hope you don't give up on this project, on Access, or on programming in general, just because you've hit a problem. The only way to learn this stuff is to poke around and try things, ask questions when you get stuck, and don't give up!

 

[speakers_86]

The op doesn't seem willing to learn. I think he simply wants it to work without caring how or why. That's why I didn't really try and help much here.

 

[accessissofrustratin]

at last...someone who knows what i am trying to do.
Thank you

 

[accessissofrustratin]

Thanks for helping, a couple of questions.

1. Does the column ReportNumber need to be the primary key and does it need to be an auto number.

2. Do i create a query using the simple query wizard and how do i add 1 to it and write the new number back.

3. In my report when i add a field into it i just click on the field list icon and it shows me all the fields i can add, but i cant see ReportNumber as it is a different table.

 

[accessissofrustratin]

speakers_86 its not that i dont want to learn its that i am not planning a career as a programmer. i wanted an answer not a lesson. You ask me whats wrong with you printer i will tell you, not try to make you an engineer!