I have this SQL code below. It takes 5 tables which for example are
1,2,3,4,5, 5 is subtable of 4, 4 of 3, 3 of 2, and 2 of 1. So when you
open table 1 up it can go to table 5. This code below takes those 5
tables and only finds the unique value in compared table. So lets say:

Howdy all.
Have a tab control w/6 tabs.
Desire to have a field in the last tab (Borrower Financial
Information) updated whenever any field gets updated in this tab only.

I've taken over a database with VBA that I'm only now learning.
I've disabled the navigation bar, but created a custom one to ensure the
Right Arrow no longer creates New Records. This workaround is successful when
navigation is record to record, but once the filters are applied, ...

I have a form with a field called "search" when I write on it, so I wiould
like to find code that make on change after refresh the cursor will be to the
left to continue writing.
Now when I write, with every key pressing it will be refresh and the

I have a search for with multiple check boxes when I open the form and select
one it works fine.  When I hit the clear button which works and select a new
checkbox it gives me the error?
When I hit debug it highlights:

I have some valiadation onFormClose.
I have warning message for the user to answer want to continue or not.
There is no cancel property onFormClose.
Are there any property to set to keep form open onFormClose?

I am not a skilled programmer, but I've been tasked with being the 'go
to' guy for Access DB development.
I have a DB that has a form that I use to enter business items and
personal information. This is to document a business process we use.

I am trying to program a Form with a Row Source linked to:
SELECT Sheet1.ID, Sheet1.PROD FROM Sheet1;
This does not crash Access, but if I change the Row Source to this:
Sheet1

Is there any way to have a memo field show the last line rather than the
first line as its default?  
I have a memo field into which I put data from an "add comments" field using
memofield = memofield & timestamp & textfield.  I would like the form to show

I have an app that it freeze every time when it gets error and I click on
debug.
It can continue if I click on End.
Are there any place I can look in to this?

I want to open a form, change some properties and disable some controls
depending on the situation and then wait until the form is closed to return a
value. If I use DoCmd.OpenForm ,,,acDialog the code stops and I'm not able to
change anything on the form until it is closed. If I ...

Tuesday, they did a microsoft upgrade, and my access file was corrupted. So
now I have go go back and recreate the queries that are the source for my
command buttons. The user can enter search criteria in text boxes, and the
command button will filter for only that data. For ...

This may be simple, but not sure how to do this in Access.
Used to do this in FoxPro years ago by putting an Ampersand in front of the
variable name, in order to have the value of the variable become the constant.
Here goes:

Here is hoping that someone out there can help me with this
question(s):
What I want to do is to take the following 2 rows in Excel:
005555               HAMADFIAR, ALI A234 S WINES STREET    FERNDEL,NY 10405

I would like to open a form to a specific record
When I press a button on the form I need the contents of the specific
record attached to an email.
thanks