473,563 Members | 2,747 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is this a bug in Access 2013 - with accdb files attached

4 New Member
See attached accdb files

In Form1 Key Preview is set to YES
When you press the ESC key the application exits.

However if you click on Button1 the ESC key does not work anymore.
Button1 just does
DoCmd.TransferD atabase acLink, "Microsoft Access", "c:/Test1/BackEnd.accdb", acTable, "Table1", "Table1"
DoCmd.DeleteObj ect acTable, "Table1"
Attached Files
File Type: zip Test.zip (143.3 KB, 43 views)
Mar 21 '19 #1
2 1190
ADezii
8,834 Recognized Expert Expert
The trick is to place the Code in the Form's KeyDown() Event and NOT the KeyPress() Event (KeyPreview = Yes):
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
  2. Const conESCAPE_KEY = 27
  3.  
  4. If KeyCode = conESCAPE_KEY Then
  5.   DoCmd.Quit acQuitSaveAll
  6. End If
  7. End Sub
Mar 25 '19 #2
Eli Naiman
4 New Member
Thank you. This is a work-around that works. I still think it is a bug that should be fixed.
Mar 25 '19 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
4300
by: Steve | last post by:
How do you programatically save files that are attached to an email to a specified folder? It could be one file or multiple files attached to the email. Can it be done if Outlook Express is being used or does Outlook have to be used? Thanks for all help! Steve
4
2428
by: nomeepk | last post by:
hi, i am using access 2013, Is there a way i can make this Access Database online, so i can access and use it from anywhere in a Browser? Regards.
5
3401
by: jimatqsi | last post by:
I'm looking for information about compatibility between Access 2013 and Access 2003. I've been approached by a firm that wants to begin upgrading their systems. I want to know if it is reasonable to plan to keep the back-end of an Access database in 2003 format while gradually updating client machines from Office 2003 to Office 2013. The...
0
1671
by: LeoVBNET | last post by:
Hi Because VS 2013 dropped SQL COMPACT databases, I need to convert Access 2013 databases into SQL COMPACT in order to be able to use Linq to SQL in VB 2013. Anybody can help me? Thanks
6
2684
by: GKJR | last post by:
I have been using Access 2013 (in Office 365) with Windows 8.1 for about a month and a half now. I was a little reluctant to switch from 2010 on Windows 7, but I figured I should try stay ahead of the curve, and I also heard it had much better functionality for touch screen devices which I imagine are only going to get more and more popular. I...
1
2248
by: msilva100 | last post by:
Is it possible to split a Runtime MS Access 2013 database? I am on a Windows 7 server. I have one license of MS Access 2013. But I would like distribute this application to 5 client workstations. So I am trying understand the best approach.. Do I need a license for each client machine? Or is ithere a way to place backend and front end with...
1
1036
by: tallen | last post by:
ADezii and zmbd, I have one other question. There seems to be some other code which possibly should reflect the new DAO code. the following does not allow forms to open any longer and files were not moved. I believe the issue is showing the additional string path and view Private Sub cmdDETAIL_Click() If IsNull() Then MsgBox...
1
1063
by: Obakeng1168 | last post by:
I am expected to produce an xml as per the sample EDI claim xml that I have attached. I only managed to achieve it by using several queries as per the database that I am attaching. When I export the date comes with time, I used the format date in the query to change it to date only, but when I put it in the other queries it refuse to export. ...
0
7664
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7583
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7885
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7948
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6250
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5484
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3642
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.