huperekchuno
New member
- Local time
- Today, 12:08
- Joined
- Feb 8, 2007
- Messages
- 1
Taking a hyperthetical situation, that nevertheless leans heavily on an actual task at hand,
Say company A, sends company B a database, where records are flagged if the original data could not be entered due to lack of clarity, or just not available. say your job, as an employee of Company B, is to find the master copies of the hard data that Company A had problems with, and then correct the database record.
No hard task so far?
However you have ALSO got to reflect, in the most visual way possible (taking into account that Company A seems to have some language barriers), the changes that have been made, preferably highlighting the changes in each particular field by changing the font to red.
To my knowledge, this is not possible in Access alone, my solution so far is to export the database to excel after making changes, and then highlighting those changes. Naturally this is tiresome and, I think with a little ingenuity, unneccessary. Furthermore, I don't want to export to excel and just edit records there, because of the advantages that are offered by Access (such as linking tables to a particular field, and then using autocomplete - which is a real time saver for large database finetooth combing).
My question: Is a macro the best way forward, and do you have any pointers, as to the best approach? I'm no VB genius, but I understand most programming concepts, just not all the language and syntax that VB uses.
My thought so far, is to use the macro, to record changes made, export the database to an excel file, use the macro to open this file, and automatically highlight the relevant changes. I think that using relative cell referencing may be the best option excel wise, but how to record the changes in Access? Or, is there a better way?
Any input on this would be greatly appreciated fellas!
----Edit----
Another point, recording changes would meant he macro would have to run passively, like a service, is this possible? Am I just barking up the wrong tree here?
Say company A, sends company B a database, where records are flagged if the original data could not be entered due to lack of clarity, or just not available. say your job, as an employee of Company B, is to find the master copies of the hard data that Company A had problems with, and then correct the database record.
No hard task so far?
However you have ALSO got to reflect, in the most visual way possible (taking into account that Company A seems to have some language barriers), the changes that have been made, preferably highlighting the changes in each particular field by changing the font to red.
To my knowledge, this is not possible in Access alone, my solution so far is to export the database to excel after making changes, and then highlighting those changes. Naturally this is tiresome and, I think with a little ingenuity, unneccessary. Furthermore, I don't want to export to excel and just edit records there, because of the advantages that are offered by Access (such as linking tables to a particular field, and then using autocomplete - which is a real time saver for large database finetooth combing).
My question: Is a macro the best way forward, and do you have any pointers, as to the best approach? I'm no VB genius, but I understand most programming concepts, just not all the language and syntax that VB uses.
My thought so far, is to use the macro, to record changes made, export the database to an excel file, use the macro to open this file, and automatically highlight the relevant changes. I think that using relative cell referencing may be the best option excel wise, but how to record the changes in Access? Or, is there a better way?
Any input on this would be greatly appreciated fellas!
----Edit----
Another point, recording changes would meant he macro would have to run passively, like a service, is this possible? Am I just barking up the wrong tree here?
