Search results for query: *

Hi, I would like to know how I can trap the errors relating to the following types of errors: -type conversion failure, -key violations -lock violations -validation rule violations

Hi, I have an append query run by a macro. To prevent all the MS Access messages appearing I have Set Warnings off BUT then the user does not realise the information was not appended to the table as duplicate records where encountered. What I would like to do is trap the Key violation error...

Hi, When I attempt to use the Transferspreadsheet command I get the error message "object is read only". The background is I had to have the database written to a CD to move it to a client site. When I copied the database off the CD I changed the file property to remove the read...

Hi, I have a MS Access form which calls a Query - the user can select whether or not to enter a date range. The query works when a date range is input BUT if no range is selected I want the query to return all the rows, including the nulls dates. Here is my SQL - I have bolded the date range...

Hi, I have created a variance report (the variance is calculated in the query upon which the report is based). What I would like to do is - if the variance calculated is negative I would like to make the variance value red and bold.

Hi, I have an unbound form which the user selects a projectcode from and this currently runs a report. I now need to change this form to run one of two different reports - (1) I now need to identify in the project table the billingindicator for the projectcode selected, and then decide (2) if...