Search results

I am using the Not Statement which works fine when my first query returns only one record, however if my first query returns more than one record then my second query seems to ignore the criteria. Thanks for your help

I have a query that returns a number of clients (ID, Name, Address) This works fine. What I want to do is create another query that returns every client except for the one's returned in my first query. Can anybody help me with this Thanks in Advance Matthew

Unfortunately this doesn't seem to work maybe it's me but I am sure I have tried everything. Thanks for your time and assistance

I can't do the calculation from the main form

The sum is correct as everything works fine when the subform contains data. If there is no data showing in the subform then I get the #error. I am unable to use the Sum function and directly reference the column in the subform in one calculation. Thanks for your help

I use this function in my calculation. On my subform (in the footer of the form in form view)I have a text box which calculates the total: nz(Sum([Total Purchases])) I then reference this text box from a text box on my main form: [TotalPaymentssubform]![Total] I am wondering if this is the...

I have a text box on my main form which sums a column from my subform. This all works fine except when there is no data in the subform the text box shows #Error. Can anybody help me with this as it is driving me nuts Thanks

Sounds like your main form is set as a Pop Up form. Try setting the Pop Up property of the form to No.

Try this link. This method worked for me www.mvps.org/access/forms/frm0043.htm

If you e-mail a report in rtf format then providing you have Word installed on your machine the report will open up in Word by default. The only problem is that you will lose any graphics etc only the text will be shown.

Try checking the after update event of the first combo maybe the code is missing. You might have to cut and paste the code manually. Just a thought Matthew

You could try something like this in the on click event of a Cmd Button or in the after update event of the combo box. This method is ok if you only have a small number of values in your combo box If Combo0 = "the 1st value selected from the combo goes here" Then DoCmd.OpenForm "The name...

My trouble is that it is not a field but a text box and therefore I can't select it from the sorting and grouping option.

Could anybody tell me if it is possible to sort by a text box in a report and if so how can I do it ? I have a text box which calculates totals within a group but I would like to sort by the total. Thanks