Unbound form throwing error on close. - Microsoft Access / VBA

isaphrael

I have an unbound form with a textbox with an input mask 00\-00000;;_
Putting some data into the text box and then trying to close it [via
the close button] throws the 'didnt match input mask' warning, and if
I click ok on that it brings up an error:
"You can't save this record at this time." ..."data changes will be
lost...want to close...anyway?" [YES][NO]

It doesn't give me an error number, and I don't have any records to
save.
What can I do to capture this error?

Nov 13 '05 #1

Subscribe Reply

1680

Allen Browne

You can catch the error in the Error event of the Form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"isaphrael" <id******@yahoo.com> wrote in message
news:54**************************@posting.google.c om...

I have an unbound form with a textbox with an input mask 00\-00000;;_
Putting some data into the text box and then trying to close it [via
the close button] throws the 'didnt match input mask' warning, and if
I click ok on that it brings up an error:
"You can't save this record at this time." ..."data changes will be
lost...want to close...anyway?" [YES][NO]

It doesn't give me an error number, and I don't have any records to
save.
What can I do to capture this error?

Nov 13 '05 #2

isaphrael

Wow, thanks. I suppose I really should have known that, shouldn't I?

You can catch the error in the Error event of the Form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Nov 13 '05 #3

Similar topics

6316

Sum Unbound Control on Continuous Form Footer?

by: Pat | last post by:

Hello, I've used Sum() to total bound fields on a continuous form with no problem. However, I now have a continuous form, on which I use an unbound field to calculate the number of hours between...

Microsoft Access / VBA

3020

data in a tex field on an unbound form

by: jean.ulrich | last post by:

Hi I have a form that is not related with a table neither a query (unbound form) On this form I have a text field where the user can put a text or a number As I dont want to create a table...

Microsoft Access / VBA

3766

Problems Saving Multiple Unbound Fields to a Table

by: TORQUE | last post by:

Hi, Im wondering if anyone can help me with a problem. I have a form with more than 50 unbound fields. Some of the fields will be blank from time to time. This seems to be where im having...

Microsoft Access / VBA

3670

Unbound form questions

by: TD | last post by:

I'm looking for input into my decision to switch to ADO and unbound forms. I get tired of having to block all of the ways a user can unknowingly save a record, like using the PageUp, PageDown keys...

Microsoft Access / VBA

2123

Cannot Save unbound text

by: jamesnkk | last post by:

I have an unbound text - txtfreight on a Subform, when I enter a value , it does not save to the Main form table immediately, unless I close and open up the form. How can I force to save immediately...

Microsoft Access / VBA

3053

Unbound Form to update multiple tables

by: Presto | last post by:

I am making a front end mdb so users can enter new members data. I can then import this into the master database on the backend and erase the existing info on the front end to keep the data...

Microsoft Access / VBA

2664

'Problem with NotInList and unbound Form

by: Volker Neurath | last post by:

Hi all, I have a Problem with combobox-property "NotInList" and an unbound Form. The situation: On my main form i have three comboboxes for data-exchange (here: Names of distributor,...

Microsoft Access / VBA

12487

Controlling query criteria from an unbound form field

by: DeZZar | last post by:

Hi all, Unfortunately I am quite a novice with Access!! I've created a number of data bases for my work however becuase my skills are limited to really built in functionality and wizards my...

Microsoft Access / VBA

5140

Unbound Text Boxes in Subform

by: jwessner | last post by:

I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command...

Microsoft Access / VBA

7260

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7384

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7525

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5685

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4746

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3233

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3222

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

799

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

456

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General