Recent content by AljaC

  1. A

    Change existing table when data format of a field changes

    I've figured it out :). As I predicted I was totally over-complicating things. As this is a new db, I don't have any real data in it. So what I'm going to do is have a number field for InvoiceNumber (it can't be autonumber because the invoices have to be sequentially numbered and begin with 1...
  2. A

    Change existing table when data format of a field changes

    Plog, thank you for pointing that out! I completely missed that :rolleyes:. It’s interesting how the obvious things escape us sometimes ;).
  3. A

    Change existing table when data format of a field changes

    Hi Pat, thank you for your answer! The InvNumber field is not PK, I don’t use text fields as PK. I was thinking, what would be the downside of creating a new Invoices table, renaming the old one and using it as archive? We are talking about roughly 150 records. The db won’t be operational...
  4. A

    Change existing table when data format of a field changes

    Hi, I'm building a database for a small business. I have a table tblInvoices with a field InvoiceNumber. Currently this is Short text, because invoices are “numbered” with a combination of letters and numbers – R07-2017 for example. I’m planning on changing that to a format like 20180007, among...
  5. A

    Živjo

    It means hello in Slovenian :). I'm not a programmer, I'm learning Access step by step while building a db for a small business. You've already helped a ton. Thank you! Alja
See more
Back
Top Bottom