Hi everyone, using A02 on XP. Not a programmer but trying to get there. I
have a form (with a subform).  On the subform a record is created, edited,
macro validated and saved. Have a btn to preview report. Have the following
in the OnOpen event of the report:

Is there a way to count the total records in a Dlookup statement for example
I want to use a Dlookup statement in a textbox on a form to count the records
inside of a query.

Hey all,
Been using Access for several years, but am now trying to teach myself VBA.  
Am using Access 2003.  These groups have been most helpful.
Can someone give me some direction on how to add a menu button to the bottom

Hi, I'm trying to add a "ctrl+enter" to a text field, but not manually, I
take the text in the DETAIL_DESC field, and add it to the DETAIL_HIST field.
Each time I add a new DETAIL_DESC.value to DETAIL_HIST, I want a new row. Can
you help me?

I have 2 forms that feed 2 different tables.  I would like form 1/table 1 to
feed certain information into form 2/table 2.  How would I go about this?

I have a table name 'MasterTable'. when a user inputs data in a field on
the form , at this stage i want the values be entered first match with
master table field. If match then proceed on next field otherwise display a
message.For this purpose I need code of event procedure.

I have a main form on which a user selects a tax topic that then selects
state details for that topic. On this form I allow a user to click a button
to add a record. This action brings up a new form. Once the record is saved
and the form closed, the user goes back to the details ...

I have a main form with a subform on it.  The subform (datasheet view)
lists all the records for a particular vendor.  When I double click on a
row, I'd like the detail form for that record to popup with records for
that row that I clicked.  

I have a from that auto populates customer details when the customer ID is
entered. At the moment, it work only if a customer ID exists in the primary
customer table. If a customer ID is not recognised, Access prompts a message
stsing that the ID does not exist. The customer ID ...

Good day,
Access 2000 on Windows 2000 Pro
I don’t know if the following can be done and if it CAN, how do I do it…
Components:

HI
I have a Form with a list box, when you double click a record in the list
box it opens in another Form showing all the details for that record.
I would like the colour of the record to change in the list box if any of

I have a main form with a subform on it.  When I double click on a row in
the subform (datasheet) I want open another form which will bring up detail
records for the current record.  My code is not working.  Here is my code:
Private Sub Form_DblClick(Cancel As Integer)

I need a form that when I click on the companyName drop down it will
populate the form with records
only pertaining to that company.  I've already built the form, but I have
not captured the specific fields for each company.  Right now all the

Does anyone know a way to put a border around a report and between the
columns of a multi-column report?  I tried just adding the lines in the
report detail and it did not give a line on the far right side plus the
border was not complete if there were not enough records to fill ...

I have a main form containing a button to do a search. Clicking this gives a
popup of available records. Selecting one will then populate the main form
(and close the search popup). On the main form also is a subform which
contains correspondence. The subform is set up as a ...