Recent content by vwgolfman

It's OK I've realised my mistake :D My second query should of course, have referred to the first query. i.e. "FROM qryAveData" Cheers :)

Hi, I wonder if some kind soul can help me please? I have a query which is based on another query. When the second query runs, it asks for parameters but these values should be returned by the first query. Why could this be? Queries (simplified).... qryAveData: SELECT Avg(tblData.Par) AS...

Hi MStef. When I check the field in Datasheet view, the value is 147319.7 After some reading it appears that the reason I am seeing rogue values is that the number is stored as a floating point number. This means that it is stored approximately and not exactly.

Hi, A field in a table has the following properties... DataType: Number Field Size: Single I have ONE record in the table and the value for the above field is 147319.7 When I display this record in a report by using a "Detail Query" the value for the field is correctly displayed as...

Edit: Thanks for your help guys, very much appreciated and all sorted now :)

Hi, Original post EDITED: In a Report_Open method, if there are no records I would like to display a messagebox with a warning message (specified by me) and then Cancel the Report from opening. I don't want a messagebox popping up telling the user that the report opening has been cancelled...

Woohoo! Thanks Paul, that's the business :)

Another quick one guys (on another topic).... I am adding "All" to the choices in a ComboBox by using the following SQL.... SELECT BusinessModel, BusinessModel FROM tblBusinessModels UNION SELECT '*', '(All)' FROM tblBusinessModels; Column 1 is the bound column and I am giving it width of...

I'm sorry Paul I must have made a typo. Yes it works fabulously thank you! Thank you to you too Ken. No, I didn't want to have to type the text in each time the report opens :)

I want to specify the text in the Report_Open method Ken.

Hmm, Neither of these work guys. When the report is called, it pops up a window asking for input.

Hi, In a report I have a textbox which displays the value of a field (its control source). Under certain conditions I would like to remove the "binding" for that textbox and replace the displayed text with something specified by myself. I intend to use the report's Report_Open method in...

OpenArgs is indeed what I have gone for :D Thanks guys Woohoo!!

Thanks both very much for two excellent methods to use. I have considered both and also my project scenario and have come to the conclusion that the best option for me would be to set the query in the report's open event BUT... Is it possible to pass the Query Name over to the Report_Open...

Paul, What I failed to mention (as I wanted to keep it simple) is that there are 2 buttons and several comboboxes on the form. The RecordSource is determined by a combination of which buttons is clicked and the options chosen in the comboboxes. For this reason I believe the RecordSource...