RE: Can you script preset values for forms?

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.
--
Dave Hargis, Microsoft Access MVP


"Eric" wrote:

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.
.

Relevant Pages

  • Re: Can you script preset values for forms?
    ... 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 ...
    (microsoft.public.access.forms)
  • RE: Can you script preset values for forms?
    ... Sorry - this program has an MDE file associated with it and the VBA Code is ... login screen that requires a few pieces of information (SQL Server Name, ... number, SQL Database name, ID and Password) in addition to the Database User ...
    (microsoft.public.access.forms)
  • Re: Total Newbie - Maintainenance of SQL Database
    ... If you are having a consultancy migrate/install this packaged solution then ... > exactly is involved in maintaining/supporting a SQL database? ... > intend to run on SQL server. ... > The only maintenance I do on the Access version is a scheduled nightly ...
    (comp.databases.ms-sqlserver)
  • RE: Event 3760 Error
    ... SQL Database 'STS_TSMAIL_1' on SQL Server instance ... Microsoft CSS Online Newsgroup Support ... <Source: Windows SharePoint Services 3 ... <SQL Database 'STS_TSMAIL_1' on SQL Server instance ...
    (microsoft.public.windows.server.sbs)
  • Re: Questions on a Database with Mass Data
    ... SQL server, how much involvement would I expect from our IT department? ... SQL Server 2005 learning resources (free online videos) ... FE to each BE and let a query to grab the specific data from a specific year ... I also heard that SQL database can handle the massive data. ...
    (microsoft.public.access.modulesdaovba)