All The Records Are Being Printed From The Form...Not Only The One
Jul 26, 2006
:confused: Hi,
I have a form that loads from a menu option. The form has two subforms. All the specs are divided in groups within the forms and subforms. The forms depend on 3 queries that have all the tables correctly gathered. So, every title has a little print button next to it if the user wants to only print that group; if he or she wants to print the entire form, there is a button for that at the end of the form. I am currently having problems with the groups printing. Given that they mostly depend on a separate table and not the general one, every time I click any of the little buttons, I end up printing all the records in that table. I would like to be able to print only the info seen at the moment on the form.:(
Here is the code of one of the groups:
Private Sub Print_OperatingMechanism_Click()
On Error GoTo Err_Print_OperatingMechanism_Click
Dim stDocName As String
stDocName = "OperatingMechanism"
DoCmd.OpenReport stDocName, acViewPreview
Exit_Print_OperatingMechanism_Click:
Exit Sub
Err_Print_OperatingMechanism_Click:
MsgBox Err.Description
Resume Exit_Print_OperatingMechanism_Click
End Sub
Thanks in advance...
View Replies
ADVERTISEMENT
Jan 18, 2005
Greetings,
I will try to explain briefly my problem.
My database is for our job card analysis.
The problem being sometimes a job card invoiced for the previous month
is only entered in the DB after reports have been generated/printed.
My thought was that if I could put a true/false check box in the record table
to somehow mark it as true after printing month end reports.
Hence late entries will reflect in the following months reports.
Is there a way of marking all the records as "reported" (True) after printing the report?
Maybe I am thinking along the wrong lines. Any suggestions?
Many thanks,
Brian.
Zimbabwe
View 2 Replies
View Related
Jan 12, 2006
Hello all,
I have a form that takes info from another form and then adds some from it's own data and then it proceeds to print a bunch of reports based on what tests were done etc. When I just print them (With preview) I have a function in the first report that prints (in its Close event) to close the form. No problem. I have a new slick little pdf thing that automatically names the files and puts them in the right spot etc. With this, after the first report is printed it closes thereby closing the form which needs to be open for the rest of the reports to open. Just put the close event on the last report that prints you say? I don't always know which report will be that last, it depends on the tests.
How can I check to see when all the reports have been printed and then close the form. Is there some way to have the form close itself after a certain time? Am I going to have to make the users close the form themselves?
Let me know if this is confusing. Upon reading over this it does sound a bit confusing. Thank you for your help and patience.
Greg
View 3 Replies
View Related
Oct 10, 2005
Maybe a strange question but what is the best way to display access forms in a PowerPoint presentation or in printed material. If i do a print screen and then tidy it up the resolution is not great.
Any ideas
View 1 Replies
View Related
Dec 2, 2004
Hello all
Can I print out a list of the fields in a table??
TIA
Kevin
View 2 Replies
View Related
Aug 20, 2007
Other than a check box, is there any way to check if a user has printed a report when they open it to view and give them a reminder on close?
Thanks
DBL
View 2 Replies
View Related
Apr 23, 2008
I have a cross_tab query, that users print on a monthly basis.
The user selects whether they want to include data for one or all of three products. So the query could show data for example for Salmon only.
I need to be able to show on the printed query, what products it is displaying for. At the moment the query is called "TotalxProccessor_Product". Once the query is printed there is no way to tell if it is for Mussels, Salmon, Oysters or all three products.
Is there an easy way to manipulate the title the query prints our with?
Or do I have to go through a report to have control?
View 1 Replies
View Related
Mar 13, 2006
Dear all, im trying to display a message to the user if a particular report has already been printed.
I have an unbound form with 2 (unbound) combo boxes one named “shift name” the other “shift date” and a button that prints a report (runs a print macro) based on what the user selects in these 2 combo boxes. I have a table (named “Table_shiftdates”) which stores all the shift names & shift dates + I have created a new Yes/no field named “printed?”.
(I’ve attached a pic, which may help explain what I currently have)
I believe I need to somehow set the yes/no field in this table too yes (or true) when a particular shift name and shift date has been printed.
Then do a check when the user clicks on the print button in this form to see if the yes/no field is set to true for the shift + date they select in the form, if it is true display a message such as: “Warning this report has already been printed”
Other than that I’m stumped and not what I need to do from here, anyone please help me out?
Cheers, Jim
View 14 Replies
View Related
Apr 26, 2005
I print a certificate for each person attending my class by sending the form (StudentForm) to a report . To save time I print and sign certificates for all preregistered students then during class I enter all students that enroll the day of class. What I would like to do is flag each preprinted record so when I select the print button after all students are entered into the database all certificates except the preprinted records will be printed. Any ideas on how to flag a printed record?
View 4 Replies
View Related
May 7, 2015
I have a hyperlink for a pdf document in my access form.
The user will enter his id and then he access to this form
I want to know when he opens the hyperlink if he will print the pdf file or not
I want to save the name of the pdf file in a table if the user prints the hyperlink document from the form.
View 1 Replies
View Related
Oct 18, 2012
I am a beginner using Access 2007. The custom written program that I am using has a minor glitch. The report has a subform inside the main report. In this subform is a form header, detail, form footer. The information that is entered into the main report that transfers to the form header, detail, and form footer works and that data is saved with no problems. When I go to create a pdf file from this report all the data transfers to the printed pdf except the information in the form footer. I have looked at the property pages and compared all the properties and they are all identical.
Below is a screen shot of the report in the design view. The areas circled in red are the data that is missing from the pdf when printed. The area in green prints correctly as well as the main body of the report. We insert comments in the comment section and also type initials in the signature section but this do not show up when printed in the pdf. The database saves the information that is input but does not print it. Not everything in the company has access to the database so this is the reasoning for generating a pdf so that it is placed on the company drive for everyone to see.
View 3 Replies
View Related
Jul 25, 2012
I have a database programmed by someone which has different section spattered by rectangles/ boxes ..
When I do print preview everything looks good but when I print the document, the rectangles/boxes disappears. Why and what can I do ..
Click on the image to see how it looks on preview..
View 3 Replies
View Related
Sep 21, 2004
How do I make the blank line disappear after the control is no longer visible? I tried to set the Height property to 0 in the OnPrint Event but I got an error message 2191, you can’t set height property after printing has started.
Thank you,
UongSaki
View 1 Replies
View Related
Feb 9, 2015
I need to save a new record from a form before it gets printed, the vba code behind the print button at the minute just opens the report and inserts the record in it. I need to put something in before that to save the record when the button is clicked.
The form in question is frmPlaceOrderFinal and I'm referring to the print button (command17). I've attached my system as well as an image for reference. The code that is currently behind the button:
Code:
Private Sub Command17_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "rptFinalInvoice"
strWhere = "[InvoiceID]=" & Me!InvoiceID
DoCmd.OpenReport strDocName, acPreview, , strWhere
End Sub
I need to save the record before it is opened in the report.
View 2 Replies
View Related
Jun 11, 2013
I have a report in access that currently works like the image Current Report.png.
I was hoping it is possible to make it look like the image in What I Want.png
More a spreadsheet type report that I can then print out.
View 9 Replies
View Related
Jul 30, 2014
I found the IDatomation Datamatrix barcode in the ActiveX controls.
Is buying their software the only way to actually get this barcode to work?
Any other way to create a 2D matrix that can be populated with data and scanned once printed?
View 12 Replies
View Related
Jan 8, 2014
I'm tracking some charges and want to report them based on month/year and an Early/Late (yes/no) flag within the query I created. When I wrote the report I grouped on mon/year then on Early/Late, then calculate averages. I then want to calculate the difference in the charges between the Early & Late rows. Here....
Jun 13
32 868 27 (Early row #, charge, avg)
11 1279 116 (Late row)
Now I want to subtract the 27 from the 116. I figured out I could assign the 27 to a field in the header and the 116 in the footer, that's the only way I could make them "stick". I then calculate the difference and things are great. Until I try to print it. When I print the difference is 0 because the group header & footer fields are both populated with the 27.
View 14 Replies
View Related
Aug 28, 2014
I have a form with a Yes/No checkbox. Sometimes a data entry person will use this, sometimes an associated report is printed and a technician in the field will be required to fill check the box by hand and return the report for data entry. what I have tried to format the check box, if the box isn't already checked, I can't get it to show up clearly on the printed report. It's set to Visible, width 6pt, solid, black, always display, yet it still is barely visible. Ive tried increasing the grid line thicknesses, making it shadowed, nothing seems to work. Is there anything I can do?
View 9 Replies
View Related
Feb 25, 2013
I am attempting to create a printed label with a concatenated field. I want the field to abbreviate several shapes and colors but i will just start with the shape.
=IIf([Shape]="round","RD","TH")
This is what my basic statement says. I am attempting to nest other options inside of this.
=IIf([Shape]="round","RD",IIF([Shape]="oval", "OV", IIF([Shape]="triangle", "TR", "TH")))
Is this the correct syntax? I can not seem to get it to work.
View 7 Replies
View Related
Apr 6, 2015
I am using an MS Access 2010 table as a data source for a mail merge. I would like to update a field in the table with the date that the letter is printed. Is there a way to do this?
View 5 Replies
View Related
Feb 15, 2013
I have a rental database and I print several contacts for leases etc. what I want to do is have a unique reference number or something inserted to the report every time that it's printed. What I am trying to achieve is to keep track of which tenant corresponds to the report (Lease) printed by using reference number.
There is a seperate form which holds the tenants details and I would like to have a field on that form which would show the same reference number as the report so I can track which report was printed for who.
Whats the best/easiest way to accomplish this?
View 1 Replies
View Related
Jul 3, 2015
I have a report which shows the results of two separate queries in a simple table view.
One set of data varies in size depending on the amount of records and the other is a fixed size and never changes.
I'm wanting to make my report always show the fixed size data in the bottom right corner of the page when its printed.
I've tried putting it in the footer section of the report but don't want it to affect the size of the details section and just show next to the other query results.
Is this possible and if so how would I achieve this?
View 6 Replies
View Related
Aug 20, 2013
I'm using Access 2007 SP3.
Whenever I export reports to PDF, the output appears zoomed and clipped. No extra pages are generated as they would be if I'm going over margins, it's just the report is clipped.
The report looks perfect in preview mode, and it looks perfect when going to an actual printer. However, when using OutputTo to save it as a PDF, this is when the report content is clipped.
Here is the code I'm using:
DoCmd.OpenReport MyReport, acViewPreview
DoCmd.OutputTo acOutputReport, "", acFormatPDF, "MyReport.pdf"
DoCmd.Close acReport, MyReport
I open the report in preview mode first so events are fired that show/hide various objects based on fields in the recordset.
I've tried reinstalling, and I've tried this on two different machines, one running Windows 7 and one running Windows Server 2008...both with the same results.
View 5 Replies
View Related
Mar 22, 2013
One shows my form with the Transporters Subform with 3 entries, and 1 entry.The three line items that say "Transporter" are in one subform. I used this code
Code:
Private Sub Form_Current()
If Me.RecordsetClone.RecordCount >= 3 Then
Me.AllowAdditions = False
End If
End Sub
to limit the number of records I can add to 3 or less.My issue is that I lost the blank text box that allows you to add another record. So, if I only have one Transporter listed, there's no box to let me add a second or third.I have the following properties for the Transporters Subform set to "Yes":
Data Entry
Allow Additions
Allow Deletions
Allow Edits
Allow Filters
View 3 Replies
View Related
Dec 12, 2014
I have a form which needs update ever month. When the form is opened, the end user can see the old records and data, and also a new record is added for any new data. I want to protect the old saved data and the user can only add, edit, or delete the new data in the newly added record. The problem is once a user adds the new data and moves to another record or another form, then he/she cannot edit or change the new data in case if there is any mistake or need to change something after couple of minutes.
I changed the Form Data Properties "Allow Additions", "Allow Edits", and "Allow Deletions" many different times and situations to solve this problem but with no success. I tried the following with NO success too: One of the Fields of the Record is (Month). In the Data Properties, I set a Default Value for this field as(December 2014) for instance. I set the Data Properties "Allow Additions", "Allow Edits", and "Allow Deletions" to (Yes). Then I put the following code in the Form's Current Event:
Private Sub Form_Current()
If Me.month.Value = "December 2014" Then
Me.AllowAdditions = True
Me.AllowEdits = True
Me.AllowDeletions = True
[Code] ....
View 3 Replies
View Related
Jul 28, 2005
I have form setup with two cascading combo boxes (facility and date) to select a record (other navigation, including mousewheel, is disabled). There is a button to open another form which allows addition/deletion of records by facility and date. When this form is closed, the combo boxes update accordingly on the initial form. However, if I select a new record whose facility/date I have just entered, it seemingly shows the wrong values for several of the other fields. If I check the corresponding table, the values are actually at default, though, and when I reopen the form they have reverted to default. Any ideas on how to solve this? I'm tempted to simply have the first form close and reopen when the second is closed, but couldn't figure out the syntax to close a form with a button on a different form. Let me know if there's any more information I need to provide. Thanks for any suggestions.
View 9 Replies
View Related