Search results

  1. J

    Importing Password Protected Excel File in Access

    Hi All, I have a macro set up using the TransferSpreadsheet action to import an excel spreadsheet into an access db. I now have a new requirement to password protect this spreadsheet. When I try to import the spreadsheet with password protection activated, I receive the following error msg...
  2. J

    Receiving An Error If No Variance In My Report

    Hi All, I have a report that calculates variances. For example, there are 2 columns on my report. One has # of Hours from one system and the other column shows # of Hours from a second system. I then have a column that displays any variance that may occur. When there is a variance, the report...
  3. J

    Converting Null Value to $0.00

    Hi All, I have a table that has fields that captures dollar amounts. I have these fields set to a default value of "0". The tables are updated via a query that imports a csv file. Once the import process has finished, my table has blank values in some of the fields that capture dollar...
Back
Top Bottom