Hello all- New here and working with a database for my boss. I did not create this rather am modifying it. I have a table (vehs) that contains information for three different departments regarding their vehicles. This database also has a form that prints (when clicked once) all of this data to the local printer. I need to make three sub forms to print similarly but just by department number (in other words only department 1's vehicle data) I'm not too big an access guru so if I need to supply any more data please let me know
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code: PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code: Function PrinterOK(sPrinterName As String) As Boolean Dim MyPrinter As Printer PrinterOK = False For Each MyPrinter In Printers If MyPrinter.DeviceName = sPrinterName Then PrinterOK = True Exit Function End If Next End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
Hi, I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the data in the subform
I have a table that contains a lot of different information regarding to mailing.
There are columns for Name, Address, Address2, Address 3, City, State, Zip, Country, Base Name, etc.
Some units will only required parts of the above information. I'm using the Name as an identifier in the DB only and Address is the beginning of content that I want to use.
My issue stems out of the fact that the City, State, and Country are not always required but the Base Name, may be used in lieu of the City.
I was looking at making checkboxes next to each of the columns on the form on the field and then using those checkboxes somehow to create a report for Mailing Labels.
I have a form with multiple subforms. When I hit print selected record I get a blank sheet of paper. What could be set to not allow the data or the background of the form to print?
If I just print the subform out by itsself it works good. However when I have the main form open then try to print I get blank pages.
I am sure someone changed a fairly small setting, but I do not know what has been changed. Thanks.
:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page: Private Sub btnPrtOrderFrm_Click() On Error GoTo Err_btnPrtOrderFrm_Click
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
After having designed a series of forms, I have just been told that users would like to occasionally print the data. On testing this, it seems that the data does not print onto 1 page. Are there any settings to fit data to 1 page wide only?
Aternatively, is there a better way of doing this? Perhaps by using a report or something like that? The form has a whole load of calculated fields (calculated control boxes with expressions) so would I run into any problems doing it ths way ?
Having trouble printing after I performed a filter. Have a subform with continuous forms that I put various filters on..., however when printing, all the records print and not just what was filtered...Is there a way around this. Basically, I would like to be able to print out only the filtered records in my form view.
I created a form that opens to a blank form. I also have a print button on the form. I want to be able to print the blank form, but nothing happens unless the primary key has a value in it. Is there a way to print just a blank form? I have been working at this problem for a few weeks. Please help!
I have a bound form that I created. I want to be able to print a blank form. When I click on my print button, nothing happens. Also, when I click on the print icon, I get the following error:
I am looking for a way to only print the detail section (no header, no footer) using a print button on a form. it also needs to fit to 1 page. do i need code for this or is there a property that can be adjusted?
We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:
1. ETL - We change model # - We Change if the Labels Says Dry Damp or Wet Listed.
2. MISC. -One Plain Txt Box that can be edited in the center
For the 2x3 Labels:
1.Box Labels -Customer -Item -Sales Order# -Shipping Location (For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)
2.ETL -Change Model -Wet Damp or Dry 3.CSA -Change Model -Change the Wattage (3 Different Places) -Wet Damp or Dry 4.MISC -6 Text Boxes (From top to Bottom not side by side)
4x6 Labels: 1.HID Box Labels -Item -Watts -Color -Medium or Mogul Based
What I would like to do is print a report showing the current form and all the forms after that form. In other words, none of the records previous to the current form listed but do show the current record and all others after that as determined by the auto number ID field. I am able to filter by form in the ID field with >45 showing me all records with an ID of 46 and above but I want to be able simply print the report from the command button that is on the form.
Looking to print an access 2000 report on a 3 part - 9 1/2" x 4" carbon form. I'm using an Epson LQ-590 dot martrix printer. Does anyone know how I can set this up under the page setup of the report? I'm trying to print an access report I made with comapny and customer name to these 3 part carbon meter tickets. I'm really in a jam. Any help is gratly appreciated. Thanks....
Hello every one, it is great to find a place like this.
Please I need help. When I print a form from Access 2000, all the fields on the printed form show #Error, eventhough in the screen the fields show information.
I have a form in my database that has two subforms, both of which I use to display images that are linked. This works great when I just flip though the records in Form view, but when I want to print off a certain page the images are not linked properly. Instead of showing the image associated with the unique record it previews/prints the images associated with the first record of my recordset.
Any ideas? Maybe there is something in the subform or form properties that I don't have set correctly. In a past visit to the forum I found an extremely helpful database posted (called ImageSample97) that I used to develop my form.
I have searched all over google for help on this one, so now I enlist help from the good folds at the MS Access Help Center...
I have been given the task of updating a particular form our company has been using for over 10 years. The form was originally created to print on color coded carbon copy form with 5 sheets of paper. The form gets printed via a dot matrix printer (which pounds thru all 5 sheets). At this time, the form is done in MS Access 97 - and simply prints all fields via the print command.
Certain sections of the form do not print on all copies because the carbon copy paper masks the fields. I.E. the bottom sheet does not show the 'bill to' information but all other copies do.
So, I was asked to make the existing form print to our standard Laser Jet printers - but to hide certain items per page. I have determined how to print the form 5 times by simply adding some basic VB code to a command button. What I can't figure out is how to hide certain fields as the old carbon copy form once did. I.E. Print the same page of a form 5 times, but each page has different information on it per page.
Before I start I just want to say that I know forms are not well suited to printing etc... but I have this stupid issue that is driving me nutzo.
I have a form with a subform on it but for some reason on the main form and the subform insist on printing on seperate pages, i have checked the force new page setting for each section and there are no page breaks that i can see? Don't seem to be able to find references to this issue anywhere...
