Search results for query: *

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

Hi, Ive got a set of records that I want to display according to a check box field. I can get it to sort OK but it displays the checked records first, and I want it the other way around. Ive tried using DESC and ASC but it doesnt work. Any suggestions? Thanx

thanks for the advice...got this code to work, which was close to what i had: Private Sub AddRecordButton_Click() Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec End Sub Private Sub Form_Current() If Not Me.NewRecord Then Me.AllowAdditions = False Else Me.t_date = Date...

Hi, I have a continuous form. Im wandering if there is some way of not showing the last record whilst still allowing additions? ie I am wanting to have an 'Add' button that will insert a new record and automatically populate the date and time fields with the current values. The following code...

Hey all, thanks for everyones input! After stepping back i realised the problem was that the control had already been set to short date format whichI hadnt realised (I used a form from another prgram I wrote awhile ago)..so I just removed the conDateFormat to use this... Me.Requery 'this is...

the value is Const conDateFormat = "\#mm\/dd\/yyyy\#"...thats why my previous expr. doesnt include date delimiters.Cant seem to find any useful info on how to use filter by form for this application - any ideas to a good site?