On a continuous form:  Is there a way to capture the field name of a
particular record when the user selects one of the field values on the
continuous form?
thanks

I want to open a second access 97 db using a comand button in my first access
db. Please help?

Hi I am trying to do what the subject line states over an internal network.
I am using Access 2002 and from the form command button I have created using
the mini wizard the VB code ends up like so (with
some subsituted path names):

Hi, guys - Rather simple but baffling question I have here...
I have a booking form for an accomodation database. I want the user to be able
to select the bed number they wish to book a customer into, bearing in mind,
rooms can contain any number of beds between 1 and 8.

All,
I was hoping someone would be able to help me with null values on strings and dates being passed into a Module.
I know that I can test on a field for a null value using IIf([Field]<>"",getFullName([Field]),"") however I'm having difficulty figuring out how to match the IIF() ...

In the following code, a table is populated with times and dates relating to
a particular employee. What I then want to do is populate 2 variables (one
with the 1st date and one with the last):
'Append the data relating to this user

Does anyone know if there is any way of importing an Exel file which has a
protected worksheet without knowing the password or at least being able to
copy and paste from it without knowing the password?  All I want to do is be
able to the read the data from the protected ...

The query:
SELECT *
FROM tblCapitalAssets
WHERE Asset Like "C-*"

I have written a database App using Access XP and everything is working OK
except for one section where I have some code that will not run on machines
with Access 2000, but works fine with XP / 2003.
The code is executed by clicking a button on a form. All I get with 2000 is

Have a form with a subform containing a combo box. If the value entered is
not in the table behind the combo box the user is prompted to enter new
values. If Yes then a new form is opened and the new values are entered into
the table via the form. When the form is closed and you ...

I'm still new to VBA and trying to write a simple function to derive gender
from title, like this:
Public Sub test_ifthenelse()
Dim title, gend As String

Greetings All,
I have found several questions in this forum that almost answer my question,
but…
I have a subform set up as a continuous form.  There is not a direct

I have thousands of ranges of documents that I need to determine all of the
individual numbers within the ranges.  In Access is there a sql statement
that I can use.

Good day,
How do I delete all the records in a table without deleting the table itself
via Macro.
Thanks in advance

I've developed a database in MSAccess that, after some data manipulation,
emails staff (with an Excel attachment). During testing, I set the 'edit
message' to TRUE. However, when I change it to FALSE so that the emails (can
vary between 70 and 130) would automatically send, Lotus ...