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

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!

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

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

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

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

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 frmSummary is the sub. Forms!frmMain!frmSummary.Form.Filter = "Date_game" & " Between "...

Hi, I have a form which shows all the records for a table.I want some way to have a button next to the fields for one record that will open another form based on one field of the selected record. I know how to achieve through using a yes/no control and applying a search criteria based on...

Hi, Im trying to, upon the click of a forms button, search the records in one table for all records matching a certain number. I then want to update another table with all these records...but am stuck in the coding. This is what i have so far... Set db = CurrentDb() Set rs =...

Hi, Can anyone help me on the snytax to pass in a string element of an array to openrecordset. This is a segement of what I have so far. ......(1) to (22) here arrTables(22) = "48MonthsFollowUp" For i = 1 To 22 Set rs = db.OpenRecordset(arrTables(i), dbOpenDynaset) next i

Hi, I have the following code in which I am doing a loop through 24 fields of a table (rather than duplicate this code 24 times), but I get an automation error on DLookup("[strAdd]"... What do I need to do pass this string in accuractley as the field Additional1 of my table? Cheers tania...

Hi, I am trying to write a pascal script for inno setup that is based on the date, but have no experience with pascal. I have trued the following code but it does not seem to reconise the date functions. Why is this? Or how should i be approaching this? Cheers Tania Var S1 : String...

Hi, i cant seem to work out how to view all the diffrent pages in my tab control in design view when style is set to none!? any ideas? cheers tania

Hi, I have tested my databse and everthing works fine but then have given it to a customer and the following part of the code does not seems to be updating as required. Set rs = db.OpenRecordset("LTOT_second_oxygen2", dbOpenDynaset) rs.FindFirst "[HospitalNumber] = '" &...

Hi, how do I lock a forms position on the screen? my border style is thin and i have set it to autocentre... Cheers Tania

Hi, Can anyone please give me some tips on how I may go about setting up my installer so that after it has been installed the application will automatically run? Cheers Tania

Hi, does anyone know how to check if a form has been edited? Cheers tania

Hi, I am trying to search the records in a table "air to see if there is a match with general.HN (a field in the current form). If there is I want to do nothing, else add a new record with general.HN. I just cant seem to get it right though! any help appreciated!Cheers Tania Set db =...