coolcatkelso
Registered User.
- Local time
- Today, 12:39
- Joined
- Jan 5, 2009
- Messages
- 279
Hiya guys
Access 2007
On my form I have 2 buttons, one creates the workorder by finding the last WorkorderID, the other button sends the field entrys from one form (Quotes) to (Workorders)
In order for this to work the Create Workorder finds the last workorderID and tells me what the "NEW" Number would be, so if the last id was 5 it would enter 6 in my Quote form,, all good.. For the second button to work, I need to enter the "New ID" In my material list so this will copy over to workorder
A pic is attached to show
If you look at the Materials part. you will see something like
Material Qty Unit Price WorkorderID
NEW 1 ?2.99
NEW 5 ?2.99 2
So for me to copy this to a workorder I would need to click on Create Base Workorder (Finds the last WorkorderID) and this is then display in blue at the top of the Quotes form (See pic)
I would then have to enter this newworkorderID = 2 into the materials & labour subform and click on update workorder, and all the info is copied over.
But I'm wondering, if the user has a lot of materials & Labour to add this could annoying to add all those IDs
Is there a way to have this done by a button?
something like
OnClick WorkorderID=Quotes, Quote Materials Subform, copy WorkorderID to WorkorderID
lol you get the drift tho
________
Zoloft lawsuits
Access 2007
On my form I have 2 buttons, one creates the workorder by finding the last WorkorderID, the other button sends the field entrys from one form (Quotes) to (Workorders)
In order for this to work the Create Workorder finds the last workorderID and tells me what the "NEW" Number would be, so if the last id was 5 it would enter 6 in my Quote form,, all good.. For the second button to work, I need to enter the "New ID" In my material list so this will copy over to workorder
A pic is attached to show
If you look at the Materials part. you will see something like
Material Qty Unit Price WorkorderID
NEW 1 ?2.99
NEW 5 ?2.99 2
So for me to copy this to a workorder I would need to click on Create Base Workorder (Finds the last WorkorderID) and this is then display in blue at the top of the Quotes form (See pic)
I would then have to enter this newworkorderID = 2 into the materials & labour subform and click on update workorder, and all the info is copied over.
But I'm wondering, if the user has a lot of materials & Labour to add this could annoying to add all those IDs
Is there a way to have this done by a button?
something like
OnClick WorkorderID=Quotes, Quote Materials Subform, copy WorkorderID to WorkorderID
lol you get the drift tho
________
Zoloft lawsuits
Attachments
Last edited:
