The first thing I would suggest is in "tblJobDetails",
1) delete the field "JobNumber",
2) then change "JobNextNumber" from Text to a number (Integer) type field.
You are using the name "JobNumber"in a query, but it is not the field in the table. It is a calculation in a query.
In the query "qryJobDetails", you have a column "JobNumber: [tblJobDetails.JobPrefix] & "" & [tblJobDetails.JobNextNumber]".
BTW, in the form "EditJobDetails", the control that is supposed to display the job number is actually showing "JobNoID_PK"! This should be changed to "JobNumber" to show the job prefix ("J") concatenated to the "JobNextNumber" field..
Same thing for "tblOrderNumbers". Delete the field "OrderNumber" and change the field type for "OrderNextNumber" from Text to Number - Integer.
---------------------------------------------------------
Another thing to be aware of...
In form "CabinetTech", you have a button "cmdCloseCabtech", with code
The "acSaveYes" does not do what you think it does. "acSaveYes" is for saving changes to the DESIGN of the form, NOT the form data.Code:Private Sub cmdCloseCabtech_Click() DoCmd.Close acForm, "CabinetTech", acSaveYes DoCmd.Close acForm, "LoginForm", acSaveYes DoCmd.OpenForm "LoginForm" End Sub
The form data is automatically saved when the form closes or you move to another record.
So the "acSaveYes" can and should be deleted from the DoCmd statement.
I actually was under the impression that I could only use a column in a query if was in a tbl.... so i should use an unbound field to get my Number J2365?The first thing I would suggest is in "tblJobDetails",
1) delete the field "JobNumber",
2) then change "JobNextNumber" from Text to a number (Integer) type field.
You are using the name "JobNumber"in a query, but it is not the field in the table. It is a calculation in a query.
In the query "qryJobDetails", you have a column "JobNumber: [tblJobDetails.JobPrefix] & "" & [tblJobDetails.JobNextNumber]".
Yes there might be a few like that, this is some house cleaning i still need to do... i changed things around with everyones advice going to Auto generated next numbers in lieu of using the Primary Key Numbers
I will get rid of them all.Same thing for "tblOrderNumbers". Delete the field "OrderNumber" and change the field type for "OrderNextNumber" from Text to Number - Integer.
---------------------------------------------------------
Another thing to be aware of...
In form "CabinetTech", you have a button "cmdCloseCabtech", with code
The "acSaveYes" does not do what you think it does. "acSaveYes" is for saving changes to the DESIGN of the form, NOT the form data.Code:Private Sub cmdCloseCabtech_Click() DoCmd.Close acForm, "CabinetTech", acSaveYes DoCmd.Close acForm, "LoginForm", acSaveYes DoCmd.OpenForm "LoginForm" End Sub
The form data is automatically saved when the form closes or you move to another record.
So the "acSaveYes" can and should be deleted from the DoCmd statement.
what did you think of the way orders are produced.. have i made it complicated?