Mike,
I have a button on a form that appends records to a table. What I am trying to do is replace the MS access error message when there are problems with the append.
Here is my code, I tried to use the help but it does not seem to be working -
Private Sub Command3_Click()
Dim Response...
This is from the online help - hope it helps!
LTrim, RTrim, and Trim Functions Example
This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.
Dim MyString...
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,
Thanks for the help it worked beautifully.
Another question - is is possible to remove the Yes button from the error message? I do not want the user to append the records.
OR could I write my own error message?
Jacqui
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...
I am using the Transferspreadsheet command to create a spreadsheet.
I managed to sort of resolve the problem. I moved the database to a new directory. Everything seems to be working for the moment.
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 tried what you gave me but I get the following error:
"The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object 'BillingIndicator.'"
What does this mean???
Here is my code:
Private Sub txtPreviewWAreport_Click()
On...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.