Recent content by 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!

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...

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

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...

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.

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

yahoo. thank you will try this immediately.

505 and rising

lifes to short................................................teach a man to fish i understand but come on.

it must be a unique number whenever the record is printed. quite simply when i press the print button that produces my report i want a number printed on it. nothing to do with customer id.

Will the DMax function add a new number to to a new entry into my table/form?

why do i need to fetch the last ID

so every time you print a report it has the next number in the sequence?

so i need to create a separate table to store the job numbers? just like to add that i am a newbie..............

hi speakers_86. yes in my table i have addressid set as auto number and as the primary key. i created a form from this table and from this i print out a job sheet. the job sheet printed as everything on it we need. its perfect, except.....i would like the report to have a job number. nothing in...