VB project

Resolved · High Priority · Version 2010

Fri 17 Sep 2010, 09:54 Delegate 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:42 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips