Stupid question but....

[peskywinnets]

I've a third party app that can run a access query & use the corresponding data (a data export).

This app can only run one query .....but I really need those records to be marked as also having been exported, so now to the stupid question.....

Is it possible to configure a single access query or use a query in a way that will both provide the data 'selected' & update that same data (with for example say a 'yes' in a field called 'Exported)'.

Or will I need to go to the 3rd party app developer and ask for functionality to run an access macro instead? (which could then run a select query, followed be an update query)

P.S. not sure if it helps or hinders, but here's the 3rd party app's related info on how it can run an access query.....

http://blog.baystateconsulting.com/...uickbooks-using-transaction-pro-importer-5-0/

with their explanation of their command line parameters here...

http://bscdownload.com/downloads/Command_Line_Parameters.htm


EDIT....or thinking this through a little more, can I get access with a trigger to run a query to run *after* another specified query has run .....therefore the third party app calls the select query, then something within access 'monitors' this & then immediately kicks in with an update query autonomously?

 

[The_Doc_Man]

Triggers don't exist (that I know of) in an Access back-end. ORACLE or SQL Server? Maybe. Access? Nope.

The issue is that action queries return no data and select queries do not alter involved tables. So if you can't do a macro trigger, this won't fly. You CAN set up access to do something from the command line to execute a named macro. Look up "Access command line options" to see how. I think it is the /X:macro-name option. You launch Access with the name of the DB file and /X:macro, which is the only way I know to get a combined SELECT result and an update. Note also that if you do this as an external launch, the macro has to remember to exit from Access when done.

 

[pbaldy]

Off topic a bit, but triggers do sort of exist in later Access versions, in the form of data macros. That said, I don't see how one could be used in your situation. They are data related, and I don't think merely querying would trigger anything.

https://support.office.com/en-us/article/Create-a-data-macro-b1b94bca-4f17-47ad-a66d-f296ef834200

 

[MarkK]

Also a little off the topic, but I don't think it was a stupid question.

 

[peskywinnets]

Thanks guys

Also a little off the topic, but I don't think it was a stupid question.

Thanks! it might have been stupid if lots of folks had chimed in "Doh, are you for real? This is like Access day 1 type questioning" (I think I got away with it this time!)