Search results for query: *

Mike, I want the user to know there is an error. Can you help me out? My VB is extremely limited. Jacqui

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.

Thanx, it worked!

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