in
All Tags » VBA (RSS)

Browse by Tags

  • Populate Array using a Loop

    I have a procedure that does a very specific operation and I am trying to find a way to write it more generally since as I get deeper into my data I am not going to know how many elements I am going to have to write to the array. My goal is to use a single IF statement to determine if records exist in...
    Posted to Visual Interdev (Forum) by microsoft on 05-30-2010

  • Problem running SQL Select from VBA (Identifier is too long"

    I am trying to run a constructed SQL command to import a recordset into my Excel 2003 worksheet. I have tested the code such that the Select statement is valid, but am having problems getting it to execute. The Error message says "The identifier "My Select Statement" is too long. maximum...
    Posted to Queries (SQL) (Forum) by microsoft on 05-28-2010

  • Access 2007 VBA end user saving control captions

    Hi Experts! Note sure if this is possible (I really hope it is) but here's the scoop. I've a form whereby the end user can select what their buttons do. It works to a certain degree except when the form is closed the captions are lost. From the code below - here's the way it works... User...
    Posted to Access Forms (Forum) by microsoft on 05-28-2010

  • runtime error 1004 in excel vba

    Would anyone have even the slightest idea what might be going wrong with the following code? Sometimes it works fine, but most of the time I get a 'runtime 1004: application-defined or object-defined error' NOTES: -When stepping through application, runtime 1004 error is raised on the 'End...
    Posted to Miscellaneous (Forum) by microsoft on 05-28-2010

  • Get the row number for use in a VBA procedure

    I have a procedure that will run when the user clicks a toggle button, the procedure should change the formula in the cells in the range from something like "BUD_FEES!$H6" to VLOOKUP(RowNumber & Column A, CY_SAP, 29, FALSE) What the goal is is to get the formula to change in the range of...
    Posted to Miscellaneous (Forum) by microsoft on 05-28-2010

  • Get Cursor to Start in Left Part of Date Field

    I have some forms in Access that have quite a few dates to be entered on them. The information is not always entered in a particular order, so the end users will skip around the form by clicking on the field to enter. They are asking me if I can fix it so that when they click on a date field, the cursor...
    Posted to Access Forms (Forum) by microsoft on 05-28-2010

  • Problem closing Adobe Reader using DDE in Access VBA

    I am currently trying to print existing pdf's using VBA, I have come up with a DDE route from example code in the Adobe documentation (see attached). Adobe Reader is opened and the document sent to the printer fine however the debugger then appears with the message "Run time error 291 - The...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-28-2010

  • MS Access VBA delete tables with no rows

    Hi, I have an Access database that I am using to import tables from other databases. I want to delete all tables that have no rows. I know how to find the tables with no rows manually through using standard SQL, but I would like to automate the process.
    Posted to Access Coding/Macros (Forum) by microsoft on 05-28-2010

  • Excel VBA to Evaluate and Protect Sheets

    I have a workbook that will always have 2 worksheets. One called "New" and one called "variables". The workbook may contain 1 or more other worksheets and if it does I want to use an on open event to protect any sheet(s) that is not "New" and is not the "variables"...
    Posted to Visual Interdev (Forum) by microsoft on 05-27-2010

  • VBA References - DLL Hell

    I’m having a problem (that after much reading seems like a common one) with references in my vba app. I will be distributing a mde to any number of workstations running w2k or xp. I need to have my app use the dll’s and ocx’s that I copy to the machine during the setup program. I would rather not modify...
    Posted to Miscellaneous (Forum) by microsoft on 05-26-2010
Page 2 of 298 (2977 items) < Previous 1 2 3 4 5 Next > ... Last »