Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VB project
|
|
|
The UK's most regular 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. |
VB project
Resolved · High Priority · Version 2010
Reply 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
For upcoming training course dates see: Pricing & availability
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
|