Search results

  1. G

    Microsoft Scripting Library in VBA Code

    Dear Insane, I agrre with You that the "Microsoft Scripting Runtime" is included in the references list for Access 2007, but the reference list included all the component of Access 2007 and that are included in other installed application. My question is if the "C:\Windows\System32\scrrun.dll"...
  2. G

    Microsoft Scripting Library in VBA Code

    Dear Support, I use ".FileSystemObject" in one VBA routine of my Access 2007 application that use the Microsoft Scripting Library reference ( scrrun.dll). This DLL is included in the Access 2007 Runtime distribution? If is not included whre I can find the Dll to distribute? Thank's for the...
  3. G

    How Test DROP Table in Access Backend

    Re: How Test DROP Table in Access Backend -Update Dear Cheers, I ask You a litle question. For This code i snecessary to add a line with . Close? Thank's for the support Giovanni Roi =====Your Code=========== With OpenDatabase("C:\TMP\Backend_be.accdb") .Execute "DROP TABLE [" &...
  4. G

    How Test DROP Table in Access Backend

    Dear Cheers, thank's for you support. The indications that you have sne to me are very useful to solve the problem to DROP the Table in the backend. WHY I USE THIS TECNIQUE: I have decided to use this technique of integral copy the table from the front-end to the back-end why my intention is to...
  5. G

    How Test DROP Table in Access Backend

    Threre support, I use this code to upgrade the Access Backend data base but I have the problem to test the DROP execution of the table in the Backend before copy the new table. I insert a time pause to be sure that DROP command are executed but this is a critical issue because I am not sure...
  6. G

    Rename File with partial name

    Dear Wayne Tank's for the solution that solve my problem. Regards Giovanni Roi
  7. G

    Rename File with partial name

    I need to make a VBA Code to rename a file using only a section of the name. The problem is that the first part of the name change any day and I need to ignore this part and rename the file. The second part of the filename ".0651.TXT" don't change. I need to do: RENAME C.\temp\*.0651.TXT...
Back
Top Bottom