Run Query on successful login

[mattcarson88]

Hi Gurus,

I have created my own login forms using VBA Language, however I now want a query (Query A) to automatically run, to update data from a linked table (Table A) to a table that is editable (Table B). Does anyone know a nice simple way to do this?

Thanks in advance,

MC

 

[pr2-eugin]

Hello mattcarson88, Welcome to AWF..

First create the Query using the Query builder give it a name and save it.. Then in the code where you authenticate for a user, just add one more line of code to open the Query..

DoCmd.OpenQuery "queryName"

 

[mattcarson88]

Has it been that simple?

So just to double check adding the mentioned code will,

Upon the correct password being entered, and the user clicks a "login" button, the query will run, updating the data from a linked table to a table the user can store data to?

Cheers, thanks for the quick response

 

[xPaul]

If that's what you have told your query to do then yes.

 

[gemma-the-husky]

what happens to the "new" table when the user closes access? The next time he logs in, will it not overwrite what he last did?