Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Forums > Developers
Back to Access Developer Forum    Comments List
Stock Portfolio Upload Images   Link   Email  
Robert Melcher        
33 days ago
I have double and tripled checked the code and everything works up until I run the refresh data button. The sataus shows the Excel file is opening but then everything freezes. I end the excel task and the debug shows this line of code not working.

XL.Workbooks.Open "D:\OneDrive\Desktop\Stocks.xlsm"

I have checked the address and it is correct. What is wrong.
Robert Melcher        
33 days ago

Sami Shamma              
33 days ago
Do you get any error messages?
Robert Melcher        
33 days ago
It is strange, all I get is a beep after the statusbox shows opening Excel. I have to use Task Manager to end the task, then I get the the error message below.
Robert Melcher        
33 days ago

John Davy           
33 days ago
Hi Robert
Did you double check the name on the statusbox?
Robert Melcher        
32 days ago
The statusbox is working fine, the first message shows up (Opening Excel). At about 10 seconds after that command pops up I hear a beep and Access locks up. I have to use the task manager to end the Excel process, then the error message pops up.
Robert Melcher        
32 days ago

Kevin Robertson            
32 days ago
Does the stock database that Richard built in class work on your machine?
Robert Melcher        
32 days ago
I created the stock update form, with the button, closed down the stock portfolio form, and ran the process and it worked.
Robert Melcher        
32 days ago
Kevin, I followed along and created it by hand. It worked a couple of times but now I am getting the same error as before. I am rebooting my computer to clear the memory, then I will try again. I don't think Excel is closing down properly. I will see what happens and let you know.
Thomas Gonder       
32 days ago
May I ask what class or Tech Help Robert is using to formulate the db and code for this original post?
Kevin Robertson            
32 days ago

This one: Stock Portfolio
Robert Melcher        
32 days ago
Guys I found that onnce I completed the techhelp video, everything works and now I need stocks to input into the form. I have tried opening and closing it and used the buttons and no issues. Thanks for your input.
Richard Rost             
27 days ago

Add a Reply Upload an Image


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/19/2024 6:59:20 AM. PLT: 1s