Hello.  Is there a way that I can put a username and password in VBA code to
authenticate to a SQL database and have the connection persist throughout the
entire time Access is open?  I am using Access 2003.  Thank you.

I need to build an import form.  I have 2 list boxes, first called lstSource
with the values of columns headers from an excel file (the excel file is not
always have same column headers) and lstDestination with values of fieldname
of a fixed table name.  

I am searching for an efficient way to kick-off my Access databases in the
morning prior to people getting into the office. My macros are written but
they require physical intervention to start them. I need VBA code that will
run my macros at a predetermined time each morning. ...

Unfortunately my VBA help is hosed and I have another newsgroup posting for
that so until I can do some of my own help...
I'm using Access 2000 & FP 2000 and have created a web site that contains a
subset of the tables in the local Access DB. The web site DB is a read only

I have a newsletter subscribe form on our website.  I would like to have the
data
(name, email address, city, state etc) recorded in my subscribe table in
Access.  Additionally, I want to have the same data recorded to other

I would like to know if Access2000 has any built in FTP commands?  
if yes please point me to a sample program.
I find myself in need to ftp a file and I would like to automate it.
Thanks

I created this OnClick code for a command button to pass an argument to the
form I'm opening.  The problem is that for some reason when the form open
procedure on the other form runs the field Me.RawInputID shows that it is a
Null value.  I placed a breakpoint before the End If ...

Hi there, i am currently in the process of testing/building a new contact
management system based on access forms - i have an email form that users
fill in and then click on an email button to send the contents of the form to
the required contact automatically via access.  ...

I have a query that I need to run each month.  Before I run it, I need to
manually switch last months table to the new months table.  Each month a new
table is imported to the database for the month (we would like to keep each
month in a separate table for now) and I need to switch ...

I have a contact table with multiple fields (ie, Name, address, city,
phone)...I would like to be able to type data in one search field and have
the search look in each of the above mentioned fields for the data and then
return the possible matches in a continuous form or list ...

Hi all,
Is there a  way to show all table field names in a list box in a form?
Thanks

I'am quite new to programming and Im having problem in transfering all the
data in Access Form and Sub-Form to the same Word Application.
It always occur  that the main form and the sub form has its own VBE, i
wonder how to connect the data from a subform to the programming (VBE) ...

Greetings Gurus!
I have some code that pulls data from a table dumps it into an Excel
Spreadsheet, adds sub-totals and then does some formatting, saves the file
and gets out.

I have a report in Access 2003 with a two groupings.  In the detail section
of the report, I have a wide text box (name is Text0) that is not bound.  On
the "On Format" procedure of the detail section, I have the following code:
Set db = CurrentDb

I have a combo box with different company names.  I would like all the fields
in my form to populate with the selected company's information.  Example if
company a is selected, display its contact name in the contact field, email
address, address so on and so for.