Blocking "Escape" Key ?

Sep 24, 2005

Is there a way to block "Escape" key in a form - to be no reaction at all when I press "Esc"?

Cancel, Escape Et Al

Mar 9, 2005

Using Access 97, I have a single-form allow-additions form where a couple of bound fields are auto-populated 'on current' and a couple of other bound fields are left to be populated by the user (me!).

At the end of an input session, I can press ESC and then close the form OK. But if I forget to press ESC and try to close the form, I have an invalid incomplete record on screen.

How do I indicate that the new record isn't wanted? I have tried stuff like
If Me!txtRequiredBoundField = Null then
SendKeys "(ESC)"
End If
to no avail.

Thanks in advance.

View 2 Replies View Related

Disabling Escape Key

Nov 16, 2005

Hi All,
I need some help. I want to disable the Escape key when users are entering data on a form. How can I do that?
Help apprecieted
Regards
K

View 2 Replies View Related

Blocking A Query

Jan 8, 2005

How can you block a query from getting new information from a table? but yet keep it's current values.

View 1 Replies View Related

Blocking Design View

Jun 15, 2005

How can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening.

Any ideas?

Thanks

View 3 Replies View Related

Blocking Data Entry

Jan 14, 2008

Sales information can be added against a customer record. What I would like to achieve is for users to still be able to record new sales information, but historical sales information (e.g. before 2007) can be viewed but not be able to be edited or changed. Is there a way of achieving this.
Thanks in advance...Paul

View 3 Replies View Related

Blocking Data Input

Jun 11, 2005

In my data input form I have several boxes. In one case i wish to allow data to be input if a certain box is marked. that mark will allow any of six boxes to be checked. This works for me. However, in the event that the certain original box is marked in error, how do I allow the box to be unmarked and make the six other boxes closed to input?

such as: (box) do it
(box) one (box) two (box) three

box do it is marked. It allows any of 1,2,3 to be chosen. Box do it is marked in error and reclicked to blank. Boxes 1,2,3 need to close up so they cannot be marked. How do I get them to close up?

Thanks

View 1 Replies View Related

Escape From A Record Entry Using Code

Feb 2, 2005

Hi,

I would like to be able to abort a record input using code rather than the esc key on the keyboard.

Is this possible, if so can anyone help with the correct code or method etc.

Sue

View 1 Replies View Related

Escape Double Quotes In A String??

Jun 25, 2007

How do you guys escape the double quotes in the string..

Code:sRandomNumber = "1234"sCmdLine = "-RandomNumber="" & sRandomNumber & """

I tried this but this doesn't work...

sCmdLine = "-RandomNumber=""" & sRandomNumber & """"

I tried another method which doesn't work either...

sCmdLine = "-RandomNumber=" & chr(34) & sRandomNumber & chr(34).

What I got instead is this..

--snip--
-RandomNumber=""1234""
--snip--

Thanks...

View 5 Replies View Related

Blocking Security Warning When Access Starts

Apr 18, 2007

When I open my DB (I use Access 2003), Access flashes a window 'Security warning : This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?'
How do I stop this annoying message so that my DB opens directly?

View 1 Replies View Related

Reports :: Scan Barcode To Equal Escape Command

Mar 4, 2014

I am trying to add a barcode to a report of mine that I can then scan in order to escape/close that report. The reason for this is my work station will not have a keyboard. The user will simply scan a work order number, this will bring up a report on screen with work order detail. Then to get back to main screen to scan next work order I need to be able to escape/close the current report without using a keyboard.

View 3 Replies View Related