I am in a multi user environmant, access 2003. I cnnot open the DB
exclusively to make any changes. I do the changes on weekends. Once in a
wahile someone leaves the DB open and my time is wasted. There is  a code
somewhere where the DB can automatically be closed if it remains ...

I have a form with 2 linked subforms.  One form is for data entry and the
other is datasheet view.
They are linked in the main form with
Private Sub Form_Load()

My main form has three places where people's names go.  All three use combo
boxes that utilize a Select query (written into the properties window)  to
pull information from a contacts table.  The query pulls first names, last
names, middle initials and contactID numbers.  It ...

All,
I'm having a devil of a time trying to figure out how to filter a record set based on a date. I've tried a few different variations of the following lines, but unfortunately, none seem to work.
                    .Filter = .Fields("tTransactionDate") >= DateAdd("d", -90, ...

I'm trying to figure out how to make all my forms open in the same window,
even if the user has
Tools>Options...>View (tab)>Windows in Taskbar (checkbox)
checked.  I'd prefer not to modify their settings, and just encapsulate my

I have a weird problem that has turned out to be very frustrating.  I have
an image control on a report that is set in the FORMAT event of the DETAIL
section.  I am running the report in the PRINT PREVIEW mode, where each page
is a different record.  The image file is set to a  ...

I am unable to pass a variable to a Query.  How do I pass a value,
programmatically, to a Parameter?
Public Sub ProvidePointer()
   Dim mydb As DAO.Database, qdf As DAO.QueryDef, strSQL As String, recv As

I have a query with two tables.  I want the query to return data from the
first table.  The second table holds a checkbox.  The two tables are linked
together by an AutoNumber.  If the AutoNumber has the checkbox selected in
the second table I do not want the data returned.  I only ...

I'm trying to parse the following text to pull out the course info, which is
to the right of "below:" within the text. We can say the text value is
assigned to a variable called CourseInfo. There is always at least 1 space
between "below:" and the begninning of the course info, ...

I have the following function which normally returns TRUE if a file exists:
Public Function FileExists(argFullName As String) As Boolean
'RETURNS TRUE IF THE FILE EXISTS
FileExists = Len(Dir(argFullName)) > 0

I'd like to display some pop up information to a user when the mouse "hovers"
over a text box.  I'd also like the information to disappear when the user
moves the mouse.  I haven't done this in access before.  I can imagine
something like a mouseover event with a timer.

I have a form with a subform (shown as a list) and I am trying to make a
button that takes the number in the active record in the subform and put it
in the textbox with the lowest number available. I have created 9 textboxes
where the first is named Module_entry and the rest is ...

I asked a question last week and i got no repsonses. I will reorganize my
question.
i would like to set a parameter of a query with VBA, so that i can run a
report of that recordset.

I am trying to call up a value from a subform and I have the following code:
Dim fld as String
Dim frm As Form
   Set frm = Forms![MyMainForm]![MySubForm]

In Office 2003:
Does anyone have a working VBA function that will ping another DB and return
TRUE if the DB has been opened exclusively; false if not?
If so, could you please post it? Thanks.