Search results

  1. G

    Preview Report and Go to End of the Report

    Hi, Is there a way in VBA (MS Access) where we can preview the report, go to the last page of the report and close the previewed report. The DoCmd.OpenReport command doesn't have the parameters to sepcify the page number? Any thoughts are highly appreciated.
  2. G

    Database Crashes When using ConverToPDF

    Hi, The access database crashes and creates a backup when the following function is called in the ConvertToPDF function of Lebans code. blRet = ConvertUncompressedSnapshot(mUncompressedSnapFile, sOutFile, _ CompressionLevel, PasswordOwner, PasswordOpen, PasswordRestrictions...
  3. G

    Unhandled Exception while generating report

    I get the following error when I try to run a report in access which uses the converttopdf function. Unhandled exception at 0x6504fb2e in MSACCESS.EXE: 0xC0000005: Access violation reading location 0x00000031. Can somebody help me out? Thanks.
  4. G

    Read Each Worksheet in a file and load it to the table

    Hi, Is there a way in Access where I can read multiple worksheets in a spreadsheet and import it into the access database. Any kind of help or ideas is highly appreciated? Thanks,
  5. G

    VB script to load Excle files to Access Database

    Hi, I have one requirement where a folder would contain multiple excel files. The data present in these multiple excel files needs to be loaded to the access database. Is it possible to do through VB batch script which processes multiple excel files and loads them to the Access database? If...
Back
Top Bottom