I have forms with large memo fields and when they open the memo field is
always highlighted.
How do I tell Access to open a form with no focus on any field?
Thx

In the VB code for a Command Button I want to execute two SQL commands on the
database.  The first one is an insert and runs just fine.  However, the
second one is an update and is not working.  Do I need to declare another
variable for the second SQL command?  See below:

How do you abort inserting a new record in an Access form?  The form is a
simple form created by Access Wizard.  A user may want to abort the insert
while typing the new record.  I created a command button and did not have any
lucks with the VBA codes to abort the new-record ...

I have it so the mouse move makes a label do what I want but my question
centers around the mouse pointer.  When it goes over the label I would like
to have the arrow change to the finger style.  Much like what it does in the
news group listing here.  Is this able to be done?  If ...

Below is what I'm trying to do.  I want to point to a certain control on a
form programatically.  I know the code below is crap but it will give you a
good idea of what I'm trying to do.  cnt will be a counter (1-20) that will
tell the code which control's back color to change.

The db I am trying to work on is for a small clinical study. My knowledge of
using VBA is nil to non-existent. I am trying to learn as I go. So, pls bear
with me.  I have posted this on the access.forms forum also.
As I see it there are multiple issues I am dealing with:

I have tried numerous times and ways to do a dlookup within a subform.  It
just doesn't work. I'm getting an error "you cancelled the previous
operation".  All I want to do is show a staff's 'Section' then I select the
name from a combo box in the subform.  Here is my syntax

I'm having trouble using FindRecord in a bound Combo box. When i use it the
employee names get overwritten.
For examle, if "Sharon" is the current record and I select "James" from the
Combo box "James" becomes the current record, but the "Sharon" name is

Server = SQL Server 2000 SP3a
Access = 2000 SP4
I am trying to use application.setoption as it is stated in the Access help
file, even to the extent of copying the text into my .adp

Good afternoon all.
I have a screen that has several subforms and a lot of fields doing queries
at startup (around 107 or so).  It takes about 1.5 minutes to complete and I
would like to display a custom form that states what is taking place and it

I'm having trouble understanding how to create custom menus.    I want to
create my own drop-down menu items instead of the standard one's in Access.
Does anyone have info on this?
Thanks,

Is it possible to find a record that's split between two tables?
I want to find employees that are selected from a Combo Box using
"Employees_ID" as criterior and make that record the current record.
The two tables are "EmployeeCourseJoin" and "Main".

I have several dealers submitting warranty claims.  I would like to set up
security so that there are ID's for each dealer and an ID that allows them to
enter claims.  While logged on as the ID that allows them to enter claims, I
don't want to allow them to view any other records.  ...

In the VB section I find this combination constantly but have not been able
to find it in the documentation so I can use it properly.

I want to creat a one page exe. in Visual Basic to open Access from.
Can I do this?  Are there any done sides?  I have a software key that I
wnat to put on my Access application so that it cannot be used without
the key.  I need to do this with VB, or do I.  Any ideas or opinions ...