I am trying to use the TransferSpreadsheet method of the DoCmd object to
import the worksheet that a user currently has open, so that as he/she tabs
from one sheet to the next it is possible to bring in  whatever sheet they
are currently on (all have the same layout, are just for ...

I am trying to validate odometer entries on a subform(frmTripDetails) based
on the truck # on the main form(frmTrips).  I created a query which returns
the correct result.  I used this query to define a variable with which to
compare the present entry to in the before update ...

The following code worked fine when the form had a text box, but when I
changed it to a combo box, it now does not return any records.  What did I
miss?
-------

I want to create a macro (MsgBox) that says
[forms]![part a]![datefiled1],[forms]![part a]![datefiled2],[forms]![part
a]![datefiled3],[forms]![part a]![datefiled4]>[forms]![part a]![due date]
But I get a message that says "cannot parse the expression", I tried "or"

I have a data entry form that I'd like to mask the SSN like the password mask
with asterisks, all but the last 4.  So, it would look like this: ***-**-0456
Does anyone know how to do this?
Thanks,

I am deleting a record from a subform in continuous forms view. There can be
over 100 records displayed in the subform.
I want to preserve the location of the record being deleted so that the user
is not automatically repositioned at the top of the recordset after deletion

I have a data entry form.  I need to add a browse button where the user can
browse the network for their attachment and then attach the file name to the
form.  Like the yahoo attach file types where you click browse and the name
and path auto populate the text field. That's the ...

I would like to put code in an on current event that doesn't run when the
event is triggered because the record is being deleted.  Is there a way that
I can look at what the user did to trigger the on current event?  I'd be
happy with some general suggestions and key terms that I ...

Hello Programmers,
I have a subform that's bound to a table that has data in it. The subforms
Link Master/Link Child fields are hooked into the main form which is empty.
Although the table the subform is linked to has data in it, the data does not

MS Access 2K, Windows XP
====================
Hello there,
I have a form where I specify criteria to display records. The records are

I have a complex search menu with many criteria organized into groups with
the tab control (an unbound form).  The button to execute the search via
stored procedure is outside the tab control.  I want to check for errors on
one tab page before going to a new tab, so I put code in ...

I starting writing what was a small database back in 2000.  It has now grown
to be what I consider quite large and I spend almost all my time modifying
something or adding features.  While I have a working copy and a production
copy, it invariably becomes necessary to update the ...

Problem I have a typical database with entries to the name field
(Last, First. Middle, Suffix) and I need to automatically updat
another field, Name, with the information How can I do this? I’v
tried the Event Builder using =[Last] & ", " & [First] &

I have two problems.  
First, I want to put a vbYesNoCancel box up when folks try exiting (save
changes, abandon changes or return to form).  The problem is when I put the
code in at the Form BeforeUpdate level, the Form BeforeUpdate has priority

When a student has alraedy taken a portion of their test I want to close a
form immediately.  
Each portion of the test calls a different form.  The questions come up in a
list box.  When the student exits the list box, if the student has already