Recent content by Gnasch

I have solved this problem, at least from the users point of view. But perhaps someone can explain the mechanics behind why this happens. I have an access 2007 project tied to a mssql server. On my form, whenever I issue an recordset.requerry command, the recordset that is reuturned has...

The question was how to use a split database when the user doesnt have access to the backend. In which case using a set of local backend tables when away and writing a program to 'sync' back up when access is restored is still the proper solution.

If your split he will have to take a set of the backend tables with him. Doesnt sound difficult to write a program that will take his tables, connect to the production tables and update. Then if you want the 'field' program to also work off of the production tables then simply wite a program...

I dont get an error on that, but code runs differently on a machine with access installed rather than just the run time. If its having a heartache with setting rs then try using this instead. Dim rs as new ADODB.recordset rs.Open "tblMATICNI", CurrentProject.Connection, _ adOpenDynamic...

The ribbon is a cake walk once you understand the callbacks. Then tackle the XML which is very easily solved by creating class structures that generate the XML strings. After that, all you have to do is create as many object instances as you need and populate the class properties the way you...

The simplist way would be to pass a form object to the Frm_Add/Edit that is set to the calling form. This way you can do any recordset or control manipulation you need to do from the Frm_Add/Edit and dont need to worry about which form called.

Check the library that the class function is store in, ie a dll. Then make sure that you have the same version of the library file installed on all the computers and that your references are all set correctly.

That seems to be a lot more trouble than its worth. Once you have the start date and the end date you can calculate any date in the middle on the fly. Maybe there is a specific reason you need a recordset but withouth knowing what you are going to do with it I agree with ions.

Without seeing the form itself and the text box names I can only guess. There are a few things that come to mind however. First. After you clone the recordset, cycle through the records to get an accurate RECORDCOUNT. This wont solve your problem but DAO requires it. And the While .eof...

I tried several different orders, quotes, single quotes, double quotes. I think I am just fighting the UHoG (Unseen Hand of Gates). Everything works fine as long at its in the WHERE clause. I cant find very much on the mechanics of the FILTER vs. WHERE. Thanks for the Help.

Thanks for the tip. I read the page you linked (bookmarked it) but there wansn't anything that fixed this problem. I just moved the whole thing to the WHERE in the SELECT statement and it works fine, its just a pain opening an closing when I could just be filtering.

The first is the right logic, but fails. The second is the wrong logic but runs. strSQL = "SELECT * FROM MyTable" rstRecordsCursorType = adOpenStatic rstRecords.CursorLocation = adUseClient rstRecords.Open strSQL, CurrentProject.Connection...