Openrecordset jobs

There is a problem with ACCESS that Microsoft is addressing. For now, I need someone to reprogram our queries as per suggestions given below Modify All Your Update Queries If you decide to modify your queries, you'll need to locate all the Update queries that trigger the error. These could be saved queries and SQL queries invoked in your code. Once you i...reference tblCustomer, now reference the query. Since the Update query bug doesn't apply to queries that update queries, this eliminates the need to modify the individual queries. However, there's a limitation. Any code that tries to open the table fails if the table is now a query. This would include comments like: Macros that open a table TableDef or TableDefs collection OpenRecordset commands with explicit tab...

Hello! I have a very simple problem. I have a button that sets a recordset based on a query. For example: rs = ("qryName") This query has a WHERE clause where I need to specify that the records are from a certain year. This year value is pulled from a control on the form the button is located on. For example: WHERE (Year())=Year([Main]![NavigationSubform]![txtYear]))) However, I get a run-time error because, to the best of my knowledge you cannot use a control in query that a recordset call is used in. I need help making it so my Query can access the value stored in this control.

...recognized as a database. I searched Microsoft for help and it seems I needed to update the Service Pack "and" reference libraries in VB6 to accomodate the Service Pack. So I did that and I get error messages when I try to create an Executable for the program via VB6 “Compile Error: Method or data member not found??. It no longer recognizes certain parts of the code as valid coding. Things like .openrecordset for example is invalid. This program has approximately 100 pages of code, but I can't tell you how much of that will have to be recoded or debugged to accomodate the update. I would like to think it wouldn't be a very difficult upgrade for an experienced coder, but I don’t know. I'm including a few screenshots of what is "goi...

...examples of using the recordset to access the data base - I want a full set of functions so I do not have to change this code - I only want to change it in one place. I have highlighted the types of commands I am looking for BookDB = **(0).OpenDatabase**(Fname) s = "Select * from [Book Information]" BookRS = BookDB.**OpenRecordse**t(s) BookRS = BookDB.**OpenRecordset**(s) IfNot (**** And ) ThenBName = ****("Title").Value s1 = "Select * from Roster where [Class ID] = " & ClassIDStudentData = ****(s1, ****) ****() ****("Class ID").Value = ClassID StudentData![Identification] = ****() **StudentData

...examples of using the recordset to access the data base - I want a full set of functions so I do not have to change this code - I only want to change it in one place. I have highlighted the types of commands I am looking for BookDB = **(0).OpenDatabase**(Fname) s = "Select * from [Book Information]" BookRS = BookDB.**OpenRecordse**t(s) BookRS = BookDB.**OpenRecordset**(s) IfNot (**** And ) ThenBName = ****("Title").Value s1 = "Select * from Roster where [Class ID] = " & ClassIDStudentData = ****(s1, ****) ****() ****("Class ID").Value = ClassID StudentData![Identification] = ****() **StudentData

...property or an OpenRecordset Method where I can assign an outside to the activeX control. 2) I created Navigation buttons What happens is when I drop my control on a Bound Access form, set my control's recordset to the form's recordset, and I try to navigate the navigation works perfectly except that it locks the fields up in my form and I can no longer edit (I can navigate and edit with the form's built in navigation buttons but once I click on my ActiveX control the access form no longer lets me edit however I can still navigate). I have attached the ocx, the Visual Basic Code and an Access database with a Countries form. (The code behind the Access form is commented out. Making either method (Assigning the recordset property or using the OpenR...