473,385 Members | 1,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Access will not show compile error on Button_Click in form

Hi all,

I have a problem with an Access database, I do not see any VBA Compile-errors or Runtime Errors (ie. 3011 when the filepath is too long).

See attached image where I have a Button in a Form with a deliberately error in the VBA-code. When I click the Button, nothing happens, I have to open the VBA-windows and go to Debug->Compile to see the error (se attached image).



I've gone through different settings but I have not found anything that fixes this problem.

On a different machine with the same Access-version I get the Runtime Errors which makes me think that this is a local setting. Therefore I've tried reinstalling Access but with the same result.

I've tried adding the line DoCmd.SetWarnings True before the "Msgboooox"-line, but same result.

Would appreciate help since it's quiet cumbersome to develop on a machine that will not give errors if something is wrong :)

But on a different machine with the same Access-version I get a Compile Error directly when I press the Button, and I can see the Runtime Errors (same exact Access-file, copy-paste between the machines). See image below.
Oct 27 '21 #1
1 7459
isladogs
455 Expert Mod 256MB
For info, there are no images attached so its difficult for anyone to assist
Oct 29 '21 #2

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

Similar topics

5
by: xuatla | last post by:
Hi, I encountered the following compile error of c++ and hope to get your help. test2.cpp: In member function `CTest CTest::operator+=(CTest&)': test2.cpp:79: error: no match for 'operator='...
4
by: kathy | last post by:
Working in a form, I have an Iif statement where if a date is not filled in, another field will show as a blank. If the date IS filled in, the 2nd field will show its actual value. The following...
2
by: Kathy Houtami | last post by:
Hi there I've been encountered with weird compile error using Access 97. The error message is "Member or data member is not found" and it highlighted a line of code that has not be changed and...
2
by: Kathy | last post by:
Hi All, I have several users who are getting a compile error "Can't find project or library when the code hits Dim cat as ADOX.Catalog In the references dialog box it show the msadox.dll as...
2
by: bradleyp | last post by:
Hi all, Hopefully somebody can help. In Access 2002-SP2, I receive an error from the VB Editor if I try to compile the following code (see below). The error is as follows: Compile Error:...
5
by: MLH | last post by:
A97 aborts creation of MDE reporting that there's a compile error in one form. Sure enough, if I remove the form from the source database and attempt to compile the MDE, it succeeds. But when I...
17
by: MLH | last post by:
I have tested the following in immed window: ?isnumeric(1) True ?isnumeric(1.) True ?isnumeric(1.2) True ?isnumeric(1.2.2)
3
by: Elphaba31 | last post by:
Hello Gurus, I have been tasked with correcting issues with our upgrade(Access97/2000 to Access2007) and essentially know very little about Access (any version) or Visual Basic. Here is my current...
4
by: Shona Rennie | last post by:
Hi Self taught user of access and I have the following problem in Access 2003. I have a form with 2 continous subforms. All the data has been added and all information is correctly linking. I...
1
by: laurabbface | last post by:
I keep getting the following error: Compile error: Expected End Sub Can someone show me what I'm doing wrong & how to rewrite? Private Sub Exit_Click() DoCmd.GoToRecord , , acNewRec ...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.