Search results

This is what I had in mind but using the original table which would screw up if more than one user was creating an invoice at the same time. In that scenario when temp tables are created are they specific to the user and won't interfere with another user doing the same at same time?

So I create a temp table with the details of the tariff group display that and then copy the selected items to the order?

Not sure you're sure of what I want! There are a set of tariff groups that contain anywhere between 10 and 90 entries. Each customer has a tariff group assigned to him. A tariff group can have more than 1 customer. All the tariff groups are held on one table. There is a default number of each...

Also....the items are split into different tariffs for different customers. Each tariff set has a number of items. The tariff sets are held on one table. I've just set up a quick listbox to play around with. I did this using form design and adding a list box onto the form and going through the...

I've started to look at this but not sure if will meet what I want to do. The user will select a number of items. Looks like this is fairly easy to do with the multi select list box. The other thing he'll want to to do is add a number in as well. Now I know he can go and do that after but his...

Excellent thank you

Never used one but looks like pbaldy has pointed me in the right direction. Thanks

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