Search results

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

I'm now using the date Yes I can but remember it's not really an order. It'll take me some time to cut it down just to that form so maybe early next week if you don't mind

I had thought of displaying the description separately so hiding combo is a good idea.

I told you dates do my head in! I need to go into a darkened room and read this over a few times. Right so my combo uses the item id to do a look up. The item id is from the order table. I use it to display the correct description for the item and too allow the user to change it to another it...

Thanks for your patience!! And thanks to Minty for chirping in. I think I'm getting there but I'm not sure I've properly explained what I'm really after which has probably led to the confusion in my head. Maybe if I use an example. In the following the prefix combo shows the combo box. The...

So for a new record what value do you have in Me.TransactionDate. My equivalent field is NULL and it's falling over on this. I'm sure I'm getting my dates the wrong way round but I've checked this over and over. I'm sure I'll get there

I'm looking at it at the moment. I hate dealing with dates. To think I did wave theory 40 years ago at college and can't get my head round 2 dates! If you were thinking about this on your way back from holiday then I'm not giving up!

Thanks if you see my response to MajP I'm thinking that this is a long winded exercise as I firstly have to work out what changes I've made over the past week or 2. I should have probably kept track but haven't. Reading yours I get the sense I'm over complicating things again. Can I create the...

OK thanks. The problem I have at the moment is that as I've been developing I've made changes to several tables over the the past week or so. I can see what tables I've changed by sorting the objects into modified date order but not sure what changes I've made. I've also changed relationships...

I've been making some changing to tables in development, adding and deleting fields changing names etc etc. I now want to copy these into the user test environment. How do I do this. I don't want to lose the data just copy the table definition if you like. I tried using the import database and...

I tried this and I got blanks in the history. I must have messed the dates up so will look again as I like this method.

Yes I know which is effectively a yes/no box isn't it? IS orderdate <= datediscontinued is either a yes o a no? I think I'm missing the point if this works.

I could't get CJ_London's method to work probably because I din't fully appreciate what he was trying to tell me. To me it was a more flexible meth using a date to using a yes/no field but it was always going to end in does it appear on the list or not. Unfortunately if it was if not then the...

OK this sort of works in that for new records the item that has been discontinued is no longer in the list but for historic items it has to be otherwise it gets displayed as a blank if present historically. Which means that the user will see said discontinued item if if he wants to change one of...