Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. njacovides

    Access application installation procedure with password

    Thanks for the info. I'll take a look.
  2. njacovides

    Access application installation procedure with password

    Hi, i am looking for a way of creating an installation procedure for an application developed in MS Access, so that it requires some sort of password or key and user details before it allowes the installation of the application, in an effort to minize somewhat the chances of the application...
  3. njacovides

    Working on Excel Workbook from Access while other workbooks are open

    You are absolutely right!! I can't believe I didn't notice that. Programmers syndrome I guess. Many many thanks for pointing it out!!!! Best regards, NJ.
  4. njacovides

    Working on Excel Workbook from Access while other workbooks are open

    Hi all, I've created a MS Access VBA automation where a table is exported to an excel workbook, and then the workbook is opened and a pivot table is created. The application works fine as long as there are no other excel workbooks open. If another workbook is open however, the application...
  5. njacovides

    Create a Pivot Table in Excel from Access VBA Module

    Never mind... Just worked it out. Many thanks again. Rgds, N.
  6. njacovides

    Create a Pivot Table in Excel from Access VBA Module

    Thanks Geoff, looks like its at least opened the workbook correctly. However I now get a run-time error 438 on the line where I try to determine the worksheet final row. > FinalRow = WSD.Cells(myWorkbook.Rows.Count, 1).End(xlUp).Row How would I call the worksheet "WSD" now that I am working in...
  7. njacovides

    Create a Pivot Table in Excel from Access VBA Module

    Hi, I have created an export function in MS Access to automatically export a table to MS Excel. Following the export, I am trying to create a pivot table in the excel workbook just created from access to a new worksheet. As a first step I have created the function to create the pivot table as a...

Part and Inventory Search

Back
Top