I would like to finish a module by open another database (that I just copied
some tables and reports into) then closing the current database, leaving the
second (target) database open, mainly since I will need to run procedures
from the target database.  Is this possible?  Here ...

I'm trying to set the OnClick property for a certain button on my form which
will prompt the activation of several other control buttons and hyperlinks.  
I've tried the following code with two of the command buttons so far, but the
SendKey method will only work within the first ...

How do I get the default to be "No" on this Message Box with Yes and No
Options?
Dim Response As Integer
' Displays a message box with the yes and no options.

Good afternoon,
I have a function that I'm calling in a query's calculated field.  The
function is:
why(changed, e1, e2).

My question is, I have setup a query to build a report. In the query I have a
date, which I would like to select a range. 'Between x and y dates'  In the
query x = 'startdate' and y = 'enddate'. I have a report selector Form. The
report needs three inputs 1. is a name, 2. is ...

I got the piece about controlling Excel from Access.
I was recording a macro to see how a text can be converted to a number via
that little exclamation mark in Excel 2003 so something like '1 can be
converted to 1, but when I recorded the macro, it didn't show the code for

Hello,  my multi-select list box that has 2 columns, called Ex_Code and
Auth_Ex.  I am trying to append the selected items in the list box to a table
called "Update Tbl".  I know how to read the first column by using
Me.lstAuth_Ex.ItemData(iCount), but I don't know how to read ...

I want to check my text box in the subform. If  it has a null value, then i
want to run a query. But i can not check the text box. Because i use main
form's VB module. So i can not access the text box. What should i do?

HI,
I have a report in an Access 2003 database that I need to print as a PDF. I
am using Acrobat Professional 7. What I have so far does most of it fairly
well.

MS Access 2003
Here's my scenario:
Form --> frm_report
In that form:  3 cbo boxes, 2 buttons, 12 txt fields.

I have a dilemma.  I have an Access report that I can easily save as a .snp
file then attach to an email.  It's great because the file is "secure", i.e.
uneditable.  Ideally, I would like to be able to  attach a Word .doc to the
email as well; preferably as a .snp file also (and ...

Currently, Using Windows Explorer I copy BE which is in the server to
another folder for our backup, in case any crash, we still have the data.
My question is how can we have the automatic backup, let's say every 6 pm,
it will automatcaly copy and the name of the file is ...

I have one user (out of maybe 20) and when ever access tries to run a certain
code, it throws an error.  It happens in several different forms, and ONLY on
this one machine.  The code is:
Dim rs As Object

Hello, I am using the function InputBox to limit the use of a VBA procedure.
I would like the typed in password only to display the * for each character
as happens with Microsoft generated password requests.
Thank you.

I'm very lost and confused to the suggestions that have been offered to me.
Let me try this one more time.
1.)The code below gets data from other databases.
2.)I have StoreIPAddress string to connect to different database locations