98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VB project
VB project
Resolved · High Priority · Version 2010
Fri 17 Sep 2010, 09:54Delegate Kate said...
Kate has attended:
Access Introduction course
Access Intermediate course
VB project
Hi,
I'm running a macro which copies data into a spreasheet then uploads this data to access (refresh all) which then links back to other tables in the document.
The results of one of the tables are then copied across to a separate worksheet and these values are used within Sumifs.
Despite putting the copying at the end of all the procedures it still does this first, therefore copying the old table across.
How would you recommend avoiding this problem?
Thanks,
Kate
Thu 23 Sep 2010, 11:42Trainer Jacob said...
RE: VB project
Hello Kate
Thanks for your post and detail around the issues you are having with your spreadsheets and Access.
In these instances we will really need to look at your working files to establish if there is a solution. Any identified solution is beyond the scope of this forum and we will produce a scope of work with objectives, durations and related costs.
I shall email you directly should you wish to take this further.
Kind regards
Jacob
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
