Search results

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

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

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, 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, Does anyone know how I can go back to the beginning of a sub from error trapping? 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 form in position on the screen? I have tried autocentre, but this doesnt seem to centre it? My border style is thin. 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 =...

Hi, i am using the following code to open another access database. it works fine in fuilltime but when i install a runtime version I get an 'active x cant creat object' error. Does anyone knwo why this is? Dim appAccess As Object Const strPathToBackup = "C:\interim.mdb" Set...

Hi, I have packaged my Access 2000 program using SageKey. When I open the installed runtime version of the database, and click on a menu button that performs a databse backup, there is no error, yet the file does not copy (note that I am using a function that utilises apiCopyFile). It does...

Hi, Does anyone know how to perform an exact match using file search. The code I have below searches for the users AcroRd32.exe file (I have done it this way to allow for different versions of the reader). The problem is that foundfiles returns also AcroRd32info.exe ie FoundFiles(1). i only...

Hi, I have the code below that checks the If condition and returns a msgbox if true. i want to exit the beforeupdate sub when the person clicks ok (ie go back to the form), but it keeps on going through the code even after cancel? Note that I can't rely soley on the required field condition due...

Hi, I am currently trying to package and deploy my database as a runtime version, but am getting runtime errors when I open the installed database and I have no idea where to start with what the problems are! There does not seem to be much info that I can find on the web to help me. I am using...