Recent content by gerryp

Now that the error messages have been fixed, there's a problem with the combined PO numbers "P02" ( Exact & I.T. PO) When a new record is entered the 1st part of the number (stores_po) does not increment but the IT PO number does - as per the screenshot below of 2 new records;

Indeed you did Arnel. I looked at the code within Private Sub Form_BeforeInsert(Cancel As Integer) and found the code: lngRecordCount = Nz(DCount("1", "PO"), 0) I changed it to ; lngRecordCount = Nz(DCount("1", "Tbl_POrders"), 0) The error messages have stopped - brilliant

"19" are the last 2 digits of the year. The total yearly records (Purchase Orders) will never exceed 200 and I've been told, at years end, to make a copy of the the database, manually increment the year format for the next year's P.O's and compress it. I'm sure it's possible to automate this...

Down to one error MSG now....

Having done all of the above I get the attached errors ??

Unsure as to which forum this issue should be located, so feel free to move it & Apologies in advance for the lack of proper terminology. I have a simple PO database for our company’s I.T. purchases. At the moment the Tbl_POrdershas PO_No as the primary key field and is set as Auto-number. The...

Many Thanks plog. Ideally I'd rather the first PO of 2018 to be "18IT001" and increment accordingly.

I've a database for managing PO's. I followed the attached to help with pre-defining the PO numbers The PO_number field is an autonumber and the text box property "Format" has "17IT"000. Whenever a new PO number is required it set's each PO number with a preceding value of 17IT000 and will...

To all replies - Seems I've a bit of reading up and figuring stuff out, to do. I'll have a go, but rest assured, I will be back !! Thanks a million

I have a form, PO_InVoice Details-New bound to table TBL_POrders & there’s a sub form Items Ordered, bound to tbl_Order Items Navigating the records via the main form’s record selectors, at the bottom of the form, works flawlessly in that I can scroll to through all PO’s and each related item...

Wasn't aware of issues with navigation forms, but I'll google a fix / alternative for this, when I get a chance. Thanks a million for your help too. Cheeers

BINGO !!!!! This has worked, thanks a million

Afraid that hasn't worked

Done the above, but the cost centre's are been overwritten when you navigate between records