473,386 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Batch Form Print Command Button

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
3 1688
Nixeh
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
14,534 Expert Mod 8TB
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
32,556 Expert Mod 16PB
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

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

Similar topics

5
by: Darren DeCoste | last post by:
I have an access project with a Form that has a Command button to print the current record. I would like to Print the record 3 times, changing a text field on each print. The standard code of...
6
by: Charles Neitzel | last post by:
I'm trying to write a windows application in C# (Using Microsoft Visual C# 2005 Express) that is nothing more than a simple UI with buttons on it. The buttons do various things like running...
2
by: eric1025 | last post by:
I have a form with a command button. When the command button is clicked, it runs a batch file via the Shell command. The batch file is run with a few variables coming from the database such as %1...
1
by: Parasyke | last post by:
Thanks for any help.. I currently have a database with about 100 products with picture links in an external folder. I have a form from which I can successfully display a product, its...
9
by: sesling | last post by:
We have several batch programs that users need to run each day to move data around our system. The batch files require the user to enter criteria when launching the program. To help simplify this I...
2
by: Fabian Braennstroem | last post by:
Hi, me again :-) I would like to parse a small batch file: file/read-case kepstop.cas file/read-data keps1500.dat solve/monitors/residual/plot no solve/monitors/residual/print yes
1
by: mirandacascade | last post by:
1) Module1 has the following delcaration: Public g_frmZZZ as Form Public g_txtForm2 as Variant 2) app has two forms: form1 and form2 3) a command button on form1 opens form2; it also has...
2
rsmccli
by: rsmccli | last post by:
Hello. Using Access 2002. I have set up a command button on a form that will print off a list of hyperlinked documents that resides in one of our tables. I have been using code borrowed from Graham R...
6
tdw
by: tdw | last post by:
the View Orders form in my Access database has a Print button on it. It has other buttons too, like Edit etc. These buttons used to be at the bottom of the form laid out horizontally, but this was...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.