I have a subform which I allow adding of records. The recordsource of the
subform is a joined query, where one of the tables has a unique constraint on
it. This relation is one-to-many.
When I add a record, part of which violates the constraint, I get an error.

I am looking for code to put into a button's click event that will check to
see if a specific report is open and, if it is, close it.
Many thanx,
Rip

I need to create a form that accept data entry in the following fashion:
Start    End    Duration
00:00    00:45    0.75
00:45    01:30    0.75

I have a "Main Form" (not switchboard) that would have contact information
and would like to have a subform below. What I would like is some hyperlinks
that would change the subform. Clicking on the different links would change
and replace the subform. So I would have numerous ...

I realize this sounds like it should be posted in the Report section but I am
posting it here because I suspect the answer will involve coding or modifying
my forms. I have multiple tables with bound data input forms for my law
office db. One of the items recorded is due dates for ...

i have this code in before update of the form. but if i make changes to
patient name , and confirm the changes , i will get error in the code
Private Sub patient_BeforeUpdate(Cancel As Integer)
   If Not Me.NewRecord Then

On a data entry form I have suddenly developed an error on entering the
surname:
“Function: ProperLookup - Error#: 3219: Invalid operation”
When I click ‘OK’ I get another error:  “Run-time error ‘3315’: Field

How can I set the value of a field in a continuous subform for just the
current record, and not all of them??

Hi...
I have created two drop down lists in my form... they are both displaying
data from a database(company,branches)...
I want when selecting a data from the first one (company), it must display

Access97
Is it possible to use something like the "DoCmd.DeleteObject acTable
etc" to delete a table link using a wildcard?
We create temporary tables, for example by week numbers, and need to

I have a text form control whose values contain mathematical
expressions.  For example, the control might contain the string value
"2*4+6".  Is there an easy way to evaluate this value mathematically
and display the result (e.g., "14") in another form control?

I’m using a combo box on my main form to pick a company name.  Once that name
is selected my subform is populated with fields from my checklist table.
My Problem: I’m trying to populate the subform with the joborder number from
the main form, but I’m getting an error.

Newbie question.  I always thought a record was pretty much saved as soon as
it lost focus.  After reading though these newsgroups I'm noticing people
using a save record command.  What is the purpose?  When should this be done?
I've been using my db for years without any such ...

How would you go about displaying a list of forms, some with textboxes, and
some with dropdowns, depending on a boolean in the recordset?  Is it
possible to hook into the subform code to show your own continuous list of
forms and choose which form to use according to your code?

I have a form w/ a locked field.  This form is used to view existing data but
also to add new data.  If the user clicks the 'new' button, I would like the
'account' field's property to change from 'locked' to 'unlocked'.  How can I
do this?