Unsure if this can be done with a Query

[Guest]

I have a database which 26 different sites use, each site has it's own site
code. I have made a query that runs when you open up the form they enter data
in, it asks for them to enter their site code, this brings up all the
information in the database relating to their sitecode. I would like to have
their site code automatically entered into each entry they make when they
open the form, is it possible to have this value taken from the input made
into the query which asks for their site code?

I tried using a setvalue macro but I am not too clued on when it comes to
this.

Thankyou.

 

[Joseph Meehan]

I have a database which 26 different sites use, each site has it's
own site code. I have made a query that runs when you open up the
form they enter data in, it asks for them to enter their site code,
this brings up all the information in the database relating to their
sitecode. I would like to have their site code automatically entered
into each entry they make when they open the form, is it possible to
have this value taken from the input made into the query which asks
for their site code?

I tried using a setvalue macro but I am not too clued on when it
comes to this.

Thankyou.

The easy way is to split the database so there is one central database
(the back end) and each site\user had a own remote (front end) database
linked to the data in the back end. That way you can hard code that
information in the front end. You could even use a table in the front end
that contains their own data.

Other than that, you are going to need a way to identify what site is
accessing the data. User level security can do that, but it does have a
kind of steep learning curve.

 

[Guest]

Thankyou for your reply.

At the moment I have 26 individual forms which has the site code as a
default value. I am finding it time consuming to make changes as I have to
redo the form, and then copy that table 26 times, rename it and then insert
the default value again.

Maybe I should look at another way to run this database. Thankyou again for
your reply.