Thanks for the reply. Understood.... Trouble is I have many templates, forms, queries, reports etc setup in open office. would this all be completely and easily transferable?

I've just setup a Ubunto 20.04 WAMP system in a Proxmox VM. I have installed OpenOffice 4.1.7 with the relevant MySQL JBDC connector to allow Base to be used as a front end for MySQL server. The system works well with no connection problems so far other than: A user (OrderSys) is setup with access a...

You are correct - there was a problem with the Mid usage which has been fixed. My problem for some reason was that when the macro was placed in a spreadsheet with two cell references as the arguments, if this was copied to another cell, the references would not update. (ie if the cell refs were chkg...

Sorted references do update

Ok here's the code. Not tidied. I want to input two cells as the arguments and be able to copy these through the spreadsheet with the references being updated. ie relative referencing. Thanks. public Function chkgen$(Optional code% ,Optional cost#) 'Parameters : Value/reference to plu number, and Va...

I'm new to this. I have a macro that I wanted to give two cell reference to that would then copy and change relative with the copy. At present they represent an absolute value. What's the best way to deal with this?

Thanks

Sorted - Silly I missed that - Thank you

Any ideas please. I have coded a macro to take two number cells from Calc operations are performed on this data for a barcode number with checksum etc. the number is converted to text to aid manipulation. Everything works fine except that the second Str() operation below rounds the cost to 147.00. i...