Recent content by tania20

Hi, I have the following code that works fine on my form...except for the first instance that I open the form and click the boolean field check box for which this code is on. Any ideas why this might be? Dim strBookMark As String strBookMark = Me.Recordset.Bookmark Me.Requery...

I have a subform that displays a list of records based on a filter. I have a checkbox control that when ticked, I want to requery the form to orderby this control. This all works fine, however I want some way of maintaining the focus at the position where this occured(the next record after the...

Hi, I have the following code. The weird thing is that if both the fields are null or not null then the code works fine but if one or the other is null then i get a type mismatch error. I have no idea whats causing this!!! [Code] If IsNull(rs![Price_B]) Then...

ah, turns out the solution is very simple, just needed a comma between the two field names in properties!

Hi, I was wandering if it was possible to orderby on two fields? for example, I have my primary ordering into two groups, then I want a secondary ordering within these 2 groups. Thanxs!

thanks :-)

Hi, I need some syntax help on the following line of code: rs.FindFirst (rs![NewRecord] = True And IsNull(rs![Event_No])) where NewRecord is type boolean and Event_No is string. Ive used this function mainly on strings so am not sure what to do with this one! thanks!!

this is the apprach i had been thinking about but im not sure what to do when the user doesnt close the application at all

Hi, I am wanting to prompt the user to do a routine compact and backup every week and not sure of the best approach. Ive read into using the form timer to accomplish this (though this has a max of 65000ms),task scheduler. Some users will be opening the database daily, and others are likely to...

that thought just occured to me...and sure enough....there was some other code overwriting this in a pop-up form!! thanks for yr help!

Ive tried that and it still doesnt work. For some reason its ordering even when i remove the code and property reference.Very baffled!

The following is returned tblSummaryInfo.ViewResult DESC, where the recordsource of the form is tblSummaryInfo....

I use the same when I am applying a filter and that works fine....

yep i tried with and without quotes in properties and code: ' Me.sfCurrent.Form.OrderBy = "ViewResult DESC" ' Me.sfCurrent.Form.OrderByOn = True

I tried a range of things... "fieldname DESC" fieldname DESC both in properties and by using OrderbyOn in code