Print Out A Copy Of A Form
Mar 14, 2008
I know how to print out a copy of a form that has no sub-forms as part of it. For those of you trying to do this, open the objects menu and click on Forms. Right click on the form you wish to print and save as a report. Open the reports menu and print the form. Suggest you eliminate colors or your ink supply will run out quickly.
Anyway, I am looking at trying to print the form with the sub-form showing as part of it. It is only for presentation purposes to show the End Users what the form will look like and ensure that all requirements are met. I could do a print screen but that only works if the form is smaller than the screen.
Any suggestions??
Thanks,
Alan
View Replies
ADVERTISEMENT
Jan 23, 2014
I have an old access database (written with 2003 but running under 2010) that creates workorders and I need to change a couple of the reports to print three copies with each copy having different text in the footer. I'm converting the reports from a old DOT Metrix special form printer to a laser printer. I have already modified the reports as far as the titleing and cosmetics are concerned and they print and look great on the laser printer. I have also added a TxT box that I want to contain the information on the report.
The reports are generated in a couple of different ways off different screens in the system off buttons, but I figured if I can get one of them to work I can replicate it to the others.
I have gone through the reports forum and have found a couple of solutions but can't get them to work. This is what I have found:
On the on button to print a range of workorders (it drives a query that asks for a starting workorder number and a ending workorder number) click from the from the switchboard:
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "1"
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "2"
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "3"
Then I have this code but I'm not sure where it goes. On the report in the "on open" expression? not sure..
Select Case Me.OpenArgs
Case "1"
txtBox62 = "Shop Copy"
txtFld1 = [qryField1]
[Code] .....
View 14 Replies
View Related
Sep 23, 2005
Hi there,
Can someone help me on this issue?
I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment.
I want to copy 4 fields to 4 other fields within the same Record.
This the current code I use for the Copy-button:
---
Private Sub cmdCopyFields_Click()
Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant
v1 = Me!Field_a.Value
v2 = Me!Field_b.Value
v3 = Me!Field_c.Value
v4 = Me!Field_d.Value
RunCommand acCmdRecordsGoToNew
Me!Field_e = v1
Me!Field_f = v2
Me!Field_g = v3
Me!Field_h = v4
End Sub
---
The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.
-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?
-Are there other options to achieve te same?
I have put in a attachment, to give you guys a visual example of what I mean.
Thanks in advance,
Quinten
View 3 Replies
View Related
Jul 16, 2007
How can I print a report and at the same time programatically set the printer name and 'Print to File' option and set the path of this option?
View 1 Replies
View Related
Dec 4, 2014
I have a form which my company wanted that each single record should be printed from form. I made a print record button and put code to print single page or record. However as a natural habit people go to file > print to print which leads printing all records so 1000's records start printing. Is there any way i can hide print button. File >Print button.
View 1 Replies
View Related
Nov 24, 2014
I have a Lost/Found property database which we use to keep record of the lost/found property and it is working fine.
As per our organization's policy, we keep the item(s) for up to three months in which if it gets restored to the owner then fair enough otherwise after three months the item(s) can be claimed by the "Finder". But for this very purpose we issue the Finder with a "Claim Receipt" which he/she should bring in when claiming for the item(s) after three months period. Therefore, It's just the right time to upgrade the database to a more professional level.
The database has one table and two forms.
One form (LostFoundForm) is visible to the user in which they enter data, this form has two sections; Item(s) & Finder's details and the second section is about Restoring details.
However the second form (ClaimReceiptForm) is hidden to the users (for manual data entry) and has only one section which is exactly the same as the first form's first section, i.e., Item(s) & Finder's details. This second form takes the data automatically from the first form because the table behind them is same and fields are same (please see attachment). Up to here it's all working fine.
I would like to introduce a Checkbox or a CommandButton in the LostFoundForm which when we click should pull up a msgbox asking "Do you want to print the receipt for this item(s)?" with a Yes/No option. On clicking "No" it should, obviously, settle down but on clicking "Yes" it should print the "corresponding record" from the ClaimReceiptForm.
View 3 Replies
View Related
Sep 30, 2013
I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.
The fields that contain the data that I want copied into a new form are:
1. Member_Name
2. Member_ID
3. Account
4. UBH/PBH
5. Assigned_WRCA
View 8 Replies
View Related
Mar 31, 2006
Hello!
I would like to be able to print a specified form when a new record is added to my database.
I have an add form which can be filled in, and there is an "Add" button at the bottom of the page, when this is clicked, I want the record to be added but also a specified form to be printed named "frmKitChecklist".
As I am a VB noob I do not know the code to do this, please could someone help me!
Thanks :)
View 3 Replies
View Related
Oct 4, 2005
I got the command buttons to print the reports I wanted from the forms.
I now have a data entry form (data entry = yes). I would like to print a report from this form. All I get are blank fields. I think it may be a problem in the Where condition on the Open Report function.
I am using:
[Forms]![complaintentryform]
The completed form contains all data I want on the report.
I have tried printing it from the table, but I get blank fields there as well.
All suggestions cheerfully received.
View 4 Replies
View Related
Jan 5, 2015
I just had a problem with a certain form:On Form1, I have a check box called SELECT. When I select any one record, the report I get is blank. I need to select one more record to get a print out of the first one. To print any two, I must select those two, plus an additional one. So it is always the number required, plus one.
View 6 Replies
View Related
Apr 19, 2006
This is actually a rephrase of the scenario I posted in the other thread yesterday.
I have a form, titled "Danish", now i wan to make a copy of it, i.e, its textboxes, buttons and save the new form as "English". How can i perform ALL of the above in coding?
Thks..
FT :)
View 4 Replies
View Related
Jun 27, 2005
If I have a form based on 1 table and want to create an almost identical form based on the same table, how do I do it?
I need to delete only 5 fields from 1st form and then add 5 different fields.
All fields for both forms would be in the same table upon which they are based.
Russ
View 2 Replies
View Related
Mar 4, 2014
I have built a database using Access 2010 using the 'web' format for the forms, reports and tables.
This has been fine so far as I have been using macros for my clickonevents.
However I now need some functionality not available in the web forms macro expression builder. Namely Openquery, (it is not on the available list). I therefore want to copy my forms formatting and properties to a normal non-web form allowing me to enter vba code.
Is there no way of doing this though - will I have to redesign the form again from scratch?
View 2 Replies
View Related
Jun 21, 2007
I have been on numerous topics on this site and managed to pick up bits here and there to get my db to work as I would like with the exception of the print report button.
I can preview the result in a subform of the search that I have done, and it is this I would like to print – not sure what this should be as you can search on numerous criteria.
Edited - removed code and added file
View 2 Replies
View Related
Feb 28, 2005
I would like to have a button on a form to print the current form. Is that possible? how can this be done?
Thanks in advance!
Tim
View 2 Replies
View Related
Apr 28, 2005
Hi... being extremely new to Access, i am sitting here frustrated as anything trying to make this work. I will attempt to explain what I am trying to do.
I have a form that has a combo box in it. This combo box references a table and pulls in the data depending on the company that is selected. What I am trying to do is add a print button on the form, so that the users can print off an address label. Now I can use the normal print report feature and this prints of the entire report, but what i would really like is the print button just to print the fields I want and not the whole thing. The fields I want to print are.
Name_1
Delievery_Address_1
Delievery_Address_2
Delievery_Address_3
Postcode
Ive had a look in the event field for the print button, but I have no idea of the commands to make it only select the fields that I want to print.
I truly am lost, and seeking guidance from the masters here at Access World.
My printing problem is in your hands.... cheers Paull
View 3 Replies
View Related
Aug 15, 2005
I've been sent a form which retrieves company information divided into 4 tabbed sections. Really need to print all this off but can't even print the tab which is showing - it only prints the part of the firm outside the tabbed area (company name and number)
Would be really grateful for an idiot's guide on how to do this! Reluctant to provide a link as it's confidential information.
View 1 Replies
View Related
Oct 2, 2005
I have a form which records the progress of a complaint investigation. There are 3 reports I would like to run from this form using command buttons. They are report_long (shows all activity) report_short (summary) and logsheet.
The primary key is complt#.
How do I ensure that the complaint being printed is the complt# I have on the form?
View 6 Replies
View Related
Feb 14, 2006
Hi All,
I have never done this and not sure if it is possible but thought I would ask.
Is it possible to show within a window maybe, a print preview of a report on a Form?
I am going to assume that the answer is no? But I could be wrong?
Look forward to anyones input on this one.:p
Robert88
View 9 Replies
View Related
Mar 10, 2006
Please bear with my ramblings, but I’m not sure what you may find relevant.
I am currently doing work for a service company where the employees are required to wear the company’s uniform. When someone joins the company they are required to purchase their own uniform. After a year, the company buys the replacement uniform. Each year on the anniversary date, the employee is given their annual evaluation. At that time they are given a requisition to go to the uniform supplier for new uniform articles.
Each item in the uniform has a life span. For example, shirts and pants are replaced each year, winter coats and spring/fall coats are replaced every three years, caps every two years etc.
I have a form which lists the item no., description and cost of each item and when they are due to be replaced. For example
Winter coat last replaced on 2003/11/10, replacement date is calculated to 2006/11/10
When this employee has his evaluation this November, he will be entitled to a new winter coat. The calculations are done by clicking an option button beside the item on the form. Clicking replaces the issue date with Date() and adds three years to the issue date using DateAdd for a new replacement date. Clicking the button also indicates that the item is to be replaced.
NOW, I have all this working.
What I would like to do is find some way of printing the requisition from this form before closing it. Something along the lines of:
If Option1 is yes
Print this item on the requisition
Endif
And do this on every item on the form, if it’s yes, print it on the requisition, if its no ignore it.
The option buttons are not part of the underlying tables or query only part of the form.
If I’m doing this backwards, please let me know. I’m well ahead of my deadline.
View 1 Replies
View Related
Mar 22, 2006
I have a form and the information on the form is displayed in a report so the user can print it out.
I have placed a command button on the form so that when you press the button you can print the report.
I was wondering if there was a way how i could just get it to print of the specific page i was on at the time.
Thanks for any help
View 1 Replies
View Related
Mar 9, 2005
I've got an unbound form that view records indvidually and I'd like to create a report that when the end-user selects the Print Record Command button it will print all the employees information for his review and if changes my admin's will make the changes. What code would i use to do that with a message prompting them are they sure? I also would like a cmd button to print all records for annual review. Any input will be greatly appreciated...
View 13 Replies
View Related
Jul 8, 2004
I have tried lots of examples but getting nowhere. Please help!
I use a form to keep a record of employees training. Form name: "ITD Data Entry"
Individuals are identified by a primary key called "SERVICE NUMBER"
I have a button on my form. When I scroll to the right record I click this button to go and preview a report, called "ITD CERTIFICATE".
My aim is to be able to just print off the record I am viewing, but at present if I select print I end up printing off all the records, which would involve a lot of paper
At present, to get around this, I have to select a print range. OK for me, but not great for a stranger to the database.
Is there a way to control this button to print preview the current record only?
Many thanks for your help in advance.
Fallyhag
View 7 Replies
View Related
Jun 20, 2005
How do I go about copying data from a main form to the sub form?
I have a Soldto form with a Shipto subform.
When the two are the same I'd like to have a button to copy the data from the Soldto form to the subform.
I've tried some examples posted on this forum but, don't seem to cover a sub form.
Also, I have very limited coding experience, so please be gentle.
Thanks for any/all help you can give.
View 3 Replies
View Related
Oct 23, 2004
In the database I am developing, users have to be able to copy a table, no data, structure only. The source table is always the same one. Users have to be able to specify the name of the new table.
I would like to have them do this on a form, easy of use is important. Any ideas on this? Thanks. Trucktime
View 2 Replies
View Related
May 20, 2006
hi guys....
am new here and i need smal help :)
i have 3 tables inventory and sales and order and i made 3 forms for each table
in inventory form the user will only read the data
in sales and order the user will enter and delete the data
so my problem is i want to know how when the user enter the data in order form all the data will be copy in inventory table so what ever added in order table it will be copy or updated to inventory table
how can i do that?? :confused:
View 7 Replies
View Related
