Search results

Urgh - figured it out. I created my template from a copy of one of the other reports. I had left the control sources as bound. Setting them as unbound allowed be to change the control source with :- Reports!rpt2Cols.rpt2ColsDetail1.ControlSource = "qryAbortRegion.Region"...

This issue I have is that I'm not running the code in the open and load events. I have a "report dashboard", with around 30 different reports. Around half follow the same report structure, so I want to use a report template for all 15. My thinking was to change the report's properties upon...

Hi, I have a report that I open via a button that I'd like to use as a template. I've been able to change the recordsource, etc. Where I'm struggling is the controls. If I don't set the Controlsources, Access asks for them via parameter. If I just click okay, the report opens as expected. If...

Thank you.

Thank you.

Hi, I'm using the following in VBA :- MaxVal = DMax("Sales_Ref","tblQuotesNew") But how can I get the max Sales_Ref that is below 10,000? Thanks in advance

No, I'm using the pane

When opening a table, I am now being asked to enter a parameter value for "Lookup_Supply__ID.SupplyID". The table I'm trying to open does have a field "Supply_ID" (one underscore), and there is a relationship from that field to another table. I understand the issue I have is a little vague...

Please see attached - thanks I'm also trying Ranman256's report option

Hi all, I have a query where I need to record a running total. My current code is below SELECT tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy") AS xMonth, Count(tblBrokerages.DateTPIAgreementSigned) AS Original FROM tblBrokerages GROUP BY tblBrokerages.BDM_Name...

Works perfectly - thanks Minty

Hi all, I have the following query :- SELECT tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy") AS Expr1, Count(tblBrokerages.DateTPIAgreementSigned) AS CountOfDateTPIAgreementSigned FROM tblBrokerages GROUP BY tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy")...

Thanks Minty, that's exactly what I needed.

I'm more than happy to have the wildcard return only "begins with" results, if someone could shoe me the syntax.

It does have to be VBA unfortunately. My whole search form is built around it.

Hi all, I'd like to use the equivalent of Like in an SQL query via VBA. The code below finds the exact value :- strSQL = "SELECT tblBrokerages.ID, tblBrokerages.Brokerage_Name AS [Brokerage Name], tblBrokerages.Broker_Code AS [Broker Code] FROM tblBrokerages WHERE tblBrokerages.Brokerage_Name...

Thanks again.

Thanks - can this be done in desgin view? I tried using "Number of quotes by status " & DCount("*","qryAcceptedQuotes") but that literally showed in the caption

Hi all, I'm trying to show text and a dcount result in a command box's caption. I've tried the following without success :- [CODE]Number of quotes by status & =DCount("

Perfect - thank you. The SQL I ended with was :- TRANSFORM Count(tblQuotes.Sales_Route) AS CountOfSales_Route SELECT tblQuotes.Region FROM tblQuotes WHERE (((tblQuotes.Sales_Route)<>"0")) GROUP BY tblQuotes.Region PIVOT tblQuotes.Sales_Route;