sorry, not a query.... a function or sub (VBA) that performs a copy from one location to another overwriting a file with the same name, without confirmation. Thanks....
I need a query that automatically (without confirmation) copies FileA to a location where FileA already exists automatically overwriting the file that is there and without making a backup of it.
Thanks MajP that worked great. Now I need to know how to do on a more general basis, where the list of items is just the results of a basic selection query and not in a combo box. I am sorry, but I am new to VBA.
I know how to disable the msgbox confirmation...not worried about that. It is how to automate submitting the combo box items individually to an update query....
Hi, I have a list of items based on a query and that list is in a combo box. I currently have to select each item in the list and submit it to the update query for processing.
I need to know how to do this programatically.
Something like
Start loop
read item in combo box (query result)...
I have a combo box filled with the results of a simple selection query. Right now I highlight the selection and then send it to an update query. Everything works fine, but I need a method to process each option automatically but individually (one at a time) and send it to the update query so I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.