Recent content by Robert Burns

Thanks Colin, and Rich too for your suggestions. I have actually managed to tackle the problem by creating the crosstab query SQL from code, and creating the IN string that determines the column headers as below: I set strDates = ""(" & """" & Format(DateAdd("m", -1, Date), "mmmm") & """" &...

If I put 12 monthnames in the column headers property, then restrict the crosstab query to the last 3 months, I still get 12 columns with headers, but only 3 months with data. However, if one of those 3 months contains no values, then I'm back to square one, because I can't see a way of...

Cheers Rich, However, the thing is that if there are no values for one month, then that column doesn't show in the crosstab query, and I would like all columns to be shown. Thats why I imagine that the column headers property is the answer.

Hi all, My question is, how can I set the Column Headers property of a crosstab query so that it will always force headers of the names of the preceding 3 months, as opposed to simply setting the property to the current preceding 3 months ie: "September", "October", "November"? Thanks for any...

Hello there, I am trying to force the column headers of a crosstab query by setting the IN string of the query through VBA, rather than setting the column headers property in the query design window(though I would still have the same problem, I think, if I tried to set the column headers...

Thanks very much Travis, That seems to have sorted it. Cheers, Rob

Cheers Dave for your help, I am trying your syntax but it says that there is now a 'type mismatch' . I don't think I can use the full reference version because I am trying to create a shared procedure that reads the selected contents of a list box, generates a WHERE string, and then opens a...

Hi there, I am trying to pass some arguments from a form's code module in a call to a public procedure stored in a standard code module. The arguments I am passing are: 'strFormName" the name of the form, which = "frmFilter" 'strList' the name of a list box, which = "lstFiltered" Why, when I...

Thanks very much Chenn, I had tried many different combinations, but not that one! Cheers, Rob.

Hi there, I am having trouble due to my lack of syntax knowledge regarding the 'wherecondition' part of the DoCmd.OpenReport command. I am opening a report from various command buttons on a form and applying different filter criterias. This works fine when filtering on a field being equal to...

Thank you Tim, Thats helped me a lot, I was being a bit clueless regarding my string variables. Robert.

Hello there, I am trying to perform a 'not in list' test on a contract number entered in a textbox by opening a recordset from a query and using the newly entered contract number in a findfirst operation, followed by a nomatch check. The jet dbengine does not recognize 'lngCRef' as a valid...

Thank you Fizzio, just what I needed and as simple as I feared! Cheers.

On my contracts form, derived from tblContracts, I have a list box that looks up shippingref numbers from tblShipping. The relationship is one contract to many ref numbers. For each contract, the listbox currently shows all ref numbers, not just the ones related to the Contract. How can I...