Forms Question

[Guest]

My database is used for “importing†Excel reports, then running the “Find
Duplicate Query Wizardâ€. I need to build a form that will allow users to
import the table, then run the Dups query. Is this possible?

 

[Guest]

Hi tmaxwell,

The import part can be fully automated, see import data in help, the wizard
for creating a find duplicates query cannot be used within a form, but if you
are commonly importing the same data structure, ie column names, you can
create find duplicate queries, and then run them via code in the form,
depends on how many tables, and how easily identifyable they are.

hope that helps,

TonyT..

 

[Guest]

I have the query for the Find Duplication written. I just want to put a
button on the form page that will allow users to click and find the Excel
spreadsheet that will be used to create the table. I looked and it really did
not tell me much as to how to put it on the form page. Thanks