Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > Selecting Recor...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 5684 of 5947
Post > Topic >>

Selecting Record for Re****t Macro

by =?Utf-8?B?QUogUmFpYmVy?= <AJ Raiber@[EMAIL PROTECTED] > Jul 30, 2008 at 10:21 AM

I have a command button that is programmed to run re****ts when clicked. 
How 
can I change the code below to select only the current record for
printing?

Private Sub Print_Re****ts_Click()
On Error GoTo Err_Print_Re****ts_Click

    Dim stDocName1 As String
    Dim stDocName2 As String
    Dim stDocName3 As String
    Dim stDocName4 As String
    Dim stDocName5 As String

    stDocName1 = "BackgroundInvestigationRequest"
    stDocName2 = "Business Rules Pg 3"
    stDocName3 = "InprocChecklist"
    stDocName4 = "ISO Certification"
    stDocName5 = "VA Form 2280a"
    
    DoCmd.OpenRe****t stDocName1, acNormal
    DoCmd.OpenRe****t stDocName2, acNormal
    DoCmd.OpenRe****t stDocName3, acNormal
    DoCmd.OpenRe****t stDocName4, acNormal
    DoCmd.OpenRe****t stDocName5, acNormal

Exit_Print_Re****ts_Click:
    Exit Sub

Err_Print_Re****ts_Click:
    MsgBox Err.Description
    Resume Exit_Print_Re****ts_Click
    
End Sub
 




 7 Posts in Topic:
Selecting Record for Report Macro
=?Utf-8?B?QUogUmFpYmVy?=   2008-07-30 10:21:01 
Re: Selecting Record for Report Macro
Steve Schapel <schapel  2008-07-31 12:29:45 
Re: Selecting Record for Report Macro
=?Utf-8?B?QUogUmFpYmVy?=   2008-07-31 07:01:00 
Re: Selecting Record for Report Macro
Steve Schapel <schapel  2008-08-01 08:05:26 
Re: Selecting Record for Report Macro
=?Utf-8?B?QUogUmFpYmVy?=   2008-07-31 13:14:40 
Re: Selecting Record for Report Macro
Steve Schapel <schapel  2008-08-01 13:02:23 
Re: Selecting Record for Report Macro
=?Utf-8?B?QUogUmFpYmVy?=   2008-08-01 07:16:09 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 12:58:22 CST 2008.