PROBLEM ACCESSING ACCESS QUERIES AND REPORTS FROM VB6

[20002000]

i AM BUILDING A DATABASE APPLICATION THAT USES AN ACCESS DATABASE. THE QURIES AND REPORTS WORK WELL IN ACCESS. I DECIDED TO BUILD THE FORMS USING VB DATACONTROLS. i HAVE GOT THE DATABASE WORKING FINE BUT i DO NOT KNOW HOW TO ACCESS THE QUERIES AND REPORTS SET UP AND SAVED IN ACCESS.
PLEASE I NEED TIPS ON HOW TO DO THIS. i AM DESPERATE.

 

[Denaeghel]

Perhaps you can try this. It is just for query's.

First you must add the line
PARAMETERS in your query.

Your name for the query (ex: TEST)
ex: PARAMETERS FName text;
Select *
from Authors
where Firstname = Fname;


In VB you can use this code

dim cmd as new ADODB.Command
Dim ParmTemp as adodb.Paramter

set cmd.activeconnection = cn
cmd.commandtext = "Test" 'Name of the query
cmd.commandtype=adcdmStoredProc
set parmTemp=cmd.createParameter("Fname", adchar, adParmamInput, 255)
cmd.parameters.append parmtemp
cmd("FName&quot = "John" 'This can also be an variable
set rs = cmd.execute

Let me know if it works?

 

[Hackster]

To run your Access reports from VB, create a reference to the Microsoft Access Object Library, and use the following code:

Dim Axs As Access.Application
Set Axs = CreateObject("Access.Application&quot
Axs.OpenCurrentDatabase (App.Path & "\YourDB.mdb&quot
Axs.DoCmd.OpenReport "YourReportName"
Axs.Quit

 

[Eradic8or]

How would you then use this to open a database that belonged to a workgroup with a username and password?

Eradic8or.