I have a table of policies (Table1) and a table of aircraft (Table2) with a
one to many mapping which I've specified using a subdatasheet and equivalent
form. I.e. one policy can have one or many aircraft.
In my policy form, I'm trying to show the total cost of all the aircraft ...

Hi...
I want to count the amount of records matching my filtering...
I wrote:
sql_volume = "SELECT meetoefeningen.Meetgroep FROM meetoefeningen WHERE

Have the following annoyance on a db I have asked to work on:
When the form is in datasheet view the font is green, when in formview the
font is black.
Have gone into Tools > Options > Datasheet & have set the font forecolor to

I have a form with a combo Box in the main form that selects a record
In the sub form I have a list box that selects a record on the sub form
What I need to do is to have the list box to be filtered according what is
selected with the combo box on the main form

does anyone know how to get rid of decimals for numbers in listboxes. Even
though the numbers are defined in the tables wit no decimal places, they get
two by default in my list boxes.
Baard

I am trying to implement the fancy tooltips from Stephen Leban's site,
and am having a small problem with controls that are not always
visible.
Initially I simply set the tooltip to an empty string, but that means I

I have a problem that as the user entered wrong data then evaluations started
and the message displayed that enter correct data and then control should go
to that specific field for entering correct data. but it doesn't. the code I
used is as below.\

I'm trying to open a querydef using a SQL statement that has multiple
criteria.  My database has three locations: A, B and C.  If I use the
following SQL statement, only the A locations are returned (which is correct):
    Dim strSQL as string

All,
I'm trying to figure out how to deal with the possibility of a null value being passed into a function.
I'm using the following call to a function in an MS Access form "=getFullName([Field])" the problem seems to be if the field does not have a value,  I'm receiving an #Error ...

The Combo Box has (3) columns - Column 3 is what I want here.  Instead of
adding the value for each row in the string, it always puts the value of the
*first* row.
Private Sub cmdEmailAll_Click()

Can anyone please tell me what code is needed to open a particular MS Word
document?  For example say the path to the file is: C:\Folder\FileName.doc.  
What code do I need to open the document?
The background is...I have a form that the user selects a value from a combo

I have a custom htmlhelp file that I can get to open from Access 2003
using the regular settings for HelpFile and HelpContextID but the help
window always opens less the navigation pane, the pane on the left side
that normally shows table of contents, index etc. I've found three ...

I have two forms based on a single table for company projects.  The first
form contains data regarding the projects; the second form contains multiple
"updates", i.e. a "date" field and a "comment" field where users can add an
"update" to the status/condition of the project.  ...

I use your modCalendar application. The problem I have is that when I open
the monthcalender from a modal popup, the monthcalender can lose the focus
when I click beside the monthcalendar. I have to move the main popup to see
the monthcalendar that is hidden behind it. Is there a ...

I have a table 'cars' (Id,Car name) and a table 'rentals' (Id, Start date,
End date, Carid, Person).
I want to populate a combolist with the cars NOT rented for a specific date.
Thanks for helping.