Search results

  1. J

    Unexpected form control behaivour

    Hello! I have a form with a few bound fields representing a record. In the header I have an unbound checkbox (which has no function as of yet). The form has the OnOpen-code below Private Sub Form_Open(Cancel As Integer) MsgBox "Form_Open occured"...
    • jon_s
    • Thread
    • Replies: 7
    • Forum: Forms
  2. J

    How to create a "free" general purpose scollbar in a form?

    Hello! I would like to create a scrollbar in my form. The scrollbar will have nothing to do with window size or component size. I plan to use it for general data (a kind of r/w progress bar in this case). I cant find a scrollbar component on the tool palette. Is there a way to accomplish this...
    • jon_s
    • Thread
    • Replies: 1
    • Forum: Forms
  3. J

    Problem retrieving @@IDENTITY in Form AfterInsert-event

    Hello all! After some initial attempts to use SCOPE_IDENTITY() with Access internal DB-engine, I have realized that Acess does not support this function. So I have to use the @@IDENTITY to get that latest AutoIncrement PK of a table that is updated by a form. Unfortunately, I dont know...
  4. J

    Question Unable to execute scope_identity() in access 2003

    Hello all! I have just created my first access application ever using Access 2003 (also my first VB-experience). In a form i would like to find out which autoincrement-PK result I just had in the "after insert" event. Im trying this: Dim lpRowIdRecordSet As DAO.recordSet Set...
Back
Top Bottom