Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Costa Rica
    Posts
    40

    Unhappy Unanswered: Search path of "MSACCESS.EXE"

    In a Module of Visual Basic in Microsoft Access i need to obtain the path where is located "MSACCESS.EXE" and assign to a field this path.
    Example: MSACCESS.EXE located in "C:\MICROSOFT OFFICE\OFFICE10"
    FOUNDDIR = "C:\MICROSOFT OFFICE\OFFICE10".

  2. #2
    Join Date
    Aug 2003
    Posts
    15

    Re: Search path of "MSACCESS.EXE"

    Originally posted by Manuel Gimenez
    In a Module of Visual Basic in Microsoft Access i need to obtain the path where is located "MSACCESS.EXE" and assign to a field this path.
    Example: MSACCESS.EXE located in "C:\MICROSOFT OFFICE\OFFICE10"
    FOUNDDIR = "C:\MICROSOFT OFFICE\OFFICE10".
    I am not sure if I understand what you are getting at, but if you want to assign the path to the field FOUNDDIR.

    fOUNDIR.SELECT
    SENDKEYS ("c:\MICORSOFT OFFICE\OFFICE10")

    if you are trying to assign it to the variable FOUNDIR, just make sure you define the variable as string before you use your line of code

  3. #3
    Join Date
    Nov 2002
    Location
    Norway
    Posts
    239
    Try

    MsgBox SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •