Search results

Hello, I am not new to Access, but I am a VBA and DAO newbei. I am designing a journal database, where I would like my users to be able to create multiple rows in a table from a form with multiselect listboxes. I will try to explain... We help people with legal and economic advices...

I have a text field I need to convert to numbers. There are both empty and non empty fields. I then need to show the numbers like this "1.234" and a "*" in the empty fields. I have tried to convert the fields with Cint, but I get an #Error in the empty fields. Is there any way to solve this...

Now lets see some magic... I have to tables, where if data in one field is in both tables I don't want the row to be shown in my query. I have triede with a IIf sentence, but I can't get it to work. Any ideas??

Hello, I want to remove the first four characters from a field in a query. The data are not always the same length, but it will always be the first four. Example. vmc_ml120e21/p -> ml120e21/p Is that possible and how?? Thanks in advance.