Search results

Hi David, Thanks for the general guideline, this will help me a lot!!! Just one little question (only need to answer if so): is there a special way to create a 'wizard style' form or is it just a series of independent forms called after one another (formStep1 calls formStep2 after actions are...

I shall try to clarify further. The MS Access source and destination databases are only intermediary databases: (italic is beyond my control, bold is what I need to do) ERP system --(magic)-> source.mdb --(my logic)-> destination.mdb --(existing conversion tool)-> analysis tool I'm working (as...

Thanks David and Mike! I forgot to mention that the source data is a snapshot (a certain month for instance). This data needs to be converted to a special MS Access database structure to be read by an external application for off-line analysis. This analysis is only performed on an incidental...

Hi David, First of all, thanks for your reply. The source database is a selection of tables and fields from an application and we need to transform this data to another structure for use in an analysis tool. So, in essence, we will be selecting data from the source database, maybe convert it...

Hi all, First of all, I'm a newbie at programming in MS Access and VB but can and want to learn. I want to write a (possibly MS Access) program that takes one (external) MS Access database, checks if the needed tables/fields are present and then converts it to another (external) MS Access...