Sean,
I have a somewhat related question: How do I export a query to an open Excel or CSV file? I have many users that I want to have access to queries I've built and I'd like them to have their results generated in Excel or CSV (preferable Excel) because they're not very comfortable with...
AccessGuruCarl,
I added that code to one of my tables and it worked great for one of my needs, but it exported the whole database ("TRIAGE_LOG") that I specified. Can you please help me:
1) Only export the query I am running ("Data Integrity - No Reas From Level")
2) Export to an open Excel...
MoLaker,
Sorry about that. I'm not sure what the difference is between bound and unbound forms. The form input is meant for new data, though, if that helps. It's strictly new input. Users are not updating existing records.
More about the form:
TYPE is a combo box that selects from a short list...
MoLaker, thanks for the suggestion. I couldn't get that to work, though. Maybe part of the problem is that the "TYPE" input field comes first and the "REAS FROM" and "REAS FROM (CS ID#)" input fields come after.
Is there anything I can do to add some sort of validation rule when the user clicks...
I have an Access 2002 database with data integrity problems. There are 3 types of files I'm tracking:
"TYPE" = NEW, REOP, or REAS
My "REAS FROM" and "REAS FROM (CS ID#)" fields can be blank if the "TYPE" is NEW or REOP, but I need data to be required if the "TYPE" is REAS.
I'm not good at all...
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.