I was wondering if there was a way to setup a trigger on a MDB.  I know
you can with a ADP, but I can't seem to find that choice when you right
click on a table.

I have the following problem:
My clients need to have an autonumber Id, but they want to be able to
set the value to arbitrary numbers nonetheless. Thus, what they really
want is for the default value in the input form to be the next logical

Hope you are doing well.
I have code written that outputs a table and then opens the table that
was output, selects all records, and deletes the records.  The problem
is, if there are no records in the table, the code errors and stops.

My question is simple enough. How would I write the following IIF statement?
If field "A" is null and field "B" is not null then populate field "A" with
data from field "B" and then delete the contents of field "B".
I understand an update query would work as well although I would ...

I have a procedure that runs three queries, 2 update queries and 1 append
query. These queries need to be run before a report is produced from the
database. However it is possible that the user will edit records after the
procedure is run and this will mean that the procedure ...

Hi, what I am trying to do sounds quite simple though I am not sure how to do
it. Here is the scenario: If field "A" is null and field "B" is not null then
populate field "A" with data from field "B" and then delete the contents of
field "A".

I get the following error message when I open a particular form with
subforms"
The LinkMasterFields property setting has produced this error: 'User-defined
type not defined'

I need to update a field in a table based on information found in a
listbox on a form.  This in itself sounds easy.  However, it gets a
little complex.  Allow me to elaborate.
Table1 has fields ID, title, LicenseCount.  ID is the key

Hi..A little background.  I have taken a MIS course this semester and
leared quite a bit about Access compared to what I knew before the
class (nothing)...I am working on a Db for work now and have a
question.  I have a table called tblPriceGuide.  The fields are

How and what is the best way I can store a MS Word or maybe and Outlook
screen shot into my database.  I welcome and tips or website to visit.
Thank you in advance.

I really appreciate everyone's help.  This board has been extremely
helpful.  I have really learned a lot.
I have a form that has a list box that displays all the information in
a table.  Under the list box are fields that you can enter in

In my form I have a tab control showing 5 pages, but I only want the
contents of the 5th page showing only with a password. Another words I want
the 5th page contents not be visible the 5th page can be displayed.   Is
this possible, I only have a combo box and bound object ...

I track bass tournaments and I would like to start keeping a record in a db.
As it is now the scale that we use is in lbs and Oz. I need to put the weight
into the db as a whole number and tenths format. So the scale would show
10lbs 8oz and I would enter 10.5 Lbs.

I have setup a validation rule of Not "" but it still allows the form to be
saved even though the field has been left empty??
Any Suggestions?
Many Thanks

I am having difficulty checking to see if a certain column in a listbox
is null.  My code follows.
   If IsNull(Me!List5.Column(3)) Then
I have also tried