I need to run a piece of code automatically when the last user exits a
multi-user database. How could I do this? There is currently no table that
tracks logged on users.
Thanks.

using code to search for a string
however not sure what to do if it doesnt find it
eg.
[txtCustName].setfocus

Hello all, i have a question about vba and changing relationships between
tables in a back end database.
I defined a one-to-many relationship between two tables in the back end (i
think i should not have done that :-( ) and the back end is distributed to

This worked yesterday, I opened it this morning and now it
doesn't..... Is there a setting wrong?
Thanks in Advance
Private Sub Trophy_AfterUpdate()

I am trying to get a sub-form to refresh it's data whenever the main control
on the main frame changes its value.  There should be no updates to any
values on the main form.  All values in the sub-form except the FK are
candidates for updating.

Can you use DLookUp in SQL?
Test2SQL = "UPDATE table1 IN '" & strPath = DLookup("BackName",
"tblBackPath", "BackID=1") & "' " & _
"SET table1.IDName = '" & Forms!Form1!TxtInfo & "' " & _

I am using Access 2003 and have a form ( Form00 ) that is just plain old
blank.  On that form I have a subform ( Form99 ) that lists the required
information from a query.  What I really need to speed things up is about 10
filters.  What would be perfect would be 10 command ...

I have TableA and TableB
TableA has 3 fields where types of file extensions (for different
purpose) are supposed to be stored.
Table B has many extension type strings for these TableA three fields

Hello all. I am currently picking apart some code in a database to revise it,
and I am curious about something. The way the previous person wrote the html
code is odd to me, and was wondering if there was a purpose of writing the
code like this;

In Access 2003.
I have a form, and a subsiquent pop-up form. Here's the code on the
parent form (called directly from a command button click event):
Private Sub SizeWeightForm()

Is there a way of doing this without DLookUP or Me.TxtPath?
I have the Path stored in a table which I need to do incase I have to
swith paths.  This way I don't have to change all of my code.
Thanks

In the query result, I need to see (for example) a single digit number
(say that "7") as "007".
What is the function for this? I use FormatNumber function for other
purposes.

I can successfully check if a subform is loaded using
 If CurrentProject.AllForms.Item(ABCText).IsLoaded Then
however if the master form contains tabs and the subform is on a tab, the
previous check doesn't work. I'd like to test if the subform on the tab is

I have a form that is used to enter patient data. The first 4 text boxes are
ID (auto numbered), Last Name, First Name, and Date of Birth. I am trying to
figure out how to code the form to check for duplicates based on Last Name,
First Name and Date of Birth...and if there ...

I Want To Create a Report Based of a Query, That Automatically filters
out projects for that week, So i thought i could use the
"RecievedDate" Field.
Is it Easy to do, The Report will be printed every Friday Afternoon