Search results

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...

Hi, I have a Report which can be driven by either of two Queries (each has slightly different criteria). On a form I have a ComboBox and a CommandButton. I wish to set the RecordSource for the Report before opening it. It will be one of the two Queries mentioned and will be determined by the...

Hi Brian, I am in no way doubting you and I really appreciate your advice but I was hoping it would be done in the same query. Are you sure it's not possible? There is in fact a lot more to the query (I have simplified it for the example here) and I would dearly like to use it for either...

Thank you for your help guys but I now have another problem. Here is the SELECT clause which the ComboBox gets its data from... SELECT BusinessModel, BusinessModel FROM tblData UNION SELECT '*', '(All)' FROM tblData; This part is functioning correctly; it returns two columns, I am hiding...

Hey guys, Thanks for your advice. At the moment my reports' record source is an "integrated" report query. Does this make sense? What's the proper name for this type of query? I presume to do the new business I shall have to create my query/queries as "standalone" queries (so I can refer...

Hi, I was wondering if anybody can offer some help and advice on the following please?............ I have 2 reports. They both display identical fields. The difference between the two being the queries behind them (each report has its own 'integrated' query sitting directly behind the report...