Search results

Leigh, cmd.CommandText = "sp_GetReviewCriteria" cmd.CommandType = adCmdStoredProc cmd.Parameters.Refresh cmd.Parameters(1).Value = lngCase 'Set rsDb = cmd.Execute <<=== this line is currently commented out rsDb.Open cmd, , adOpenKeyset, adLockOptimistic rsDb.MoveNext <<<<=== OK rsDb.MoveFirst...

Leigh, OK. I will try to ran your code again. Currently it gives me error on rs.MoveLast line. The fact that you successfully use this approach is encouraging. Hope I will be able to reproduce it Thanks

Leigh, This aproach does not work (at least for me): rs.Open cmd, , adOpenStatic, adLockOptimistic It still is forward-only, in other words, rs.MoveLast or rs.MoveFirst do not work Banana, You are right, sp contain a Select statement and returns a rowset. However, to call this sp you create...

You (or I) cannot open recordset this way from command object. strSql in this case would be SQL statement that you would sent to the database like "Select * from Emp" Thanks

Dear Banana, I would be happy to be able to use client side cursor location. I tried it many times - this is not my theoretical idea - it is my sweat and tears...

Leigh, The article describes recordsets that are opened via connection object. When you use command object the sequence of events is slightly different. This is a sample: Set cmd = New ADODB.Command cmd.ActiveConnection = connSql cmd.CommandText = "sp_GetPersonNames" cmd.CommandType =...

Hi Banana, You can define cursor type and location in ado if you sent sql statement from client via connection object. Command object (that is used in calling stored procedure) returns forward-only - at least this is my experience (from SQL Server 6.5 to 2008). I would be glad if somebody proves...

Hello, Thank you. Inspired by yours and pbaldy's suggestions I will try update the SQL server table after all changes for current case have been made and the users switches to another case (or exits the form). There are some limitations on recordsets that are generated by stored procedures -...

I am using ado command object to retrieve a recordset from stored procedure as well as to insert, update and delete (each has its own stored procedure). I like the idea of using one step updating the SQL server table. However , some of the records would be deleted, some - updated and some -...

The reason is that I dump from base SQL server only records related to the specific case. Every time the user selects a new case the local table is reloaded. All selects, inserts, updates and deletes are performed by directly using SQL Server-side stored procedures. And - it works OK, however...

Well, this is exactly what I do. I have a local table (a mirror of base SQL server table) that is bound to the subform. Every new case (click the item in listbox) to which records in the subform are related would 1) delete all current records from the local tbl 2) populate this table with the...

We have an Access application. I need to use its forms as a front end to SQL Server. Due to security issues all tables and queries are moved to SQL server (queries become stored procedures). In other words, SQL Server tables ARE NOT LINKED to Access form controls. Instead we are using VBA/ADO...

Talking to myself..... Finally I solved it by removing page brakes and setting page layouts.

David, using this approach I can hide the report, but I still have a blank page with main (parent) report header and footer. May be I need to change the report design? Currently 1) Main report includes 9 subreports (each of them is a chart) 2) Main report has Page Footer and Page Header (that is...

Thanks David. I'll try this one and let you know.

Thanks for the link, not exactly the answer to my question. Note that this is going to be an ad hoc report. So we need to add subreports selected by user to the parent report. 1. Do subreports in the parent report have indices (like items in other controls, say, list box)? 2. Is it possible to...

I have several check boxes on the form. Each of them corresponds to a certain report. User can check them in any combinations and click Get Report button. Currently each of the selected report opens separately. My boss want them to open as subreports in one report. Is there any way to do it...