Search results

  1. V

    Checking multiple unbound controls on the form

    Thanks. I'll try this approach. The final task will be more complicated since there are subforms that also can be changed ...
  2. V

    Checking multiple unbound controls on the form

    Well... YOU ARE RIGHT! I can use a recordset instead of array... Let me think of it...
  3. V

    Clear List/Combo Box Row Source when unbound form closes.

    1) I am not using a query. I am using a recordset. My access database has only forms - no queries, no tables. 2) I have a list on the form with record ids. When I click on the id the rest of lists and combos are populated by related records that are returned by recordsets (using server side...
  4. V

    Clear List/Combo Box Row Source when unbound form closes.

    Correct. Query
  5. V

    Clear List/Combo Box Row Source when unbound form closes.

    1) We are using ado recordset from sql server stored procedure. 2) we populate lists/combos using Value List
  6. V

    Clear List/Combo Box Row Source when unbound form closes.

    1) We are using SQL Server (all tables and queries, e.g. stored procedures) are on the server side - NO LINKED TABLES! All tables and st. procedures run via ADO. 2) On the client side we have forms with unbound controls, populated by recordsets. 3) When the form closes it keeps the values in...
  7. V

    Checking multiple unbound controls on the form

    1) We are using SQL Server (all tables and queries, e.g. stored procedures) are on the server side - NO LINKED TABLES! All tables and st. procedures run via ADO. 2) On the client side we have forms with unbound controls, populated by recordsets. 3) Users select individual records clicking a...
  8. V

    Tricky subform questions

    Hi everybody! I have a SQL Server database and preexisting Access forms (all tables and queries were exported to SQL Server). Access forms contain subforms. I linked controls on the subform to a local table that populates subform from recordset created from SQL Server stored procedure that...
  9. V

    Access to Sql Server, how to keep autonumber

    Bob, did you use SSMA? I tried and had a wierd experience (may be I did not try long enough and did something wrong). It made changes to the original Access mdb - I was lucky to have a copy. What I want to try: 1) setting identity in destination table using seed as max(ID)+1 and increment 1 -...
  10. V

    Access to Sql Server, how to keep autonumber

    Existing Access database contains a lot of data. I need to upsize all tables to SQL Server. Many Access tables have autonumber field. When I use DTS it would drop autonumber, e.g. it would keep the values of this field but in SQL Server it would not keep the Identity (autonumber) property. If I...
  11. V

    Use Access forms as a front end to SQL Server

    I'm also using refresh method. I had an impression that in parameters collection parameters(0) is reserved for Return value For example: ********** stored procedure ******** Create PROCEDURE [dbo].[sp_InsertKeyIssues] @KeyIssuesText nvarchar (250), @ClinicalReviewID int AS BEGIN SET NOCOUNT...
  12. V

    Use Access forms as a front end to SQL Server

    Thanks. I did not know that. Static would work ok for me.
  13. V

    Use Access forms as a front end to SQL Server

    Thanks again. I am aware of properties of ADO recordset - I used it a lot when working with client/server and web applications. Now with Access... Have more challenges (this time not with ADO). Probably will start a new post (not today) )-:
  14. V

    Use Access forms as a front end to SQL Server

    Thanks Banana! I modified my code according to your suggestions. And this one works: cmd.CommandText = "sp_GetReviewCriteria" cmd.CommandType = adCmdStoredProc cmd.Parameters.Refresh cmd.Parameters(1).Value = lngCase If rsDb.State = adStateOpen Then rsDb.Close rsDb.CursorLocation = adUseClient...
  15. V

    Use Access forms as a front end to SQL Server

    It's Sunday and I have a lot of chores to do risking my wife's anger (-: I will look at all in detail later. Banana, just a simple test: forward-only recordset 'understands' only rst.MoveNext. If you try rst.MoveLast or rst.MoveFirst it fires an error. Can you test the recordset openned via...
  16. V

    Use Access forms as a front end to SQL Server

    To add to my previous post: Leigh, I see what you mean. I certainly can use client side sql statement in development and test it (what I did). What I cannot do is to use it for production version, here I need use only stored procedures. Sorry for the mess.
  17. V

    Use Access forms as a front end to SQL Server

    >>>> So you can't even test using a SQL statement? I DID IT! It works perfectly to open any type of recordset. >>>> However regardless -you should be able to test the SP execution rst.Open "EXEC SPName", connObject, adOpenKeyset, adLockOptimistic It returns Forward Only (rst.Move Last or...
  18. V

    Use Access forms as a front end to SQL Server

    Leigh, 6 --> it was the response to the post of BobMcClellan - this is where Bob came from (-: ********************************** 3. ---> Sorry, may be my English is not good enough, but did not I make it clear that I CANNOT use client side SQL statement (that without any doubt allows to open...
  19. V

    Use Access forms as a front end to SQL Server

    Leigh and all, 1. Believe me I tried everything before bringing up my problem(s) to your attention, including using local sql statement to open ANY type of recordset including a dynamic one. Banana, I will try "Exec..." code, thanks. Does rst.MoveFirst work? 2. is my first experience to make an...
  20. V

    Use Access forms as a front end to SQL Server

    Dear Banana, In your code you send SQL statement from client side and open recordset through Connection object. In this configuration you enjoy full control over the recordset type and cursor location. I HAVE to use stored procedure due to security issue. In other words if my Access code...
Back
Top Bottom