Recent content by Flippertje

It WAS staring me in the face.... pfff... better stop coding today... The code was bigger than i reported here. This morning i put an test indexnr like Indexnr=5656866 in the code... forgot to delete it. It caused the form overwrite the current record an create a duplicate record... Don't know...

Me.recordset.Requery: an effort to get the recordset to update... which afterwards looks kind of silly .... i deleted the entry Me.recordset.Addnew: The addnew is just a trick to get the form to be blank again. So an update event is not needed. I think what's happening is that: the addnew...

It's absolutely staring me in the face... but i'm clueless (perhaps not a good day to be coding??) I receive forms with a number, emailadress and an amount. I enter this data in a table 'Tab_Forms' (fields: Indexnr, Emailadress, Amount). The field Indexnr is indexed and no duplicates are...

It's driving me crazy! Please help me out? I'm not that well known in this script... I'm trying to send an email by lotus notes. My code constantly crashes with a type mismatch at the line 'set session= etc etc dim db as notesdatabase dim session as new notessession dim doc as notesdocument...

Hi all, i have SAP Fi and want to import data to MS Access. When i take a peek in the references to register an ocx or dll, i see a list of about 50 library's. I'm clueless on determening which to choose. Has any of you ever tried this before? - which ocx and or dll's did you use? - what code...

Hi all, i have SAP Fi and want to import data to MS Access. When i take a peek in the references to register an ocx or dll, i see a list of about 50 library's. I'm clueless on determening which to choose. Has any of you ever tried this before? - which ocx and or dll's did you use? - what code...

Hi all, i have SAP Fi and want to import data to MS Access. When i take a peek in the references to register an ocx or dll, i see a list of about 50 library's. I'm clueless on determening which to choose. Has any of you ever tried this before? - which ocx and or dll's did you use? - what code...

Hello all, i've been roaming this site and Google... but i can't seem to find the solution. I'm looking fopr a way to get all the groups in active directory in VBA. I have succsesfully done this with the users. But is still have to put in the specific Groupname: set grp=GetoBject ("WinNT://" &...

Hello all, i'm trying to strip a field of its numbers. My table contains fields like TV1 TV2 TV3 TV TV200 IPOD12 In a query i'm tying to lose the numbers so that only text remains. Anyone? Many thanks! Scoobs

MajP, you're approach worked like a charm!! Many thanks for you're help on the subject. I have a better understanding of the treeview object because of you! Flippertje!

Thank you very much for the answer! I have to park it till after i'm back. But reading this gives me hope!!! The table is build like this: store - computer - brand - type - model I've build a union query wich creates a nodename column and a groupname column. In my approach there is no way of...

Thank you for answering! I''m not that familair with the treeview... I think you're answer won't solve the problem... What i'm after: example Dixons |-Computers | |-Compaq | | |-Pentium | | | |- all kinds of models | | |-Dualcore | | | |- all...

I've build a table where i have the following contents: Groupname Nodename Test Test Dixons Test Dynabite Dixons Computers Dixons Software Dixons Else Dynabite Computers Dynabite Software Dynabite Else Both computerstores (Dixons and...

I've build a table where i have the following contents: Groupname Nodename Test Test Dixons Test Dynabite Dixons Computers Dixons Software Dixons Else Dynabite Computers Dynabite Software Dynabite Else Both computerstores (Dixons and...

What you want to do is to build a code; leave the calculatedfiled for what it is. It's for show. 1. Create a table 'Tab_ExtraInfo' with you're seven fields in it but also a Autonumbering Id_Field and a field wich holds the Id number of the appropiate Audit. 2. create a Subform which you hide...