my problems is that if the subform dont have any record the system return
with a MICROSOFT OFFICE ACCESS MESSAGE - "NO CURRENT REORD"
CLICK "OK"
however the system does not delete the record in the mainform.  Can anyone

Hello.  I am having a weird problem.  I am trying to have 4 fields sta
the same as I have much data to be entered that will have these
things in common.  This is the code i'm using:
Forms!frmInputTreatyInfo!Company.DefaultValue

I have a text box with the following Control source IIF function. It returns
data such as: record 1500 of 2289; 1501 of 2289; etc.
I would like the numbers to have commas separate thousands. For example, I
would like the return to be 1,500 of 2,228; 1,501 of 2,228, etc. Any

I have a form in which I would like to have a button that will open the
standard Windows Calculator. I know the path on my machine running Windows
2000, but isn't the Calculator  EXE file located in different directories
depending on which operating system you are running?  

Hi to all,
I have written a small function to change/update the image control on all of
my forms
  For Each frm In Forms

I've got a form with a button and I want the button to get disabled if
pressed for this record. So far, so good. But I then want it enabled
again for the next record! And the same goes there: if button pressed
then disable it for THIS record, then when going to the NEXT record ...

I finally figured the cause of hampering problem -- which is most of the
battle, but I can't seem to fix it.  The initial problem was a "can't save
record" error despite that data was loading to forms and writing to tables
properly.

How can I extract the values to a table that were selected in the
Listbox.

The following code works as long as I do NOT include the option
"dbFailOnError" it gives be "Variable not Defined"
Any ideas?
I want the option just to cover myself in the event of an error.

I need to make an "employee tracker" style form where a user can select
a week ending date and then view the tracker for that week.
The data is stored in a table with the following fields:
ID

Hi!  I'm trying to calculate a contract's effective end date based on the
following provided data:
1) contract's effective starting date (i.e. 10/1/2004),
2) term of the contract (in months)

Hello to all,
I have a ListBox that's setup to save selected items to a table when a
button is clicked. It works fine, but the items stay selected after the data
has been saved.

Is there a way to test if there is a current record of if the table is
empty?  I am using the following code behind an OnClick event to delete a
record in a table.
If Not Me.NewRecord Then

I made a form that asks the user to choose from a list box a criterion. The
form then opens a report with a specific filter. In my report, I have an
unbound text box and I want its control source (a date field from a table) to
automatically change, depending of the filter. (I ...

I need to use the Where Condition  argument on the Docmd.Openform  so I can
reduce to 1 entry forms in my db by applying conditions on the form instead
of having multiple same form with different query as RecordSource
I use the following: