Search results for query: *

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

This is because you probably use a combined recordsource for the form. That won't work. In that case you have to code you're entry to the specific table. grtz Flippertje

If i'm correct you have made a form based on a table. This form holds a calculated field wich tells you if the person filed too late. When late you want to gain more information. Can you tell if that information should be entered by you or that person. Also describe how much information will be...

Did you try coding it? Make a seperate table and place tje ID's in it while the specific ID is in use. Every time a user tries to change a record, the code does a lookup in that table to see if it is under editing. Perhaps this helps... gtrz Flippertje

The listbox is probaly based on a table. Just make a form and place the checkbox in it... I guess it's too simple an answer so i think you meant something else. If so; clarify :))

Hello all, after reading all i could find here about treeviews i decided to ask this: i have two treeviews. They are both populated perfectly. Now i want to drag form treeview1 to treeview2. The problem is that i can't get it to drop the selected text from treeview1 in the right childnode in...