|
-
Jul 31st, 2007, 01:53 AM
#1
Thread Starter
Addicted Member
[RESOLVED] can u clarify my "acceessing M.S Access with V.B" problem
Hi All!
while i was browsing VB forum, i found a thread related to M.S access with V.B, that is what i am searching for.
Actually, i ran the following code, but while my data base"sample.mdb" was opening, a popup message "security waring " is coming, if i clik ok, then only the data base is opening...
(1) what shall i do, to avoid that popup menu..
(2)another thing is, to open the table in the data base (here table is "table1)
i have to double clik on it. can i also open the table with programatically..?
(3)If possible kindly explain the below lines where i commented,for what purpose there are to be written...
Private Sub Command1_Click()
Dim objACCESS As Access.Application
On Error Resume Next
Set objACCESS = New Access.Application
objACCESS.OpenCurrentDatabase App.Path & "\sample.mdb"
DoCmd.OpenReport "table1", acViewPreview ' WHAT IS acViewPreview
objACCESS.Visible = True
DoCmd.Maximize 'PLEASE EXPLAIN THESE FOLLOWING LINES
objACCESS.DoCmd.Maximize
objACCESS.DoCmd.OpenReport "PID", View:=acViewPreview
objACCESS.DoCmd.Maximize
End Sub
Thanks in advance:
regards:
raghunadhs
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|