Search results for query: *

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

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

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

I'm trying to build a menu with a button that does: 1. select a specific printer (PDFWriter) 2. print a specific report 3. set the printer back to the original printer Is this possible? I've trying for days and can't get it to work! I've been close (i think) by trying to point the menubutton...

Hi all ! my database crashed today. It had a specific MDW file. The mdw file still works but i'm totally blank on how to see to it the database only uses THAT specific MDW file. Other users that use the normal system.mdw shouldnt be able to open it. I recall something like securing the database...

Hi all, i'm trying to find the first capital letter is a string whilst being in the querybuilder. sinterKlaas should result in 7 So i mean something like a Instr functon but then for capital letters... Anyone? Many thanks! grtz Flippertje

Hello all, after many hours of reading about treeviews in TekTips i finally give up and post a question. I have a form with two treeviews (Treeview0 and Treeview2). Both trees are populated by (difficult) queries. I have build a table in which i have two fields Id_Group and Id_Child. In this...

Hello all, after many hours of reading about treeviews in TekTips i finally give up and post a question. I have a form with two treeviews (Treeview0 and Treeview2). Both trees are populated by (difficult) queries. I have build a table in which i have two fields Id_Group and Id_Child. In this...

Hello all, i have made a database with a new mdw file for security. Since i have about 20 databases of which 1 is secured i like to know how to automatically return to the standard system.mdw. To start my secured database i use the commandline option. But how can i return to system.mdw once i...

Hello all, i'm trying to import a textfile (commaseperated). The first column contains numbers with 12 digits (eg 105001514536) When i import these numbers the are transformed to eg 1,050015E+11 When i use the standard format the numbers are rounded to 105.001.500.000 Does anyone know how to...

In reference to thread702-1098328 where i had a problem with conditional formatting. I don't know if this is posted elsewhere but i solved this by creating a second textbox (hidden) in which the calculating is done. The source of the textbox with the conditional formatting is the contents of...

Does anyone knwo how to make an inner join in VBA between two recordsets? I have to recordsets (rst1 and rst2). rst1 Field1: Id_Test Field2: Description rst2 Field1: Id_Test rst2 is a grouped query on a table with lots of Id_Test. However not all Id_Test in rst2 are in rst1. I'm trying to...

Hello all, i have the following problem to solve. I've made a db with agreements. An agreement can be either: 1. not met and therefore too late 2. coming up within 10 days 3. not yet due I'm trying to find an indicator that consists of a number of dots (depending on the amount of...