Search results

  1. A

    Delete from one table with key linked to another

    Hi all. I kind of got stuck with this one. I'm trying to use a Delete query to delete some records from Table A. Let's say Table A has three fields: A1, A2 and A3 Then there's another table, Table B, with two fields: B1 and B2 Within one Delete Query, i need to delete all the records from...
  2. A

    Executing Import Wizard via code

    Hi all. I'm trying to enhance the functionality of an MS Access application. I want to give the user the capability to import a MS Access or MS Excel table into the application *without* having to execute the Import Wizard herself. Q1: So i'm basically looking for the VBA statement that...
  3. A

    CurrentProject.Connection failure

    Hi all. I'm having a serious problem when i'm trying to use the CurrentProject.Connection property for some ADO manipulation. Here's the error message i'm getting: Run-time error '-2147220999 (800401f9)': Method 'Connection' of object '_CurrentProject' failed In the immediate window, i try...
  4. A

    WinZip automation: using wzunzip -v to extract archive content information

    Hi all. I'm trying to automate WinZip from within MS Access. I'm using a registered version of WinZip 10.0 Pro. I ran into some trouble when i tried to extract the contents of the Zip archive to a text file. Here's the syntax i've been trying to use: C:\Program Files\Winzip\Wzunzip -v...
Back
Top Bottom