Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Stock Portfolio < Dashboards | Loan Payments >
Back to Stock Portfolio    Comments List
Extended Cut Upload Images   Link   Email  
William Dowler        
3 years ago
Richard,
Stock Portfolio Tech Help Extended Cut.
I have built the MS Access database according to your instructions in the video.
The UpdateStockPricing works fine from the Updater Form but gives me a "sub not found" error when I call it from the Refresh Stock Data button on the Stock Portfolio form.
I have checked the spelling (copied and pasted) and ensured that the sub is declared as public in the Updater form.
I've not encountered this before! Any ideas what is happening here? Many thanks....


Alex Hedley             
3 years ago
Does the template download work for you?
William Dowler        
3 years ago
Alex,
Running from the Stock Portfolio button on the Main Menu on Richard's template throws an error saying that the C;\users\Richard\desktop path is invalid.
I've changed that path in the two locations that I can find but am still getting that path error!!
I've searched for "richard" using the search project option in the vba code and cannot see any other occurrence!
Kevin Robertson             
3 years ago
William,

You need to also relink the table (StockPortfolioT)
External Data >>> Linked Table Manager
William Dowler        
3 years ago
Kevin,
Magic!!
That was it.

Many thanks......
William Dowler        
3 years ago
OK, so it now runs fine from Richards template download but I still get the "sub not found" error when running from mine.
This is doing my head in, I think I've checked everything but I still get the error.
I'm sure I'm missing something silly.... Any ideas??
Kevin Robertson             
3 years ago
Can you post a screenshot of your code for the button including the UpdateStockPricing sub routine on the Stock Portfolio form?
Alex Hedley             
3 years ago
Which sub is not found
Usually if it's not found it's either not there, are you missing a global mod, or you have something speeellled wrong
William Dowler        
3 years ago

William Dowler        
3 years ago

William Dowler        
3 years ago
UpdateStockPricing referred to in Portfolio form is not found
Kevin Robertson             
3 years ago
You need to add this to your Stock Portfolio form.

Private Sub UpdateStockPricing()

    DoCmd.OpenForm "StockUpdaterF"
    DoCmd.Close acForm, Me.Name, acSaveYes

End Sub
William Dowler        
3 years ago
Got it Kevin..... thanks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Stock Portfolio.
 

 
 
 

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

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

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/15/2024 4:40:19 PM. PLT: 1s