in
All Tags » VBA » create (RSS)

Browse by Tags

  • Creating a DSN in VBA

    Is there a way to create an ODBC DSN in Access VBA code?
    Posted to Access (Forum) by microsoft on 05-24-2010
  • Create Windows shortcut using VBA with /WrkGrp switch

    I am trying to create a windows shortcut using VBA with the following code On Error Resume Next Dim wsShell As New WshShell Dim wsSCut As WshShortcut Dim strCommandLine As String 'Command Line for shortcut to run strCommandLine = Chr(34) & "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS...
    Posted to Access (Forum) by microsoft on 01-13-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
  • VBA Code to create PDF from XLS

    Can someone please provide VBA code to create a PDF from XLS with the file name automatically taken from a cell value without any dialog pop ups, so fully automatic? I have surfed and tried so numerous different codes and nothing works. I have Acrobat Distiller 8 and Acrobat 8 Professional installed...
    Posted to Excel (Forum) by microsoft on 08-16-2009
  • vba to create form with textboxes from an array (e.g. like jwalk tip76)

    I am pretty lazy, so before I do this fun little project myself, I want to see if anybody has already done it before. I can do this myself, and feel guilty about being lazy, so just ignore the question unless you are interested in it. Jwalk Has a great routine for asking a user to select from many options...
    Posted to Excel (Forum) by microsoft on 07-28-2009
  • How to create a primary key in VBA

    The code below works. I just need to add two things to it. 1) How do I make the '"Query_Name" field a primary key for the table Query_Name 2) How do I make Query_Name field and Table_Name field both a primary keys for the second table named Query_Table /////////////////////////////////...
    Posted to Access (Forum) by microsoft on 07-28-2009
  • Create and Delete a table with VBA

    I know how to do this via SQL, but not VBA. I wish to be able to delete a table and then create a new table via VBA. Can this be done or do I need to call in a delete table / make table query instead? Thanks
    Posted to Access (Forum) by microsoft on 07-25-2009
  • VBA - Create Text Box

    Hi, Can someone tell me how I would create a text box on my form using VBA? Would there also be a way to position it where I like? Thanks
    Posted to Access (Forum) by microsoft on 07-19-2009
  • Creating Word Document Table in Access VBA

    I want to send data from a large recordset in VBA, MS Access 2000, into MS Word 2000. The data gets put into cells in a table. The user can set up the table in Word and in the Access program can then specify how the table is set up so the data can be sent to specific cells in the table. The VBA code...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-13-2009
  • VBA - Word Macro to Create Multiple Tables of the Same Format

    We have a system that exports text into a .ini file from an Oracle Database. This is then uploaded into a Word 97 Template via a macro. At the moment there is a single table structure in a Word Template that is populated from the .ini file but we want to change the system so that it can read any number...
    Posted to Word (Forum) by microsoft on 07-09-2009
Page 1 of 2 (19 items) 1 2 Next >