in
All Tags » VBA » using (RSS)

Browse by Tags

  • How to copy FoxPro recordset into existing Access Table using VBA

    I want to query FoxPro using a DSN-less connection and insert the recordset retrieved into an existing Access table using the best way possible in VBA in Access. Suggestions? Thanks!
    Posted to Access (Forum) by microsoft on 03-30-2010

  • Create an odbc link using vba!!

    Hi All, In Access, do you know how to create an odbc link using vba? Trying to avoid having to setup odbc links on everyone's computer so they can use sql server tables. Note: don't want to use linked tables for this one. Thanks, Marc
    Posted to Access (Forum) by microsoft on 12-07-2009

  • automate zip and unzip

    Daily I create a zip file that acts as an update capsule for a remote database I maintain. The remote database is set to delete several tables and replace them with the more current tables in a zipped mdb file. I have everything automated via vba except unzipping the mdb. I would like to unzip h:/common...
    Posted to Access (Forum) by microsoft on 10-31-2009

  • INSERT Statement using VBA in Access Database

    I am trying to insert a bunch of dummy records into an Access Database table using VBA in a module called survey_results. Below is the code I am using. I'm getting the infamous Object variable or With block variable not set (Error 91). I have Access 2003 using windows xp. Public Sub build_survey...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-14-2009

  • I want to open another excel file using VBA

    I am working on an application using an excel file. I want to open another excel file using VBA. The file will always have the same name but it can be on a different drive and directory on my computer. I can open the file using the code generated with the macro recorder as follows, but don't know...
    Posted to Excel (Forum) by microsoft on 07-10-2009

  • Create and delete folder using VBA

    Hi All I need some code that will create a folder on the C drive after i've done what i needed i need to delete the folder again. I need to do this with VBA from a button on an Access Form. Thanks in advance Elmo
    Posted to Access Coding/Macros (Forum) by microsoft on 07-08-2009

  • Insert row in Excel using VBA

    I have a cell selected from previous code in my procedure and I want to insert a row above the current cell. What code would I use to do this.
    Posted to Excel (Forum) by microsoft on 06-19-2009

  • Problem: Compress/Zip an Excel file using VBA

    Experts, I would like to be able to do the following I have an Excel File which has reached 174MB which is non the server. Each time I work with it form there I takes ages to open and being updated. I am actually copying it locally then move it back again. What I would like is to have a way of compress...
    Posted to Excel (Forum) by microsoft on 06-09-2009

  • Problem: If Formula using VBA

    I have a form that I using to insert data into a spreasheet. Each time the user adds a record a new row is created. Before the row is inserted I determine what the row # is. There are going to be some fields that aren't entered but are calculated. I am trying to use the following: Range("u"...
    Posted to Excel (Forum) by microsoft on 06-03-2009

  • Problem: Excel 2000: Using VBA to create an Outlook 2000 email

    I need to have VBA create and email message by coping information from worksheet that mimics an email template. The template has named ranges for the common email information (rngTo, rngFrom, rngSubject, rngMsg, etc.). The tricky part is that part of the information includes a 15 Row by 2 column table...
    Posted to Word (Forum) by microsoft on 05-30-2009
Page 1 of 2 (14 items) 1 2 Next >