Search results

I have various fields on a form that are referenced by various different queries. The one that is causing me the most problems is the one that contains Date content On most of the other fields I use something similar to Like "*" & [Forms]![frmarchivesearch]![txtinvCustname] & "*" However when...

Is there a central reference on the net that explains the pro's and con's of each of the event types. I historically have used the OnChange event until the other day when someone suggested using the AfterUpdate instead. Would like to ensure that I have the best event trigger being used where...

It shall be done Thank you for the scoop Regards

Excellent, quick response and it works too Great, thanks very much Regards

Hi I have a combo box on my form. I wish to set the value of a text box on lost focus of the combo to be the value of the combo cbxDateFrom +6 months The code I am using is Private Sub cbxDateFrom_LostFocus() cbxDateTo.Value = [DateAdd("mmmm", 6, me.cbxDateFrom.Value)] End Sub But it...

Thanks, I will try that

Hi I found the problem with my IIF statement, there was a circular reference because the object name was the same as the control source name. Bad naming convention on my part. All is well now with what I used =IIf(IsNull([UnderOffer]),0,[UnderOffer]) Changed the No Data Available to zero as...

Is there a way to hack IIf(expr, truepart, falsepart) to work in this situation. I have tried IIf([IsNull], "No Data Available", [UnderOffer]) But that just seems to upset it and does not work, so I am guessing the format is wrong Regards

OK, I have now found what NZ is, but this appears to be a function that is used in a VB environment. Is there an equivelant version that I can use in the report? Regards

Thanks for the response, when I put that line in, I get an error. The helpful tips say that it is a circular reference. The line I used was =Nz([UnderOffer],"No Data Available"), UnderOffer being the original value in Control Source prior to your suggestion. What does the =NZ bit do, is it a...

I have a report which is made up of a complex(ish) Stored Procedure within SQL 2K. This involves a number of Cross Joins, Left Joins etc etc. There are various tables quizzed by the SP and sometimes there is data to return and sometimes not. On the report, obviously the control source is set to...

Please find attached a stripped version of the database. the table I wish to show on the sub form in a formatted datasheet view is tblArchive. Although ulitmately I want the information to be shown to be based around a Select query that will be filtered based on whatever the user has selected in...

Thanks for the offer, but even stripped to its bear bones with no data in it exceeds the attachment limitations. Kind offer though thank you

How do I get the sub form looking like the attached ringed in red? Thanks

Thank You for the input I will try that now

I wish to create a subform that contains a subform that is made up of a query in datasheet view. I wish to be able to format the display properties of the datasheet though (Font etc). The problem is that the result set is too wide and too big (out of scale with rest of form) and it just looks...

Thanks to all. I shall try all the suggestions posted and I am sure they will solve my issues. Regards

I guess another way of rewording the latter part of my previous question, is there a way of freshing the format command of a specific combo box so that the format will be displayed correctly?

Firstly let me say that I appreciate the suggestion which works exactly how you would imagine it to. The only reason I asked about the ascending is that the list is used to be used in a earliest data first point of view. I understand the concept of what your suggestion puts forward and...

Thanks, is there a way of doing it from an ascending point of view?