Close A Form After All Report Have Printed
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 Replies
ADVERTISEMENT
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
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
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
Mar 10, 2015
I am using MS Access 2003.
I would like to open the form = VendorPayables_Maintenance_F
Choose a cheque number
Print the cheque
How to create a macro to
close the open report = d_One cheque information
and close the open form = VendorPayables_Maintenance_F
View 2 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 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 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 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
Oct 14, 2004
Can anyone tell me how to have Access automatically close a report without saving any changes.
I do not mind if the user closes the report manually but do not want Access to prompt the user to save changes. I want it to automatically abandon any changes that were made.
View 6 Replies
View Related
May 31, 2015
is there a way to use vba to close the currently open report on the screen without specifying its name.
View 3 Replies
View Related
Jun 30, 2006
I am using the following dialog box to ask whether or not the user wants to print the report in the Close event of a report. I really need help finishing the code. As the user presses "X" to close the report, I would it to be that if the user says yes...the report prints. If the user says no...the report closes.:cool:
Private Sub Report_Close()
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Print the Report?"
Style = vbYesNo + vbQuestion
Title = "Report"
Help = "DEMO.HLP"
Ctxt = 5000
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then
View 1 Replies
View Related
Oct 4, 2006
I have a subform that displays results based on selections from cascading boxes on the form. I am trying to print them to a report. I think my procedure is correct for the print button and Im afraid my problem is that the form is not based on a seperate query. Is that they only way to be able to print? It is based on procedures defined in the cascading boxes. How can correct it so it will print the results to a report? Thanx.
View 2 Replies
View Related
Aug 26, 2014
I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.
View 3 Replies
View Related
Aug 19, 2013
I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
View 2 Replies
View Related
Nov 17, 2014
I am using the method from allen browne [URL] .... to open a form and add it to a collection and when removing it it closes. actually, usually it does work so but i have now a form which does not close until i am hitting the reset button in VBE , is there something i could check why it's not functioning as desired ?
Just to add, this form has a subForm as well (might be the cause ?)
View 2 Replies
View Related
Jul 30, 2015
I have a timer form which closes the database after a period of time with DoCmd.Quit. Another form is open at this point but if a user has left it in the middle of editing it I want to be able to save the record in the other form and close it before the timer form closes the database.
What VBA do I need in the timer form to save the record and close the other form before DoCmd.Quit? Just to be clear the code is...
Private Sub Form_Timer()
On Error Resume Next
Me.Tag = Val(Me.Tag) - (Me.TimerInterval / 1000)
Me.Caption = "The database will exit in " & Me.Tag & " seconds"
If Val(Me.Tag) <= 0 Then
[code]...
View 1 Replies
View Related
Mar 1, 2007
When the user clicks to close the form the Before Update event runs, and has the following code to check that all the required fields are completed:
If IsNull(Me.ToxReceived) Then
stdresponse = (MsgBox("You must enter the toxicology received date before continuing." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _
"Do you want to do that now? Click YES to return to complete the form, click NO to undo the record", vbYesNo, "Missing Data"))
If stdresponse = vbYes Then
Me.ToxReceived.SetFocus
Else
Cancel = True
Me.Undo
Exit Sub
End If
End If
If the user clicks no, and the record is undone, how do I get the close form event to still continue?
D
View 14 Replies
View Related
May 9, 2005
i put a button that run the command "docmd.close" but i found when i click it it close the form but with saving all data in field in the table, but this button should cancel record insertion, i hope i can find the answer here.
Thank you
Best Regards
View 1 Replies
View Related
May 13, 2005
I have a form that I want only to be opened from another form (i.e. the user presses a button from form1 and form2 is magically displayed).
My solution: In form2, I check to see if form1 is open in "use" mode. If not, I display a message and close form2.
The problem: The close code (docmd.close) is at the beginning of Form_Current. Apparently, Form_Current doesn't like to be interrupted. I receive a run-time error 2585 (This action can't be carried out while processing a form or report event).
Ok, so, umm, how exactly am I supposed to close the form? I tried the check during Form_Load instead, using the cancel variable instead of the docmd.close. However, I don't think this code got executed. It's almost like the form was already loaded or the Form_Load occurs after Form_Current (In my handy chart here, it says that Form_Current occurs when a form containing data is first opened and when you move to a different record.. so, I suppose it is possible).
Any thoughts?
View 3 Replies
View Related
Jan 13, 2006
I'm trying to close one form by using a button on another. This is my code:
DoCmd.Close acForm, frmSimCount
It dosen't work but comes up with an error:
Run-time errer '2493'
This action requires an object name.
I thought that was the name of the form, which is frmSimCount, could someone put me in the right direction please.
View 3 Replies
View Related
Dec 9, 2012
why a form won't close. Each time I try to I am prompted to save and when I do, the form doesn't close. When I closed the DB and reopened, none of the changes were saved.
View 6 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
Oct 25, 2006
Hi,
I want to have some queries run during the database is closed, like the functiona with "Repair on Close". But I don't want to use a form with a VBA code doing it. Is there any other possibility to do it? :confused:
Thanks in advance for answers.:)
View 14 Replies
View Related
Mar 9, 2005
Hi,
I've got a database with a linked table to a CSV file which is automatically extracted from some logging software. The Database is used to search for text strings (e.g. "example") within several fields wichin the automated extract and then show the results with any duplicated instances taken out (via an append to table query which is indexed with no duplicates).
So:
Text is entered
FieldA is looked through for a match, if a match is found the whole record gets appended to the Append table.
FieldB is looked through and if a match is found the whole record (including field A) is appended, however if the match has already been found in A, then the record is not copied.
It does this for several fields and then you get a table which is every record containing the searched for text with no duplicates.
This table is then displayed as a subform on another form in it's "table" view.
The form I'm trying to close is the form which contains the above subform.
I've tried:
A macro with close -> form -> formname which doesn't work.
Code:
Private Sub Toggle2_Click()
On Error GoTo Err_Toggle2_Click
DoCmd.Close
Exit_Toggle2_Click:
Exit Sub
Err_Toggle2_Click:
MsgBox Err.Description
Resume Exit_Toggle2_Click
End Sub
Which also doesnt work!
HOWEVER, just to make things interesting, if I click to view the form design, then run the form again, it will close fine using either method. It just seems not to work on the initial run of the text search which then opens the form displaying the subform.
Any ideas?? I can't understand why it won't work.
Cheers - Hope I explained it ok :)
View 1 Replies
View Related
