Search results

Ahha, we'll see! And cheers for your help! Hopefully it should work perfectly (:

Okay, I'll try that. :) And yeah, it's for a shop system. Every transaction has to record the current VAT rate for transaction purposes.

Exclusive access isn't a problem! VAT only changes every few years. So something like this? currentdb.TableDefs("myTable").Fields(0).DefaultValue = "NewDefaultValue"

Is there a way to change the field's default value straight off then?

Oh that's absolutely brilliant! Thank you :)

Hi, I'm doing a shop database, and I'm using the default value to store VAT values. Is there a way to change the default value on a number of tables using VBA code or macros? Cheers, Tom.

It's a piano shop, so normally only one piano is sold at a time. And in the stock table, I've put each piano as a separate record, as each one has a unique serial number. Ah cheers, I'll have a go at an update query... Tom.

Hey, I have a bit of a query regarding a database for a shop. Basically, I have 3 tables: one for customers, one for stock, and one for all the transactions. Each product on the stock table has its own unique serial number. There is also a tickbox field on the stock table, which indicated...