Recent content by kharder

This will do the trick and will definitely get me started. Thank you... :)

Thank you... I will take a look at it.

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

Thank you. That does the job with the symbol "*". But I want the numbers stored to be shown, not like "1025" but like "1.025". Is that possibel in Ac97??

My solution works in 2003 but does anybody know how to get it to work in 97?

I solved the problem with three IIf sentenses.. y: IIf(IsNull([x]);0;[x]) z: IIf([y]="0";"*";[y]) result: IIf([z]="*";"*";FormatNumber([z];0)) Is there any way to create one sentense of this??

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

I solved the problem almoste after I posted my question in the moste simpel way. I don't know why I always have to try to do things more complicated than they are. I took both fields and added them to the same query and tada the problem was solved. By the way.. Thank you for the fast reply Neil.

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

Ok, now I see whats wrong. Thank you.

I solved the problem with this Mid([MODEL];5;50). There isn't any strings there are over 12 char. long. But I am still interestet in a better solution, because I have to use it later in the same database.

Nope, that didn't do the trick. Any other ideas?? I tryed to use it like this: right([MODEL],len([MODEL])-4) is that right?? Thanks,

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.