Recent content by get4peterin

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.

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...

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.

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,

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...