Best - is to use Append query - just make a new query, set type to append,
then define what and where you want to copy. You can run it from your form
using docmd.openquery
Is it because of the absence of the module that causes that problem? The
error message is "Compile error: User-defined type not defined." So, how can
i get this module? Thanks for all the hard work you've done.
The error message is "Compile error: User-defined type not defined." Can you
give me any suggestion because i haven't use access for a very long time, and
i forgot most of it. If it is possible, i want to avoid using DAO; because
the very last time i use access, which was seven years ago, the tutor only
teached me the very fundamental basics of access, even excluding vb. Please
help me and thanks in advance.
Thanks a bunch Alex for helping me out of this mess. Now the command button
is working perfectly. Thanks again for the good work!!!
Foo
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.