Re: Can you script preset values for forms?

"Eric" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E072F866-80C5-4139-89A4-A5186C5A239F@xxxxxxxxxxxxxxxx
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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

.