Michael Noze
asked on
Add checkboxes to query
Hi Experts,
I'm looking for a way to add a checkboxes column to a query and it would be used in a form.
My data come from a linked Excel file.
Is there a way to do it?
Thank you.
Database2.accdb
DataSAP.xlsx
I'm looking for a way to add a checkboxes column to a query and it would be used in a form.
My data come from a linked Excel file.
Is there a way to do it?
Thank you.
Database2.accdb
DataSAP.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can clear the temp table before any appending operation
ASKER
I just have an issue with your solution, how can I update the temp table in Access without adding existing data into it with an updated Excel?
What I've done is I linked my Excel file, added and removed some data in it and I ran the append query.
It added to the existing temp table all the new data.
Michael