Search results

I have a continuous form that the user can enter a number of items. he does this by selecting each item from a drop down box. the drop down box can contain quite a few items for each customer. doing it this way it is slow and laborious. I'd like to display on separate form all of the available...

Are the telepathic interfaces expensive? I think it may work :) I'll go with the stuff 'em approach then!!

possibly..... but presume you have to code it before those changes? i dunno, it's all very weird to me

once i've cracked the back of this

OK that appears to work at first simplified go!! Still don't understand why access can't handle both formats So what can I do about input. If spanish user puts in 2,35 on form all ok but if ex pat brit puts in 2.35 it gets translated to 235,00!

Thanks for your time and effort but it looks like Mark_ 's reference to arnelp solution works on the spanish side. Going go test on the UK side now.

Lol, I'll give that a miss too! OK i'll take a look

Forms!formname.control diesn't work No idea what you're driving at about other table. I'm trying to store the value in another table anyway

So where exactly does this go? I was think in the front as this is more painful than a painful thing!

OK was also thinking along that idea but I'm using this all over the place (controls holding a decimal) so it's going to be a pain the the you know what. Surely access can be used in multiple regions without this. The field itself is coming off the table in that format

I saw that too but I've got fields using decimal points all over the place so this would be painful to implement

ok so UPDATE sales SET with sumprice = forms!salesitem.sumprice? Can I use formname as I'm using instances so don't know wht the form is called! Anyway I'll give it ago

I've sort of done that already. I've got a form that are the sales items. On the spanish network all the figures are n,nn. If I try and out n.nn in the price I get it translated to nnn,00 so I HAVE to put n,nn. Looking at the table it is stored as n,nn. When I close the form I update a sales...

...and if i change it to 2.35 it works but it is then held as 2,35 and displayed as 2,35 and if i update it it fails because it's 2,35

Yes I am an no it doesn't

So if I look at the table on my laptop I can see data held as nn.nnn If I copy the table to the Spanish network it looks like nn,nnn so why can't I update to number = nn,nnn Access can obviously differentiate between regions until I update. I could inderstand if i was trying to update spanish...

see reply to mapj

Is there anyway to do this so it works on my laptop and in Spanish network without doing that. If I change it on their network then other systems may not work. Be good if . and , were treated the same in access.

i have an update in some VBA that works perfectly for me but when testing on a spanish network i get a syntax error(3144). The only thing that looks different is updating a number In the UK version I get number = me.number where me.number is 2.35 In the Spanish version I get number = me.number...

Right I've got a wee database I've got what I think is your code in it and also mine There's a taxt box in the header defaulted to "2" which runs your code Change to "1" runs mine - best change the default in design mode to see happens when first loaded Yours shows all discontinued items in the...