Recent content by DrJ

Has anyone an idea how to delete certain numbers/letters from a string? So lets say I have a string "05605080" And I want all the "0" out of it in a way that this string is left: "5658" All help is appriciated. Rob

that's the trick :) Thank a lot Jon. Rob

I have the following criteria in my query: Between [Forms]![frmMenu]![Sub]![van] And [Forms]![frmMenu]![Sub]![tot] This works fine, but when the boxes [van] and [tot] contain no data, the query shows no results. I want the query to show all records if these boxes are empty. Does anyone has...

What if you put the data you don't want get exported/imported in an other database. You could then protect the new database and link it to the original db. That way you still have to enter a password when opening the database. Does anyone know a way in which you don't link the table, but get...

I know how to disable everything in access, but when I'm in excel and try to import data from my database, that is possible. So I want to disable importing. Sorry if I was not clear enough. Rob