Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What Code Do I Write ?

0 views
Skip to first unread message

Jone

unread,
Nov 11, 2007, 11:31:01 PM11/11/07
to

Jone

unread,
Nov 11, 2007, 11:35:00 PM11/11/07
to
What code do I write when I want my main menu form to check for a file before
it opens if it cannot find the file it should not open ? for Ex. check if I
have the file C:\Windows\Sample.txt if it cannot find if it should not open

Allen Browne

unread,
Nov 12, 2007, 12:07:45 AM11/12/07
to
If Dir("C:\Windows\Sample.txt") <> vbNullString Then

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jone" <Jo...@discussions.microsoft.com> wrote in message
news:2616FFC4-4240-4862...@microsoft.com...

Jone

unread,
Nov 12, 2007, 12:57:00 PM11/12/07
to

"Allen Browne" wrote:

> Sorry it dose not work

Rick Brandt

unread,
Nov 12, 2007, 8:10:09 PM11/12/07
to

What happens? There is nothing wrong with the code Allen provided.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


0 new messages