Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open crystal report through access

Status
Not open for further replies.
rekhatr10

rekhatr10

Programmer
Apr 2, 2004
67
0
0
US
Hi everyone,

I have to launch crystal report using access97 using ODBC connection. I have no idea how to do it. Could you point me in the right direction
Thank you
RR
 
Sort by date Sort by votes
A starting point:
Dim Sh As Object
Set Sh = CreateObject("WScript.Shell")
Sh.Run "\path\to\report.rpt"
Set Sh = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
135
Moss100
Moss100
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
103
ziffer68
ziffer68
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
288
dhookom
dhookom
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
67
combo
combo
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
115
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top