Recent content by Esoteric

Hi guys, I'm trying to create a lotus notes email through vba that contains data from one of my access tables. Since I'd like the data to be displayed in a tabular fashion, I'm trying to format the body of the email in html. How do I achieve this? Some sample code would be greatly appreciated.

They are currently entering the numbers as strings. I need those numbers for calculations so don't want to store them as text. The problem is that for some values they use commas as the decimal separator, and for others they use periods. Seeing as people generally don't like changes, or get...

I did not realize the replace function applies to strings only. In the current system the users are entering the values as text and are able to use either periods or commas when entering decimal numbers. When they switch over to Access, I wanted to still allow them to use both options to...

Format is set to General Number. The field type is Number with field size set to Double.

Have tried both suggestions, but unfortunately the problem persists. Whenever I enter a number that contains a period into my text box and press enter, the period gets removed and the incorrect value is entered into my database (e.g. 1.1 turns into 11 after enter is pressed). The AfterUpdate...

Hi guys, I'm trying to turn any period entered into a certain textfield on my form into a comma (to prevent access from turning 1.1 into 11 for example). I have the on dirty event set to me.fieldname = replace(me.fieldname,".",","). Everything works fine as long as I use the period key on the...