I've taken a week holiday from work to try and get this DB working 100%
Stuck on two issues that I'm not having too much luck with
I need to have a button that will "copy" one form to another
The form in question is Quotes & Workorders
Scenario is -
Employee creates a quote on the system. Quote is accepted by the customer and then a workorder is created. Rather than the employee having to re-enter all the details, I want him to open the quotes form again and click a button that will create the workorder.
Qoutes contains a few fields
AND has a subform to select the materials for the job
Linked field is QuoteID on thesubform
Workorders has pretty much the same
AND a subform for Materials, however, the subform on this one is
linked by WORKORDERID
Can it be done?
I have tried INSERT INTO commands with VBA, but having no joy
Not the best at DBs yet,
Looking for someone to have a look at the DB and see if this can be done, and either help me do it or allow them to do it for me. Would rathe do it myself tho
The other thing I'm looking for is about calculated fields, but will go into that after this one
I'd suggest having code behind the form run an append query which you'd already have written that uses a form field as its criteria.
Example criteria for an ID field:
And to create an append query you would get into design mode and choose your original table and pull each of the fields and include the above criteria.
Then in the menu at the top do Query | Append Query and then it will ask which table you want to append to...
And my 2nd suggestion would be that instead of doing all the above simply have a yes/no field called something like IsWorkorder in your original table and not have a 2nd table at all - and not storing separate copies of data is known as data normalization.