Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-23-2019, 08:05 AM   #16
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Event procedure not working on opening until VBA code is opened and closed

not necessarily on separate module, form module.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
HangoutGuy (08-23-2019)
Old 08-23-2019, 08:12 AM   #17
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,888
Thanks: 38
Thanked 571 Times in 538 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Event procedure not working on opening until VBA code is opened and closed

This message has nothing to do with your code. That message is saying that a button does not support a click event, which is not true. I would try to compact and repair, but I would expect that not to help. You most likely need to decompile and recompile. You can google how to do a decompile.
MajP is offline   Reply With Quote
Old 08-23-2019, 08:14 AM   #18
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,888
Thanks: 38
Thanked 571 Times in 538 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Event procedure not working on opening until VBA code is opened and closed

https://www.fmsinc.com/MicrosoftAcce.../Decompile.asp

MajP is offline   Reply With Quote
Old 08-23-2019, 08:34 AM   #19
HangoutGuy
Newly Registered User
 
Join Date: Aug 2019
Posts: 28
Thanks: 18
Thanked 0 Times in 0 Posts
HangoutGuy is on a distinguished road
Re: Event procedure not working on opening until VBA code is opened and closed

Quote:
Originally Posted by MajP View Post
This message has nothing to do with your code. That message is saying that a button does not support a click event, which is not true. I would try to compact and repair, but I would expect that not to help. You most likely need to decompile and recompile. You can google how to do a decompile.
Is there any reason why my button just started working when I started up my db again? Because now I'm having no problems and I didn't change anything or even compact & repair for that matter. And this wasn't the first time I shut it down and reopened it.
HangoutGuy is offline   Reply With Quote
Old 08-23-2019, 08:46 AM   #20
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Event procedure not working on opening until VBA code is opened and closed

maybe outlook is causing the problem.
you code does not stop and wait for outlook to finish, when you put the command SendObject.
it continues to the next record and so on.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-23-2019, 09:51 AM   #21
Insane_ai
Not Really an A.I.
 
Join Date: Mar 2009
Location: Cleveland, OH USA
Posts: 264
Thanks: 15
Thanked 27 Times in 24 Posts
Insane_ai is on a distinguished road
Re: Event procedure not working on opening until VBA code is opened and closed

Sometimes a decompile / recompile is needed to work these bugs out. Here's an example for you:
Code:
"C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\Users\C58148\Documents\EQR.Accdb" /decompile
Edit for your database then perform a compact and repair.

__________________
I actually know a few things, just not all of them.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Insane_ai is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple event procedure windows opened FrankP Forms 2 03-02-2013 06:54 AM
OnClick Event Procedure not working. mailman26 Macros 0 06-13-2012 11:23 AM
on Focus event procedure not working mcgraw Forms 7 12-22-2009 06:31 AM
After Update Event Procedure Code Del_Piero_3 Forms 0 08-19-2005 04:25 AM
Event Procedure in Acess not working mtreske Modules & VBA 4 10-16-2003 01:41 PM




All times are GMT -8. The time now is 03:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World