MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Dim oAccess As Access.Application oAccess = New Access.ApplicationClass() oAccess.OpenCurrentDatabase(filepath:="s:\database\test.mdb", Exclusive:=False) '----> Open Access Query, pass parameters that the report is based upon. Parameter 1 = mID, Paramter 2 = pID (both integers) oAccess.DoCmd.OpenReport(ReportName:="prMemoSingle", View:=Access.AcView.acViewNormal) oAccess.CloseCurrentDatabase() oAccess = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|FTP recursive download files||5||26|
|Changing existing fields in a Stored Procedure and getting them reflected in Crystal Reports||3||56|
|Is it possible to get data from a web-based interface and bring it over to an Access database?||4||34|
|SQL Server and Access Database (Project Codes) get the next record||43||32|
Join the community of 500,000 technology professionals and ask your questions.