If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print Current Record Only
This is from a previous problem. When a user fills out a request form if the need by date is less than 2 weeks ahead of the submitted date a message box pops up telling the user they must either change the date they need it or print the request and submit it to their director for approval.
When I click print button on the message box, it prints all the other records except the record user is trying to submit. How do I get it to print just the current record? Another problem also is that because you can not fill out the rest of the form without a date, I think that when the current record is printed it will not be completely filled out. How would I go about fixing that as well. Thanks so much any and all help is appreciated. |
#3
|
|||
|
|||
Print Current Record Only
Hi Melissa,
If I understand the situation right you probably need to do something like this: -Add two yes/no fields to the table called (e.g.) SpecialApprovalReqd and SpecialApprovalOK. -In the BeforeUpdate event of the textbox that accepts the need-by date, check how far ahead the date that the user has entered is. If it's less than 2 weeks and SpecialApprovalReqd is False, put up a messagebox informing the user that special approval will be needed and asking if they want to continue, or go back and change the date. If they want to continue, set SpecialApprovalReqd to True. -Allow the user to fill in the rest of the data. When they finish (perhaps in the Form's BeforeUpdate event) check the value of SpecialApprovalReqd and SpecialApprovalOK. If the first is true and the second isn't, print the record and put up a message reminding the user to get it approved. -Modify the rest of the application so that requests that have SpecialApprovalReqd = True and SpecialApprovalOK = False are not acted on. -Add some system for setting SpecialApprovalOK to True once the director has approved. For printing the record, it may be enough just to print the form as it appears on screen. Otherwise, create a report that displays what's needed, filtered so it only prints the one record (getting its ID or whatever from the form). Remember that the record must be updated before it contains the data to be printed. On Tue, 20 Jul 2004 09:05:06 -0700, Melissa Lambino wrote: This is from a previous problem. When a user fills out a request form if the need by date is less than 2 weeks ahead of the submitted date a message box pops up telling the user they must either change the date they need it or print the request and submit it to their director for approval. When I click print button on the message box, it prints all the other records except the record user is trying to submit. How do I get it to print just the current record? Another problem also is that because you can not fill out the rest of the form without a date, I think that when the current record is printed it will not be completely filled out. How would I go about fixing that as well. Thanks so much any and all help is appreciated. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#4
|
|||
|
|||
Print Current Record Only
Thanks to the both of you.
John: I understand what you are saying, but I don't know a lot about coding and am not sure how to set it up. Some guidance would be greatly appreciated. |
#5
|
|||
|
|||
Print Current Record Only
I've tried this and when I hit the Print Record button, VB opens up and there is a criteria mismatch on the DoCmd.OpenReport line. It did work the very first time I tried it though, but when I closed the form and reopened it, I began to get the error message.
-- Melissa "Eric Butts [MSFT]" wrote: Hi, Take a look at: ACC2000: How to Print a Single Record from a Form in a Report (209560) http://support.microsoft.com/default...B;EN-US;209560 I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Support "Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com/ to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026." This posting is provided "AS IS" with no warranties, and confers no rights -------------------- | Thread-Topic: Print Current Record Only | thread-index: AcRuc1KlNT4NFs3RQR6/wDMFKxTQSQ== | X-WBNR-Posting-Host: 128.210.148.129 | From: =?Utf-8?B?TWVsaXNzYSBMYW1iaW5v?= | Subject: Print Current Record Only | Date: Tue, 20 Jul 2004 09:05:06 -0700 | Lines: 7 | Message-ID: | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.access.gettingstarted | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.gettingstarted:152518 | X-Tomcat-NG: microsoft.public.access.gettingstarted | | This is from a previous problem. When a user fills out a request form if the need by date is less than 2 weeks ahead of the submitted date a message box pops up telling the user they must either change the date they need it or print the request and submit it to their director for approval. | | When I click print button on the message box, it prints all the other records except the record user is trying to submit. | | How do I get it to print just the current record? Another problem also is that because you can not fill out the rest of the form without a date, I think that when the current record is printed it will not be completely filled out. How would I go about fixing that as well. | | Thanks so much any and all help is appreciated. | |
#6
|
|||
|
|||
Print Current Record Only
Hi Melissa,
I'm snowed under with other things just now but will be able to help a bit come the weekend. The code for the BeforeUpdate of the date textbox will ber something like this: Private Sub txtStart_BeforeUpdate(Cancel As Integer) Const MSG_1 = "Special approval will be required. " & vbCrLf _ & "Click OK to proceed or Cancel to return " & vbCrLf _ & "and revise the date" Const MSG_TITLE = "Date" Dim lngAnswer As Long If (Me.ActiveControl.Value Date + 14) _ And (Me.SpecialApprovalReqd = False) Then If MsgBox(MSG_1, vbInformation + vbOKCancel, MSG_TITLE) _ = vbCancel Then Cancel = True Else Me.SpecialApprovalReqd = True End If End If End Sub On Wed, 21 Jul 2004 07:17:04 -0700, Melissa Lambino wrote: Thanks to the both of you. John: I understand what you are saying, but I don't know a lot about coding and am not sure how to set it up. Some guidance would be greatly appreciated. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#7
|
|||
|
|||
Print Current Record Only
Did you add the extra comma? Does the field name in your
code ([CustomerID] in the example) match your primary key field exactly? -----Original Message----- I've tried this and when I hit the Print Record button, VB opens up and there is a criteria mismatch on the DoCmd.OpenReport line. It did work the very first time I tried it though, but when I closed the form and reopened it, I began to get the error message. -- Melissa "Eric Butts [MSFT]" wrote: Hi, Take a look at: ACC2000: How to Print a Single Record from a Form in a Report (209560) http://support.microsoft.com/default.aspx?scid=KB;EN- US;209560 I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Support "Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/se...ulletins/ms03- 026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com/ to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026." This posting is provided "AS IS" with no warranties, and confers no rights -------------------- | Thread-Topic: Print Current Record Only | thread-index: AcRuc1KlNT4NFs3RQR6/wDMFKxTQSQ== | X-WBNR-Posting-Host: 128.210.148.129 | From: =?Utf-8?B?TWVsaXNzYSBMYW1iaW5v?= | Subject: Print Current Record Only | Date: Tue, 20 Jul 2004 09:05:06 -0700 | Lines: 7 | Message-ID: 4307D35F-2707-4887-9436- | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.access.gettingstarted | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl! TK2MSFTNGXA03.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.gettingstarted:152518 | X-Tomcat-NG: microsoft.public.access.gettingstarted | | This is from a previous problem. When a user fills out a request form if the need by date is less than 2 weeks ahead of the submitted date a message box pops up telling the user they must either change the date they need it or print the request and submit it to their director for approval. | | When I click print button on the message box, it prints all the other records except the record user is trying to submit. | | How do I get it to print just the current record? Another problem also is that because you can not fill out the rest of the form without a date, I think that when the current record is printed it will not be completely filled out. How would I go about fixing that as well. | | Thanks so much any and all help is appreciated. | . |
#8
|
|||
|
|||
Print Current Record Only
Thanks John, whenever you get to it will be fine. I am going on vacation starting Wednesday and won't be back until the end of August, so it's no big rush. I really appreciate your help.
-- Melissa |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restrict Report To Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
Restrict Report to Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
How to get Current Record from the subform with the datasheet | Tom | Using Forms | 1 | June 18th, 2004 12:35 PM |
Button to print current record only | Fatz | Using Forms | 6 | June 17th, 2004 01:58 PM |
Printing report for current record | Linda | Setting Up & Running Reports | 1 | May 26th, 2004 05:46 PM |