Topics Search

Change Error Message?

Change Error Message?
Views: 3
In my database I have several buttons to open forms and reports, If the user doesn't enter anything and clicks cancel I get the following error message:

The OpenReport Action was Cancelled, or syntax error in date in query expression. Is there any VBA I can put in which would let me show my own error message?
Sponsored Links:

More topics

 

Change error message for dupicate entry

Preview
Is there a way to change the pop up message for someone trying to enter duplicate information? Right now it a long message that is not very easy to understand for non Access users
 

Error message refers to a form that does not exist

Preview
I receive the following error message when I open a database: (see attachment).
The original table name was changed and a new form designed that functions fine. I can find no trace of the form mentioned in the error message. I thought I had deleted any old forms when I made the change. This table is linked to another database and the error form is not located there either.
The macro referred to does not show up anywhere that I can find.
After I acknowledge the error message the database works fine.
 

What does this macro error mean? Return without GoSub.

Preview
I just made a change to my database and now I am getting an error message when I open it. The message says: "The expression OnCurrent you entered as the event property setting produced the following error: Return without GoSub."

What does this message mean?
 

Record is too large. (Error 3047).

Preview
I am creating a Access 2007 db based on a questionnaire with long text answers. I received this message and managed to delete the offending record and change some of the text fields to memo fields.

I have received the error again, but I am a bit stuck this time. It looks like a number of my records are too large and unfortunately they have child records, so I can't just delete them. I can't change the records as I just get the same message again and I can't change more text fields to memo fields as I get the same message.

Is there any way round this? Would it help to split the main table into 2 smaller tables?
 

Alternative error message

Preview
I just can't find soultion for the following prooblm:

On the table - field proprties, I have set on of the field to be Required and not to alow Zero Length values.

On the form, when skipping entering a value in the bound field, I get the standard system error message, but I would like change this message, because it refernces to a cryptic field name, and not to field name like "Enter First Name".

I have tried many combinations on IsEmpty and IsNull in the field LostFocus and AfterUpdate events, and I have tried to use the Validation Rule - but all those will not cover the situation where I jump from field to field with the TAB-button, or just go to an another record without entering the field at all.

So, does anybody have a solution for usining the table validation, but with an another error message
 

Open report filter from form getting error message

Preview
This so easy but I keep getting a weird error message.

Here is the code to open the report.

DoCmd.OpenReport "rptCrewCompanies", acViewPreview, , [CrewMemberId] = Me.cboWorker.Column(0)

I get the error message -

.can't find thefield '|1' referred to in your expression.

I should mention if I change [] to " " the report returns no records.

I swear folks I can't find |1 anywhere
 

Join Error

Preview
with this error message:

Goal: to create a one-to many relationship join between two tables
Error message: Relationship must be on the same number of fields with same data types.

The error message may seem self-explanatory, but, as a newbie I don't have a clue
 

error message when opening the database

Preview
after double clicking on the myDBname.mdb file, the following error message pops up:

The Microsoft jet database engines stopped the process because you and the other user are attempting to change the same data at the same time.

I was not able to go into the database. Is there any way to fix this corrupted database? I had tried the compact and repair, but it didn't
 

Error Message in Access2007

Preview
I'm getting the error message when trying to run a simple query in Acess 2007. Once you click past this error message the query runs fine.

"The setting you entered isnn't valid for this property. To see the valid settings for this property, search the Help index for the name of the property.

How do I turn off this error message
 

Error Message

Preview
I'm getting the error message when trying to run a simple query in Acess 2007. Once you click past this error message the query runs fine.

"The setting you entered isnn't valid for this property. To see the valid settings for this property, search the Help index for the name of the property.

How do I turn off this error message