Consulting

Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 21 to 40 of 50

Thread: Access time help

  1. #21
    hi OBP

    can do anything i/you need to do to it no restrictions atall ,

    Thanks

    Nick

  2. #22
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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.

  3. #23
    Quote Originally Posted by OBP
    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?
    Hi 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

  4. #24
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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?

  5. #25
    Quote Originally Posted by OBP
    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 2007

    Thanks

    Nick

  6. #26
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    What about the WO Ref field where does that come from?

  7. #27
    Quote Originally Posted by OBP
    What about the WO Ref field where does that come from?
    hi OBP it comes from SQL man plan

    Regards

    Nick

  8. #28
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    So is it a Generated Value, can it be in another table and selected?

  9. #29
    Quote Originally Posted by OBP
    So is it a Generated Value, can it be in another table and selected?
    hi OBP,
    yes it can be put on another table and selected

    many thanks

    nick

  10. #30
    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.

  11. #31
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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.

  12. #32
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, this is what the Table Structure now looks like.

    I am working on the Forms now.

  13. #33
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, how big can an Access form be on your Computers?

  14. #34
    Quote Originally Posted by OBP
    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.
    Hi 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.

  15. #35
    Quote Originally Posted by OBP
    Nick, how big can an Access form be on your Computers?
    OBP

    can be full screen i would prefer that

    Nick
    Experience is something you don't get until just after you need it.

  16. #36
    Quote Originally Posted by OBP
    Nick, this is what the Table Structure now looks like.

    I am working on the Forms now.
    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 ,

    Thanks

    Nick
    Experience is something you don't get until just after you need it.

  17. #37
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Keep it in mind for when we get there.
    What size is your screen?

  18. #38
    Quote Originally Posted by OBP
    Keep it in mind for when we get there.
    What size is your screen?
    OBP

    mine is 17" and work is the same , thanks

    Nick

    Experience is something you don't get until just after you need it.

  19. #39
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, I haven't forgotten you I have just been busy on a couple of other databases.

  20. #40
    Quote Originally Posted by OBP
    Nick, I haven't forgotten you I have just been busy on a couple of other databases.
    Hiya OBP

    thats no problem , thank you for all your help

    Nick
    Experience is something you don't get until just after you need it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •