RE: Print Current Record Only

From: Bruce (anonymous_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 05:35:03 -0700

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
>> ebutts@online.microsoft.com
>> "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?=
>> <MelissaLambino@discussions.microsoft.com>
>> | Subject: Print Current Record Only
>> | Date: Tue, 20 Jul 2004 09:05:06 -0700
>> | Lines: 7
>> | Message-ID: <4307D35F-2707-4887-9436-
3DD6791ED47A@microsoft.com>
>> | 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.
>> |
>>
>>
>.
>

Loading