Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-14-2019, 06:05 PM   #1
ellenr
Newly Registered User
 
Join Date: Apr 2011
Posts: 316
Thanks: 46
Thanked 0 Times in 0 Posts
ellenr is on a distinguished road
Access having trouble with Excel

This program has been running perfectly for several years with no changes. Suddenly, an embedded macro crashes the program on two computers running the Runtime2013. The same computers were able to generate the Excel file properly last year.

The macro:
Code:
EMailDatabaseObject
Object type       query
Object Name     FlightExport
                to     =[forms]![mainmenu]![ProShopEmail]
(no CC or BCC)
Subject              NCGA Excel Player List
Message Text      Attached is an Excel file containing...
Edit Message       Yes
I imported all into a new db, compacted, etc. The darn thing works perfectly on my two computers (I have Office 365). Any ideas?

ellenr is offline   Reply With Quote
Old 09-14-2019, 07:22 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,685
Thanks: 50
Thanked 1,077 Times in 1,058 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access having trouble with Excel

Hi. Any new changes to the two computers recently such as Windows updates? Just curious...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-15-2019, 03:21 AM   #3
ellenr
Newly Registered User
 
Join Date: Apr 2011
Posts: 316
Thanks: 46
Thanked 0 Times in 0 Posts
ellenr is on a distinguished road
Re: Access having trouble with Excel

Hi, DBguy--thanks for looking at this. I have no idea about the recent updates on the computers in question--they are at opposite ends of the state. The program uses a shared MySql db. Both have full access to the data and are able to print a report that includes all of the info in question. At least one of the users stays current on updates. I don't know the other person as well. As I mentioned, the only difference from my computer that I can find is that they are running under the runtime. I do keep the current dated version of the Access program on the organization's ftp site, and users are alerted when they open it that a new version is available and that they must download it. I can also tell which dated version they last opened, so I know the current clean compacted version is being run.

ellenr is offline   Reply With Quote
Old 09-15-2019, 05:28 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,685
Thanks: 50
Thanked 1,077 Times in 1,058 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access having trouble with Excel

Quote:
Originally Posted by ellenr View Post
Hi, DBguy--thanks for looking at this. I have no idea about the recent updates on the computers in question--they are at opposite ends of the state. The program uses a shared MySql db. Both have full access to the data and are able to print a report that includes all of the info in question. At least one of the users stays current on updates. I don't know the other person as well. As I mentioned, the only difference from my computer that I can find is that they are running under the runtime. I do keep the current dated version of the Access program on the organization's ftp site, and users are alerted when they open it that a new version is available and that they must download it. I can also tell which dated version they last opened, so I know the current clean compacted version is being run.
Hi. If you suspect the problem could be the runtime environment, then you could force your computer into simulating it by using the /runtime switch when you start Access or simply rename the file extension to ACCDR. Another option is to create a virtual machine.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-16-2019, 01:28 PM   #5
ellenr
Newly Registered User
 
Join Date: Apr 2011
Posts: 316
Thanks: 46
Thanked 0 Times in 0 Posts
ellenr is on a distinguished road
Re: Access having trouble with Excel

I tried running on my computer as .accdr and it still worked. I redid the db using Access 2010 and the user tried that and it still crashed although it worked for me. Got a little more info from the user -- she cannot send any email out of the db. Where I originally suspected Excel/runtime the SendObject itself seems to be the culprit. These users are using db program from my up-to-date Win 10 computer on the very same runtime 2013 they used last year (this db handles a once-per-year tournament). One of the users with the problem runs Outlook, but that isn't a recent change, either. If the problem hadn't suddenly occurred for two users at opposite ends of the state, I might wonder about a corrupted runtime. I am sure their copy of the db is pure, because I can see the version# when they log in and it is the same as on my computer, meaning they downloaded new version after I uploaded it. I really need this to work--it is one of the best features of the program. I also set one of my computers to use Outlook and the db was happy sending email through it. BTW, sending through CDO works just fine.

Last edited by ellenr; 09-16-2019 at 01:39 PM.
ellenr is offline   Reply With Quote
Old 09-16-2019, 03:06 PM   #6
ellenr
Newly Registered User
 
Join Date: Apr 2011
Posts: 316
Thanks: 46
Thanked 0 Times in 0 Posts
ellenr is on a distinguished road
Re: Access having trouble with Excel

Is there an easy way to just open a query in Excel -- the user can then forward it on to whomever.

ellenr 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
Trouble with date/time parameter from Excel passed into Access query. Kreuz Excel 1 01-27-2014 06:25 AM
Trouble with date/time parameter from Excel passed into Access query. Kreuz Queries 0 01-21-2014 12:09 PM
Trouble importing Access Query into Excel LynnEsther Queries 3 07-21-2009 06:36 AM
trouble with VBA between Access and Excel qwertyjjj Modules & VBA 10 04-28-2007 02:40 PM
Having trouble woth type conversion when importing from Excel to Access boksi Tables 4 02-17-2005 05:47 AM




All times are GMT -8. The time now is 06:59 PM.


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