A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Open Access, then database?



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2004, 08:53 PM
James T.
external usenet poster
 
Posts: n/a
Default Open Access, then database?

Access 2000

I have been able to open Word and Excell using this type
of code, but trying it with access will open the app, but
not the data. With Word it is:

' Open the document.
..Documents.open(path ...)

But I don't know what replaces "documents" in trying to do
it with access.

Option Compare Database

Private Sub Command0_Click()

' start Microsoft Access.
Set accessapp = CreateObject("access.application")

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.?????????.Open ("j:\etc...\MERGForms.mdb")

End With

End Sub

Anyone know?

Thanks!

James

  #2  
Old May 26th, 2004, 09:39 PM
Gerald Stanley
external usenet poster
 
Posts: n/a
Default Open Access, then database?

Try

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.OpenCurrentDatabase("j:\etc...\MERGForms.mdb")

End With

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Access 2000

I have been able to open Word and Excell using this type
of code, but trying it with access will open the app, but
not the data. With Word it is:

' Open the document.
..Documents.open(path ...)

But I don't know what replaces "documents" in trying to do
it with access.

Option Compare Database

Private Sub Command0_Click()

' start Microsoft Access.
Set accessapp = CreateObject("access.application")

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.?????????.Open ("j:\etc...\MERGForms.mdb")

End With

End Sub

Anyone know?

Thanks!

James

.

  #3  
Old May 26th, 2004, 10:00 PM
James T.
external usenet poster
 
Posts: n/a
Default Open Access, then database?

Gerald,

Thanks! That did it. Now I have three, Word, Excel and
Access.

James
-----Original Message-----
Try

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.OpenCurrentDatabase("j:\etc...\MERGForms.mdb")

End With

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Access 2000

I have been able to open Word and Excell using this type
of code, but trying it with access will open the app,

but
not the data. With Word it is:

' Open the document.
..Documents.open(path ...)

But I don't know what replaces "documents" in trying to

do
it with access.

Option Compare Database

Private Sub Command0_Click()

' start Microsoft Access.
Set accessapp = CreateObject("access.application")

With accessapp

' Make the application visible.
.Visible = True
' Open the document.
.?????????.Open ("j:\etc...\MERGForms.mdb")

End With

End Sub

Anyone know?

Thanks!

James

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.