Conversion from PAL to VBA

[CJC Digital]

Recently a client of mine made the move to Microsoft Access from a DOS based
version of Corel Paradox -- and I've now inherited the task of converting the
legacy code into Microsoft Access Queries and Macros.

Right now I've gotten most of the work done... the system I'm building is
supposed to update mailing lists and customer records -- for example we'll
have a central database of records and as we build up clients in different
regions we'll sync the regions to the central database. If the customer
dosen't exist, we'll copy them in, and if they already are on file, we'll
update the information if there's changes.

Right now I've been using queries and SQL as I don't know VBA, but despite
my efforts, the product I've made never produces tables with the final result
as the original.

 

[Stefan Hoffmann]

hi,

Right now I've been using queries and SQL as I don't know VBA, but despite
my efforts, the product I've made never produces tables with the final result
as the original.

And your concrete problem is what?

Despite the fact that you have not entirely copied or mimicked the old
programs logic...

You must be more specific. Concise and complete examples will help a lot.

mfG
--> stefan <--