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

Batch Form Print Command Button

P: 4
Hi guys, ive been using access on and off now for about 3 years but im currently working on a database for work.

Ive got the database all sorted and is currently storing 1000records. Ive created a form that will store all the relevant information i need for a paper backup system so i can print out any report i want that ive got selected.

Though im wondering what code i would need for the button that i need thats listed below.

Needs to print, but unlike printing the current record, i need it to load to do a batch print of all the records ive got but in this form layout.

Any help will be greatly appreciated and will save me and other collegues going through and printing every form individually.

Regards, Nick
Jan 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: 4
Dont worry guys managed to get it working.

Though now for some reason the other day the forms used to go through in the order they are in the database. So if they were sorted by ID they would go through 1,2,3 on the form selection, or if i sorted by surname they would go through alphabetically. But for some reason now its not doing that. Its only sorting by whether the person is deceased or not, and it shouldnt be.
Jan 5 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Dont worry guys managed to get it working.

Though now for some reason the other day the forms used to go through in the order they are in the database. So if they were sorted by ID they would go through 1,2,3 on the form selection, or if i sorted by surname they would go through alphabetically. But for some reason now its not doing that. Its only sorting by whether the person is deceased or not, and it shouldnt be.
If you open the table assuming the form is based on a table you may find that the table is sorted on the deceased field.

Mary
Jan 6 '07 #3

NeoPa
Expert Mod 15k+
P: 31,494
One of the properties of a form (true for reports also) is 'Order By'.
If you enter the sort order in here you are not depending on the underlying data source.
Jan 6 '07 #4

Post your reply

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