locked
Access 2010 VBA or Macro reference help RRS feed

  • Question

  • Is there a reference guide for Access 2010 and coding with macros or VBA? I have a reference guide downloaded for Office Excel 2003 VBA but can not find a similar useful resource for Access. Something with detailed specs. for example trying to write VBA script using DoCmd.TransferSpreadsheet. It uses a parm for RANGE and using the specifc worksheet name I can specify "sheet1!A1:S4' and it will import that range. For Excel VBA I can also refer to sheets by the relative number... sheet(1), sheet(2), etc. I have a spreadsheet with 50 sheets all different names I should be able to use the relative sheet number but can not find any documention on the syntax for range for Access 2010 VBA... you would think VBA should be VBA and consistent between products. Point me to the docs and I usually figure this stuff out.

       

    Friday, June 17, 2011 2:39 PM

Answers

  • You can start learning VBA basics following Crystal site:

    http://www.accessmvp.com/strive4peace/VBA/Index.htm

     

    By following the Help / MSDN sites you can find more info on VBA as well.

    Search for books "learning VBA for Microsoft Access" in Amazon.

     

    HTH,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Marked as answer by Bruce Song Thursday, July 7, 2011 1:45 PM
    Friday, June 17, 2011 7:04 PM

All replies

  • Do you want to import all worksheets from a single Excel file into Access?

    Check below link out of Ken Snell, Import Data from All Worksheets in a single EXCEL File into Seperate Tables via TransferSpreadsheet (VBA):

    http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

     

    HTH,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    Friday, June 17, 2011 3:51 PM
  • Worked Awesome. Did not think to come in as Excel app to build the array of sheetnames (I did not want to type all of those out!)

    Is there a good reference doc for Access VBA?

    Friday, June 17, 2011 6:07 PM
  • You can start learning VBA basics following Crystal site:

    http://www.accessmvp.com/strive4peace/VBA/Index.htm

     

    By following the Help / MSDN sites you can find more info on VBA as well.

    Search for books "learning VBA for Microsoft Access" in Amazon.

     

    HTH,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Marked as answer by Bruce Song Thursday, July 7, 2011 1:45 PM
    Friday, June 17, 2011 7:04 PM