Search results

  1. I

    VBA error trapping for SQL Server connection

    Hello! I have a front end Access DB 2007 that calls stored procedures (SP) in SQL Server 2010 (ODBC connection through DSN). Today the server went down while a SP was executing. The Access application just hung and could not be closed by any other means than through task manager. How do I trap...
  2. I

    Question Enable all Macros Settings an evil must?

    Thanks! That seems like the approach I want to take. In terms of implementing it - any advise?
  3. I

    Question Enable all Macros Settings an evil must?

    Why does one have to enable all macros in the trust center in order for VBA to run? I'm making front end applications with Access and having to allow ALL macros to make them user friendly makes a huge hole in general security. I don't use any macros - it's all done by VBA. Users are on a...
  4. I

    Exporting Report to PDF blank fields on some computers only

    Still no solution to why this is happening. We tried adding 3 buttons for the same report. Printing & Output doesn't work while Viewing works just fine. :confused: Methods Output: DoCmd.OutputTo acOutputReport, sReportName, acFormatPDF, sFilePath, False Print: DoCmd.OpenReport sReportName...
  5. I

    Please help me with saving form totals

    Hi, One of the easier ways to do this without too much coding is to make some bound invisible text boxes to store the totals. Assign the unbound text box(es) you use for displaying totals to desired hidden text boxes in your form. Simply add below code to your input fields' after update event...
  6. I

    Exporting Report to PDF blank fields on some computers only

    Thanks Estuardo, We tried printing it hard copy and it is the same problem. Actually the blank problem is visible in "print preview" but not in "view" and only for this report section. We did manage to get the print preview to work if the sub report is opened by itself but not when it is by...
  7. I

    counting in access on a make table query (was - Counting yes/no fields)

    Hi, Make one query to select the data you need. Then construct the make table query based on the first query. In the second query you can do a iif(isnull([some_field]),0,[some_field]) to handle those pesky nulls. J.D.
  8. I

    Exporting Report to PDF blank fields on some computers only

    Hi all, I have a report (Access 2007) with subreports that is being exported to pdf. It all works fine on PC except for on a virtualbox and a laptop. When the user exports the report to pdf, it leaves some subreports blank! If the report is opened in the DB it pulls data as it should and all...
Back
Top Bottom