i have try to make a dsum in my query but i got a problem, i think!!
Allen Browne sugest  "=DSum("quantity", "Table1", "code <= " & [code])"
but, the field "code" is noy unique.
for a better explination:

I've tried reading the help and some of these questions but I still dont get
it.  Everybody talks about using the & operator but where and how???
I'm looking to concatenate Forename and Surname so when a person is selected
from a lookup field both names remain in the box not just ...

My DB is coming along very well, I think, thanks to you kind folks.  I was
warned that this stage of the process would be complex due to the nature of
the database.  
A little background:

I have several subforms in which I have linked two unbound combo boxes so
that the selection of the first combo box filters the rows which are selected
in the second combo box.  Example: Category combo box filters SubCategory
combo box.  The subforms are then embeded as tabbed ...

I have a one column listbox set to simple. I would like to create a command
button that would delete the items being selected individually. I probably
would have to click the button after each selected item,but How would I code
this. The lisbox is field name is lngVolser.

i have a txt box called:
cw_log_id
I want this to be disabled (greyed out), unless the tick box above it called:
refered

I have a form, that I'm using as an asset register. In it is a drop down
menu. I'd like to set the default value to the 1st record in a table, with
out having to do anything manually.
I.e. The table for os_type has

I cant get the MinMaxButtons to set to zero. Ihave been trying
FormName.MinMaxButtons = 0 with no luck

My form is designed for Allow Deletions and Allow Edits
both to Yes.
Could someone please advise how to save deleted record to
a separate table. Same thing for a record just before it

Good day,
A reply from Allen Browne to an earlier post from "Angi"
sent : 4/12/2005 11:14:16 PM on the subject: "records
aren't appending...don't see an error! " has helped me in

I have a listbox which includes four or more teams, each team is numbered 1
thru 4 or more.
When I click my listbox team, I would like [teamA] to be updated to that
value, and on clicking the listbox a second time, [teamB] to be updated to

I am having difficulty in setting my recordset to my subform which is setup
as a datasheet.  My code is as follows:
'I've already declared my ADO objects and subform as class level variables.
'This procedure occurs from the main form's module.

I received an answer before on how to bind rows to a datasheet by using:
     me.subformcontrolname.form.recordsource=strsql
I get the correct number of rows returned, but I don't have any data and
therefore, my datasheet on my subform is blank.  My form and subform have the

I have a form for collecting test results. It is basically a series of combo
boxes. The first combo box holds 12 test categories. Each category can have 1
of 6 different test methods. The 2nd combo box contains the 6 methods -A, B,
C, D, E and F. Methods A, B and C require that ...

Is it possible to open Access with a fixed size with some API-calls?
regards
reidarT