RE: Can you script preset values for forms?



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" wrote:

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?
    ... you can use the Load event of the form to populate the text boxes on ... 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: 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: ODBC Password
    ... Currently Using SQL Server 2000, ... just using the properties window of a pass-through query. ... exist in VBA code, nor do I know how to create it in VBA code. ... Will your suggestion work directly with the connection string ...
    (microsoft.public.access.modulesdaovba)
  • Transfering data between External SQL and MS Database - using VBA in EXCEL
    ... I have to loop through 150 + MS Acces databases to combine them into one ... I am using VBA Code to find and import each table. ... is only one table within each database that I need to obtain. ... If I input the data through the SQL Server ...
    (microsoft.public.access.externaldata)
  • Re: Change case of text in Outlook Contacts
    ... SQL Server doesn't come into it, Kim. ... Outlook can run VBA code in the ...
    (microsoft.public.access.externaldata)