By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Export Updated Records (only) to Excel

P: 1
I have a split form. The datasheet displays several records. There is one field that needs updating "FUNCTION_SELECT". Once the user updates this field. I want a button that will export only the update records.

I am not familiar with VBA. I hope it is possible to perform this action with a Macro; and a few conditons.
Dec 2 '13 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
sherlc29:
We can’t' actually do the project for you nor could we even if we wanted to from the very general information you've provided.
The steps involved would be to have the on current event note the current record.
Then, potentially, the before and after update events would need to be called to determine if the change(s) were actually made.
Once all this is done, your button could be made available. Depending on a dozen different things would determine how the code would be written as you note Excel in your title, there will need to be a query written that handles part of this transaction.

So, as you can see, simply not enough detail provided.

You might find the following links to be helpful as to learning the fundamentals behind the DB and VBA that run Access.
MS Access 2010 Tutorials
Access Basics - By Crystal
> Database Normalization and Table Structures.
---
Dec 2 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.