Search results

nope, not a new record

Ok so i just found a small glitch in what otherwise works great. On the first instance of checking a box after the form has been opened I get the following msg "Not a valid bookmark" error 3159. Then anytime I check a box after that it works fine...until the next close and open of the form. Do...

fantastically simple! thanxs :-)

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

I think that may have been the problem as the following fix to the code works perfectly: If rs![Price_B] = "" Then Else If rs![Price_B] = 0 Then Else rs![Price_B]...

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

Wow, that easy! thanks :-)

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!

...didnt work as i hoped but i havent pursued it anymore as i have found another way to solve my problem. thanks all the same, and will def go in the knowledge bank

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

i tried doevents and this did not help. Can you please explain further what you meant by using Close or tables?

Hi, I have some code that opens an xml document using xmlDOM. I then update a table from parsing the xml code. The problem is that I get an automation error which says that the 'data necassary to complete this operation is not yet available' when i run the code. But if I aad in a msgbox or...

Hi, Does anyone have any idea, or know where i can find information about predictive text on an entry field. I have done lots of searching but cant find anything that really fits what i am trying to do. I have a list of options, but there is about 30 which i feel is a bit too large for a combo...

that works beautfully!...thanks heaps for getting me in the rigth direction!

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

is that necassary if ive set the format to short date when setting up the field? either way ive tried what you have suggested and its still behaving the same way. Ive done some testing and it is returning all dates for the year prior to the EndDate. For example if I select Jun 07 it shows all...

Hi, I am using the following bit of code to filter a subform according to the filed Date_game, however its returning records according to the year and not actual dates.Any ideas why this may be? Thanks! Forms!frmMain!sfCurrent.Form.Filter = "Date_game" & " Between #" & Me.txtDateFrom & "# And...

Hi, I have a main form which has a button that brings up a small pop up form to enter dates from and to. I then want the subform on the main to be filtered according to these dates. So far I have, where sfcurrent is the sub, and Date_game a control on the subform. Const conDateFormat =...

yep thats correct-should have spotted it earlier..thanx!

Dim strSql As String strSql = "INSERT INTO tblCurrentEvent (Event_No, Sport) " & _ "SELECT Event_No, Sport " & _ "FROM [tblAllBetInfo] " & _ "WHERE Event_No = 1 " DoCmd.RunSQL strSql im getting a data type mismatch. Any ideas? both fields are text...