Reference to use 'fIsAppRunning' in Access 2002

[Dave Lauberts]

Hi

Sorry to ask a silly question, I am 'self taught' in using access vb and I
came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error 'Sub or
Function not defined'.

I assume I have to create a reference in 'Tools', 'References' but don't
know which one. Can any body help me please?

I currently have the following available references ticked ( priority order
as shown)

Visual basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Or I am totally on the wrong track?

Regards
Dave

[Douglas J. Steele]

No reference is required. Just make sure you've got all the code from
http://www.mvps.org/access/api/api0007.htm pasted into a module (not the
module associated with a form), and that you didn't name the module
fIsAppRunning.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Dave Lauberts" <da************@ntlworld.com> wrote in message
news:A6***************@newsfe6-gui.ntli.net...

Hi

Sorry to ask a silly question, I am 'self taught' in using access vb and I came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error 'Sub or Function not defined'.

I assume I have to create a reference in 'Tools', 'References' but don't
know which one. Can any body help me please?

I currently have the following available references ticked ( priority order as shown)

Visual basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Or I am totally on the wrong track?

Regards
Dave

[Pieter Linden]

"Dave Lauberts" <da************@ntlworld.com> wrote in message news:<A6***************@newsfe6-gui.ntli.net>...

Hi

Sorry to ask a silly question, I am 'self taught' in using access vb and I
came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error 'Sub or
Function not defined'.

I assume I have to create a reference in 'Tools', 'References' but don't
know which one. Can any body help me please?

I currently have the following available references ticked ( priority order
as shown)

Visual basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Or I am totally on the wrong track?

Regards
Dave

I only have VBA, Access, DA0 3.6 running, and it works. Does the code
even compile on your computer? Copy the code from here to a new
module, and see if it works...

http://www.mvps.org/access/api/api0007.htm

There are example calls in the article.

[Dave Lauberts]

Thanks Doug

- I missed the actual 'fIsAppRunning' function !, I was trying to refer to
something that did not exist!

Thanks for taking the time to put me straight

Dave
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:Ia*********************@twister01.bloor.is.ne t.cable.rogers.com...

No reference is required. Just make sure you've got all the code from
http://www.mvps.org/access/api/api0007.htm pasted into a module (not the
module associated with a form), and that you didn't name the module
fIsAppRunning.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Dave Lauberts" <da************@ntlworld.com> wrote in message
news:A6***************@newsfe6-gui.ntli.net...

Hi

Sorry to ask a silly question, I am 'self taught' in using access vb and I

came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error

'Sub or

Function not defined'.

I assume I have to create a reference in 'Tools', 'References' but don't
know which one. Can any body help me please?

I currently have the following available references ticked ( priority

order

as shown)

Visual basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Or I am totally on the wrong track?

Regards
Dave

[Dave Lauberts]

Thanks Pieter- I missed the function itself- Appreciate your link to the
solution.
Dave
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"Dave Lauberts" <da************@ntlworld.com> wrote in message

news:<A6***************@newsfe6-gui.ntli.net>...

Hi

Sorry to ask a silly question, I am 'self taught' in using access vb and I came trying to use fIsAppRunning to see if excel is running in the
background but when I try and compile the code I get a compile error 'Sub or Function not defined'.

I assume I have to create a reference in 'Tools', 'References' but don't
know which one. Can any body help me please?

I currently have the following available references ticked ( priority order as shown)

Visual basic for Applications
Microsoft Access 10.0 Object Library
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Or I am totally on the wrong track?

Regards
Dave

I only have VBA, Access, DA0 3.6 running, and it works. Does the code
even compile on your computer? Copy the code from here to a new
module, and see if it works...

http://www.mvps.org/access/api/api0007.htm

There are example calls in the article.