Recent content by whistler1

i have been programming with VB6 for a while, now i have just started programming with VB 2005 Express. for the program i'm making, i have to use a access database however, i can't find how to add new records in the database or how to update one. i have linked the program with the database and i...

thx problem solved a star for zemp

thx that worked a star fot zemp

i'm on a pc at my work, my boss has the original cd, but he took it home with him, and has't brought it back, he installed it on my pc because he knew about my knowledge of VB that's also why he asked me to finish his program, because he couldn't go any further with it so it ain't no pirate...

i really need to fix this problem this is the last problem i see, and i want it done today so can somebody help me? the date is coming from an excel-sheet

I think there is something wrong with Visual Basic format-function doesn't work either strange thing is that formatnumber does work but i can't reinstal VB because i don't have the progrm here its from my boss and he has the cd at home and it could take a while before he remembers to bring it...

ok, managed to solve one problem there was a "/" that had to go did that with a replace but now i have to be able to put the year (currently at the back) to the front and the day (currently at the begin) to the back is this possible to do this without the left and right function? is so, how?

could somone help me to find the problem everytime I use the left, right or mid function I get an error: 'Can't find project or library' does anyone know what the problem could be? here's the code I use jj = Mid(dat, 7, 4) mm = Mid(dat, 4, 2) dd = Mid(dat, 1, 2) datum2 = dat(jj & mm & dd) it...

thanks that worked a star for BiggerBrother and RoyVidar

this is what comes out: INSERT INTO dagverkoop3 (datum, berekend, bloemen, planten, potterie, btw6, btw21, maatstaf6, maatstaf21 , bloemstukken, droogbloemen, kaartjes, teleflor, terug, leeggoed, groenten, fruit, voorgesneden, drank, gedroogd, salades, allerlei,korting) Values (20040401...

I'm using an access database, everything is in numbers if the comma as decimal separator is the problem, i'm going to have much more problems i'm building this program to put the data in another program (for the accountancy), but this needs the comma as decimal separator, so I can't change that

if I do this, I get nother error: 'number of queryvalues and targetfields does not match'

i looked for a long time but i can't find the problem this is the part of my code where the problems are: sql = "INSERT INTO dagverkoop3 (datum, berekend, bloemen, planten, potterie, btw6, btw21, maatstaf6, maatstaf21 , bloemstukken, droogbloemen, kaartjes, teleflor, terug, leeggoed...