I'd like a linecount in the lineitems subform of an invoice.
Also, if a line is added later, renumber....for example, if I want to add a
line after line three, I would like the added line to be line four and the
lines after it to be renumbered.

Here is what I am trying to do. I have a main form - with several subforms -
I have an add button that opens frm_addcustomerresearch. When I close it and
re-open the main form - I'd like it to go to the subform that I just came
from. (Each subform opens to the same add form.)

This is a general question regarding the comparing of 2 Access databases.  
There are several of us that are working on the same db (front end mainly)
and we are not in the same office.  What I am wondering is if anyone is aware
of any app or other means to determine differences ...

Is there away in a query to program dates to look at? i.e.
I would like to pull volumes per Month so I take the field that
contains volume figures and can I put these in the criteria below to
pull only that months volume?

I have a form that has a bound object connected to an OLE Object field in my
table.  When I right-click and choose Insert Object - Create from file and
choose the file the program locks up and I have to end the task.  I am
inserting a 56K jpg file.  If I go directly to the table ...

The ActiveX control uses the RTFField control as its source.
The RTFField control is bound to a field in a table.
All OK.
But I need to programatically load the value into the RTFField. When I do

I have a form that sets the default value of field [BomRev] to the value
on another form as follows:
=[Forms]![Main Form]![f_order].[Form]![BomRevMax]+1
This of course only works if there is already a record in the table to

I want to allow the user to use a combobox to select one field to view from
the form's underlying table.
The combobox is called [combo0], and in the form's detail section is the
textbox [text0] that I want to display the selected field.

in the BeforeUpdate event I have the following:
=SetUpCtl_Before(Me)
this calls the following
Public Function SetUpCtl_Before(frm As Form)

I have following questions.
I would like to add diverse dates in a table to one string
example 1: diverse data between 13 jan and 4 febr
how I want it to look: 13, 17, 24, 30 januari and 2, 4 februari 2008

Hi to everybody,
I have been disappointed after having tried for so long to get an answer to
this question but I will give it a last try.
I am trying to learn object oriented programming and for this purpose I

I am using the AfterUpdate event of a control txtFrom on a form
PSelectReport to filter the dates in a report. This works fine if I just type
in a date in the control.
However I am now using a calendar control to enter a selected date in

I have an application in Access97 and use method FindFirst.
I want move application in Access2000, but method FindFirst don't exist.
What can I do?
Thanks

Hi I am trying to add a record to a table
My code is as follows:
Dim rs As New ADODB.Recordset
rs.Open "SELECT EmpJobID, JobID, EmpID FROM tblEmpJob",

i have a list box which is generated by dragging names from another list box
(tables 1&2)
I now want to select the names in table 2 into teams of 3-4 individuals,what
is the best way to do it??