Search results

I have the following query :- SELECT tblQuotes.Region, Count(tblQuotes.Region) AS xCount, tblQuotes.Sales_Route FROM tblQuotes GROUP BY tblQuotes.Region, tblQuotes.Quote_Status, tblQuotes.Sales_Route HAVING (((Count(tblQuotes.Region))<>0) AND ((tblQuotes.Quote_Status)="Accepted")); This...

Wonderful, thank you very much.

Yes, I'm using a union for another report. With this one though, the various queries have differing numbers of columns, which makes a union a bit of a pain. Something I hadn't though of, which I can consider though! Have another Thanks :)

I have around 10 queries checking for different issues. In order to give an overview of the issues, I had one big form, which had 10 subforms relating to each of the queries. I thought I could tidy this up by pulling the values from the queries into text boxes (or labels) into one report...

Okay - copy attached. Thanks!!

Yes - OnLoad Compact and repair didn't help. My tables are SharePoint lists. Obviously, I'll have to remove these, meaning the query won't work. Would it still be worth uploading?

In design view text6 had the word Unbound in it. I created another text box (text5) also has Unbound showing in design view - same problem. However, when I create a label and set iCount to it's caption, the value displays fine. This is okay temporarily, but I would prefer a text box if possible...

I did actually spot that while I was awaiting your reply and amended the code. :) Must be close now because when I msgbox iCount I see the value I want. But, on Me.Text6 = iCount I get :- "You can't assign a value to this object" Me.Text6 is showing as Unbound

JHB and Minty - I tried both your suggestions, and gave the following errors JHB The expression you entered as a query parameter produced this error: 'xCount' Minty The expression you entered as a query parameter produced this error: 'QuoteStatus'

Hi all, i am trying to set a dlookup on a query to a text box on a report In the On Load event of the report, I have tried the following code :- Me.Text0.ControlSource = DLookup("Count", "qryReportQuotesByStatus", "Quote_Status = 'Accepted'") and [CODE]Me.Text0.ControlSource =...

This worked. Thank you.

Hi all, I have a combobox with a row source of :- SELECT tblBrokerages.ID, tblBrokerages.Brokerage_Name FROM tblBrokerages ORDER BY tblBrokerages.Brokerage_Name; The bound column is 1 and the column count is 2 When new entries are added to tblBrokerages, they appear at the bottom of the...

Thats right. I'm not sure what point you're making here, but anyway... Sorry, I missed this post. The example works great, and is what I will use going forward. I was using the button approach previously as a work around, and that worked. I followed your suggestion and deleted the control...

It's not really an extraordinary claim. I posted my original question, answered the following questions. That's all there is to it. I'm happy to answer anything else, but I feel no need or inclination to prove anything.

The combobox is unbound There is no input mask There is no code to change the value I feel the SQL was worth posting as it's the source of the combobox, and I stick by that fact.

I'm fairly sure, as I've explained the situation, someone may have a solution without having to post the database, but you may be right.

Not quite. The list is pre-defined. To have a completed form, the user either has to have a null value, or a option from the combobox. There are no issues with the items on the combobox. I would just like the facility to delete the value if it is picked by mistake. Currently, if the user deletes...

The value associated with this combo box isn't required to complete the form. But if someone selects a value, and then decides that there shouldn't be one, I'd like the option to remove the selected value from the combobox. I've gotten round this currently by having a button that clears the...

Thanks for your suggestion. Unfortunately, this didn't create a null value to pick from, and the user is still unable to remove a previously selected entry.