Passing parameters from VB to an Access DB

[Giblets]

Hello there,I'm having some trouble at the moment trying to pass parameters from vb to access, what I want to do is bring up an access report in vb regarding a particular customer, does anyone know how to pass the parameter from vb to access to allow me to do this?thanks for your time..

 

[ca8msm]

Set a reference to the access object and then:

Private AppAccess As New Access.Application

' Set Database
straccess = App.Path & "\AccessFile.mdb"

' Open Database
AppAccess.OpenCurrentDatabase straccess

' Database Commands to Print Reports
With AppAccess
.DoCmd.OpenReport "Local_single", acViewNormal
End With

Within appaccess you have access to all MS Access commands.

 

[Craigii]

Try This. Set a reference to Microsoft Access.

Dim acApp As Access.Application
Dim DB_PATH As String

DB_PATH = DatabasePath 'Your Database Path

Set acApp = New Access.Application

acApp.OpenCurrentDatabase DB_PATH, False

acApp.DoCmd.OpenReport ReportName, acViewPreview, , customer = "Your Customer"

Hope it helps

 

[ca8msm]

Sorry forgot to mention that you just need to have the access report set up to accept whatever parameters you need