Can you script preset values for forms?

[Eric]

I have a Third Party software that is based on Access 2003. They have a
login screen that requires a few pieces of information (SQL Server Name, Port
number, SQL Database name, ID and Password) in addition to the Database User
Name and Password.

Depending on which office I'm in, there is a different SQL Server I will
need to connect to.

What would be the easiest way to PREPOPULATE the infomation for the specific
office so that a user only needs to click on an Icon?

I know how to connect the approprieate drive via scripting, just unsure how
to get the info populated.

I'd ask the vendor - but they tend to be unresponsive at times.

Thanks.

 

[Klatuu]

Assuming the app is not an mde or ade and you have access to the source VBA
code, you can use the Load event of the form to populate the text boxes on
the form.

 

[Dirk Goldgar]

I have a Third Party software that is based on Access 2003. They have a
login screen that requires a few pieces of information (SQL Server Name,
Port
number, SQL Database name, ID and Password) in addition to the Database
User
Name and Password.

Depending on which office I'm in, there is a different SQL Server I will
need to connect to.

What would be the easiest way to PREPOPULATE the infomation for the
specific
office so that a user only needs to click on an Icon?

I know how to connect the approprieate drive via scripting, just unsure
how
to get the info populated.

I'd ask the vendor - but they tend to be unresponsive at times.

If you are able to modiufy the design of the tables and forms -- not at all
a sure thing with third-party software -- you could create a table to store
this information, and set the Default Value properties of various controls
on the form to DLookup expressions that extract the data from that table.
If you need to save modified info, you can use the "Login" button's click
event to to update the table with the accepted values.

 

[Eric]

Sorry - this program has an MDE file associated with it and the VBA Code is
not available nor are forms. So I'm at a lost as to what I might be looking
for.

 

[Klatuu]

Then there is nothing you can do.