473,659 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Batch Form Print Command Button

4 New Member
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 1699
Nixeh
4 New Member
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 Recognized Expert Moderator MVP
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,568 Recognized Expert Moderator MVP
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
2433
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 private sub printbutton_click() DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection End sub
6
11215
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 programs and executing registry entries. The majority of my buttons work however, I have come upon a problem. I need a few of the buttons to run DOS batch files, the batch files in turn run program installers (specifically windows update runtime .exe...
2
2613
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 and %2 for different fields, so that a user is added to a group in active directory, and then one of my access database fields (Date_Added) is set to Me!Date_Added = Date. I would like to make this more of a batch type process, where the file...
1
1594
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 specifications, and print a sheet with the picture and the relative data. I'm trying to write some code to allow me to bring up the products and add them to a batch of about 20 different product sheets to print at one time, rather than the user having to hit...
9
2169
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 have created a form that contains several list boxes and a button to launch the batch file. This way the user does not need to type the information in. They will be able to select it from a list box. Is there a way to get the information...
2
1695
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
2317
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 another command button the purpose of which is to permit one to set a breakpoint in the code behind the button
2
1847
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 Seach's site which identifies the file type, opens the document in its correct program, and prints it:Public Const SW_HIDE = 0 Public Const SW_MINIMIZE = 6 Public Const SW_RESTORE = 9 Public Const SW_SHOW = 5 Public Const SW_SHOWMAXIMIZED = 3...
6
9981
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 causing the form to be just long enough vertically that some people when viewing it on their screen would have to scroll up or down to see the top or bottom of the form. So, my solution was to make the form wider and move the command button over to...
0
8332
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8746
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8525
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7356
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2750
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1737
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.