My Access 97 application contains a main from with tabbed UI display.
One of the display contains a button to bring a Modal Form (Dialog) for user
inputs.  
Is it a good practice to configure such form as Modal, so that, the user

Any idea why this results in NULL:
   If [CALLED_ON] = Null Then
     [COMMENT] = Date
   End If

Hello!  I know this should be easy, but I've gone through many iterations.
I'm trying to say that if  ArtistDonor  is Artist (=1), then enable
Commissions and default Commissions to "yes".
Private Sub Form_Current()

I am running access 2003.  I have a split database and I am using multiple
data files (back ends).  I have recently found that some of my tables have
become corrupted in all of the data files.  I believe the cause was the
recent conversion of the primary keys of these tables.  We ...

i have a nested subform (in ds view) called 'DaysView' sitting in my main
form called 'Screening Log (Edit Only)'. the linking via Parent/Child fields
is a little convoluted and may or may not bear upon the solution we can
conjure up (and ftb i'll defer going into them); suffice ...

I created a command button to open a mail merge document in a backup copy of
my database with code
DoCmd.GoToRecord , , acNext
Dim oApp As Object

I want my users to be able to enter the current date (and time if possible)
with a shortcut key combination.....say(shift+N) and then they can type in
their entry.  Is this possible?
Thanks,

Is it possible to call a function/sub by name as a string. I want to be able
to pass the name of a public function to another subroutine, who will then
call that arbitrary function for me. Is this possible in Access97?
Jonathan Scott

I'm getting this message "unknown message recipient(s); the message was not
sent" when I select certain names in the drop down list but It works when I
pick other names (like my name or my boss name).  How does Docmd.Sendobject  
validate or get the the email address if the value ...

I have a form where users enter account numbers, customer names and type of
account.  In some instances, users are not required to enter type of account.
I want the form to check if type of account is required.  I have the
following code on the On Exit:

I have an Access 97 database (soon to be converted to 2000).  I would like
to create a login form that can authenticate the user's network password so
they don't have to have yet another password to log into something.  I have
read a lot of postings but haven't seen anything I ...

I've a form with some toggle buttons on it. the buttons are enabled or
disabled depending on the previous form's combobox values.
the problem is that one button gives me an error, where i could not set
the enabled-property to false. All the other buttons work.

Good Day!
I am having problem with sum() function, yes, i said the sum() function.  I
have small form that lists info based on criteria, and displayed on a
continous form, and then those numbers are totaled at bottom.  I have four

I'm struggling with some strange behavior by Access 2003:
I have a Form_Resize event procedure that calls the sub ResizeControls.  The
ResizeControls sub (obviously) resizes several controls on the form to fit
the new form size.  I maximize this form on open, so the code should ...

I have 4 fields on a subform - QtyYear, QtyAmount, QtyDate & QtyLoc. If
QtyYear is not equal to the current year then I need locked set to Yes for
all 4 fields. If it is equal then I need it left as No. I only want the user
to be able to enter/change this years data.