Recent content by djemmers

hi macneiltan sorry to dissapoint you, but I don't remember what app this was about. I remember I got it working but other then that... blank too long ago, sorry

works great tnx!

tnx for the quick reply but I don't think ik will work: teLezenOp<=#" & Format(Date(),"MM/DD/YYYY") because this will give EU<=US so will give wrong results. so it should be something like this? Format(teLezenOp,"MM/DD/YYYY")<=#" & Format(Date(),"MM/DD/YYYY") problem is that I can't check it...

Hello my sql/access friends I have a table with a date/time field named “teLezenOp” and I use the following line in VBA: SELECT * FROM tblBericht WHERE (teLezenOp<=#" & MediumDate(Now, Now) & "# or teLezenOp is Null ) ORDER BY datum (I use the european notation dd-mm-yyyy) Here is what goes...

in english now sorry forgot this is an english forum here is the translation hi I just made a DB-app with VB and it works nicely on all pc's, but not on one on that pc I get error 3021 "no record". And on the other pc's (with the same app and I do exact the same) I don't get that error. the pc...

tnx a lot ! djemmers

hallo heb net een database-applicatie gemaakt met VB en hij werkt perfect op alle pc's! maar op 1tje niet. daar krijg ik bij het laden van een nieuw formulier error 3021 terwijl ik dat op andere pc's (waar dezelfde app staat en ik exact hetzelfde doe) niet krijg. op deze pc staat win me. waar...

well, it would (I thought of that too) But , new entries come in every day and is not a really ellagant sollution, I just thought there should be an easy way to fix it in access, something like "if valye = 30/12/1899 put null" but I don't know where or how to put that in access. tnx for the...

hi all, I import the type of driver licence (a b or c) and date of driver license into an access table through an application that I didn't write and don't know how to adjust.. a b c works perfect BUT date doesn't when I don't fill in a date it gives 30/12/1899. this is verry confusing and I...