Search results

A major drawback when using "Forms!frmMa...." is that autocomplete stops to function (Ctrl+Space). Do I possibly have a misconfigured Access installation?

Thanks! Using OnLoad solved the problem. Also thanks for the Forms!-tip

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"...

Solved: There is a component named "Microsoft Forms 2.0 Scrollbar", but my list of compopnents is unpractically large and i'm not very familiar with it yet.

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...

Solved it: Me.row_id.Value where "row_id" is the name of my AutoIncrement PK, returns what I need. Thanks for all help!

I have created my form with the wizard, making it represent a table. The Record Source is the table name in question, so I guess it is bound. Having everything but the "insert" action bound would be nice. Is there a neat way to disable the automatic insert and do it manually instead, using...

DCrake: I beleave your example is pretty much equivalent to my own example (posted in another thread, but reposted here) that I use to illustrate my problem. A relevant difference would be that I have not written any code for the insert; that is done by the From. Dim lpRowIdRecordSet As...

Ok. My motivation for starting a new thread was that the original issue was not really relevant any longer and that I now actually have a quiet different issue. Having two threads would IMHO sort these two issues apart better for people only reading the thread title or people doing searches.

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...

gemma-the-husky: It's kind of annoying. I have previously worked with SQLServer, Oracle, postgres and Firebird/InterBase, so i'm kind of used to a bit more complete toolboxes... Anyhow it seems that i have to use the @@IDENTITY, since the SCOPE_IDENTITY() is not supported by the Access...

As I sated in my first post, @@identity always returns zero (is my code to pick up the value ok?). Second, I dont want to use @@identity, since it seems to have a global scope and might return wrong results if there are multiple simultaneous users. Is there a master-DB or similar where I can...

Thanks for an extremely fast answer! Tried this instead: Dim lpRowIdRecordSet As DAO.recordSet Set lpRowIdRecordSet = CurrentDb.OpenRecordset("SELECT TOP 1 SCOPE_IDENTITY() AS row_id FROM tbl_activities") MsgBox lpRowIdRecordSet.Fields("row_id").Value Still get the 3085...

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...