hi OBP
can do anything i/you need to do to it no restrictions atall ,
Thanks
Nick
hi OBP
can do anything i/you need to do to it no restrictions atall ,
Thanks
Nick
Nick, I have created the StatusLevel Table as well.
I am moving on to the Forms now.
What data do you need to see form tblSQL for what you want to do?
Do you have a separate Customer details Table?
Do the Area & Delivery Terms go with the Order or with the Customer?
Last edited by OBP; 06-29-2009 at 04:59 AM.
Hi OBPOriginally Posted by OBP
Area and Del terms go with Order, Op comment and OUT HT are just comment cols Seq will just be order they are scheduled,
[vba]Seq Roll Customer Man Month Wk No Mat CW No FIN WGHT Operation Comment OUT HT Est Hours[/vba]
Hope this helps
And Many Thanks for your help OBP
Nick
Nick, have a look at this version, I have split out a lot of the tblSQL fields into their own tables as I think they should be.
I think that WO Ref should also be in it's own table but as I don't know where it comes from I am not sure.
Is the part in the VBA Window the fields that you need?
Can the SQL database be set up like this?
Hi OBP yes VBA is the feilds req, i cant open this in work as we have off 2000 in here till friday when we will get 2007Originally Posted by OBP
Thanks
Nick
What about the WO Ref field where does that come from?
hi OBP it comes from SQL man planOriginally Posted by OBP
Regards
Nick
So is it a Generated Value, can it be in another table and selected?
hi OBP,Originally Posted by OBP
yes it can be put on another table and selected
many thanks
nick
Hi OBP , When i get my updated SQL man plan , can i just import into same table , also if i had a BOM table with FN , Part Desc , Per Roll is there a way in to enable once it hits milling stage to give me a list or report of BOM reqd, and to keep record so it dosent get ordered twice
Many Thanks
Nick
Experience is something you don't get until just after you need it.
Nick, no you won't be able to Import it directly, how often do you get a new one?
We can build in the Milling check.
Last edited by OBP; 07-01-2009 at 09:17 AM.
Nick, this is what the Table Structure now looks like.
I am working on the Forms now.
Nick, how big can an Access form be on your Computers?
Hi OBPOriginally Posted by OBP
at moment it is every cpl days , but in future when they sort out security on SQL servers i hope to be able to link to it or similarso we have live data,
thats brilliant if we can build in Milling check , basically if any roll hits milling and has a BOM then print or anything list or form of what we require BOM wise at momen i have table in ACCESS that i pull from manually when i know what is going through milling on a daily basis , can this milling check also record whatever has been ordered and date so it dosent get ordered twice .
i really appreciate all your help on this OBP , i have one other question in DB did you see table named tblMachCap i have restrictions on what can go in each machine size wise is there anyway of also having msgbox or anything similar if we try and do a roll thats to big or too heavy to just warn .
Thanks again
Nick
Experience is something you don't get until just after you need it.
OBPOriginally Posted by OBP
can be full screen i would prefer that
Nick
Experience is something you don't get until just after you need it.
OBP that looks great thanks , now im thinking if we are working on in and out times then most machines are diffrent shifted , can we work around this somehow ,Originally Posted by OBP
Thanks
Nick
Experience is something you don't get until just after you need it.
Keep it in mind for when we get there.
What size is your screen?
OBPOriginally Posted by OBP
mine is 17" and work is the same , thanks
Nick
Experience is something you don't get until just after you need it.
Nick, I haven't forgotten you I have just been busy on a couple of other databases.
Hiya OBPOriginally Posted by OBP
thats no problem , thank you for all your help
Nick
Experience is something you don't get until just after you need it.