A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print Current Record Only



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2004, 05:05 PM
Melissa Lambino
external usenet poster
 
Posts: n/a
Default 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.
  #2  
Old July 20th, 2004, 06:59 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default Print Current Record Only

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.
|

  #3  
Old July 20th, 2004, 08:03 PM
John Nurick
external usenet poster
 
Posts: n/a
Default 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  
Old July 21st, 2004, 03:17 PM
Melissa Lambino
external usenet poster
 
Posts: n/a
Default 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  
Old July 21st, 2004, 04:27 PM
Melissa Lambino
external usenet poster
 
Posts: n/a
Default 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  
Old July 22nd, 2004, 07:20 AM
John Nurick
external usenet poster
 
Posts: n/a
Default 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  
Old July 23rd, 2004, 01:35 PM
Bruce
external usenet poster
 
Posts: n/a
Default 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  
Old July 27th, 2004, 06:14 PM
Melissa Lambino
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.