If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is a Flex Grid What I need?
I am looking to set up a schedule for my production team so that they can see
all of their open orders, what machine and or operator is working on them, the material used, the qty needed for the order and the due date. I really would like this to be a dynamic form where they can tweak dates or move around the orders to move in a rush order or move back an order etc... dates and times are changing all the time, and I'd like my production team to have a screen to view each machine and the orders assigned to that machine. In the past I have looked at the flex grid control (can't get it to work in 07 software- working on that issue). But I do think this may be something that would work. If the flex grid is what I need then -How does it work exactly? If not - what would you suggest. -- -Jacinda |
#3
|
|||
|
|||
Is a Flex Grid What I need?
"Steve" schreef in bericht ... Hello Jacinda, I have a calendar form and a calendar report I could implement in your database to do this for you. The calendar looks like a page from a wall calendar. The year and month are selectable. Each machine would be selectable and you could display the due dates of all orders for the machine in the selected year and month. You could click on any order and popup a form displaying the list of materials and quantity needed. You could also program the calendar to be able to change the date of an existing order or add a rush order. There would be a small fee to implement the calendar form and calendar report for you. Send me your email address and I will send you a screen shot of the calendar. Steve Holy crap !! Did you even create that form and report yourself ??? -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!) Arno R |
#4
|
|||
|
|||
Is a Flex Grid What I need?
The FlexGrid is a VB6 (or earlier) object which isn't licensed to work from
Access. That may be your problem in Access 2007. If you install it with a VB 6 program, it is then licensed. There are other excellent (but not free) grids as well. One I've used is T-List: http://www.bennet-tec.com/btproducts/tlist/tlist.htm Look around. There are plenty of others out there. The common Controls Replacement projects hay have one as well: http://ccrp.mvps.org/ -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Jacinda" wrote in message ... I am looking to set up a schedule for my production team so that they can see all of their open orders, what machine and or operator is working on them, the material used, the qty needed for the order and the due date. I really would like this to be a dynamic form where they can tweak dates or move around the orders to move in a rush order or move back an order etc... dates and times are changing all the time, and I'd like my production team to have a screen to view each machine and the orders assigned to that machine. In the past I have looked at the flex grid control (can't get it to work in 07 software- working on that issue). But I do think this may be something that would work. If the flex grid is what I need then -How does it work exactly? If not - what would you suggest. -- -Jacinda |
#5
|
|||
|
|||
Is a Flex Grid What I need?
Please ignore Steve. He is a troll who chooses to ignore the
rules of etiquette around here and fish for work. The type of calendar he is describing is available for free on the web, so there would be no reason to pay him for it even if it would be the solution to your problem (which may or may not be the case). If you want to learn more abouth flex grids, you can download a FREE sample db from this link; http://www.rogersaccesslibrary.com/f..._topic511.html -- _________ Sean Bailey "Jacinda" wrote: I am looking to set up a schedule for my production team so that they can see all of their open orders, what machine and or operator is working on them, the material used, the qty needed for the order and the due date. I really would like this to be a dynamic form where they can tweak dates or move around the orders to move in a rush order or move back an order etc... dates and times are changing all the time, and I'd like my production team to have a screen to view each machine and the orders assigned to that machine. In the past I have looked at the flex grid control (can't get it to work in 07 software- working on that issue). But I do think this may be something that would work. If the flex grid is what I need then -How does it work exactly? If not - what would you suggest. -- -Jacinda |
#6
|
|||
|
|||
Is a Flex Grid What I need?
"Steve" wrote in message
... I have a calendar form and a calendar report I could implement in your database to do this for you. The calendar looks like a page from a wall calendar. The year and month are selectable. Each machine would be selectable and you could display the due dates of all orders for the machine in the selected year and month. You could click on any order and popup a form displaying the list of materials and quantity needed. You could also program the calendar to be able to change the date of an existing order or add a rush order. There would be a small fee to implement the calendar form and calendar report for you. Send me your email address and I will send you a screen shot of the calendar. Steve Stevie, so whose calendar are you trrying to flog? Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP |
#7
|
|||
|
|||
Is a Flex Grid What I need?
Thank you guys... and Steve, I am interested in free advise/help... not being
taken for a ride.... but nice try. I do have the flex grid demo downloaded, and I have seen it in action when I had the 2003 software but now that I have 2007 I can't even get the demo to run.... So really you all are saying that a flex grid would work best for what I want? or is there something else I could use in lieu of the flex grid? -- -Jacinda "Beetle" wrote: Please ignore Steve. He is a troll who chooses to ignore the rules of etiquette around here and fish for work. The type of calendar he is describing is available for free on the web, so there would be no reason to pay him for it even if it would be the solution to your problem (which may or may not be the case). If you want to learn more abouth flex grids, you can download a FREE sample db from this link; http://www.rogersaccesslibrary.com/f..._topic511.html -- _________ Sean Bailey "Jacinda" wrote: I am looking to set up a schedule for my production team so that they can see all of their open orders, what machine and or operator is working on them, the material used, the qty needed for the order and the due date. I really would like this to be a dynamic form where they can tweak dates or move around the orders to move in a rush order or move back an order etc... dates and times are changing all the time, and I'd like my production team to have a screen to view each machine and the orders assigned to that machine. In the past I have looked at the flex grid control (can't get it to work in 07 software- working on that issue). But I do think this may be something that would work. If the flex grid is what I need then -How does it work exactly? If not - what would you suggest. -- -Jacinda |
#8
|
|||
|
|||
Is a Flex Grid What I need?
Jacinda,
Of course, a FlexGrid control can display your data but it sounds to me as though you could do what you want with standard Access controls such as List boxes, Combo boxes, Continuous subforms, etc. I suppose it depends on what format you want to display the data, the Flex Grid control is ideal for displaying a Many to Many table format but if you are just displaying lists of data then a List box would do. Regarding the Flex Grid Demo, this does work in Access 2007 (I have just tried it) but you need to make sure that you have the latest version of the control and, as you are using A2007, you need to make sure the folder in which it is located is a 'trusted' location. If those two conditions are correct then perhaps you could let us know what exactly does not work when you run the demo program. Peter Hibbs. On Thu, 22 Apr 2010 08:26:01 -0700, Jacinda wrote: Thank you guys... and Steve, I am interested in free advise/help... not being taken for a ride.... but nice try. I do have the flex grid demo downloaded, and I have seen it in action when I had the 2003 software but now that I have 2007 I can't even get the demo to run.... So really you all are saying that a flex grid would work best for what I want? or is there something else I could use in lieu of the flex grid? |
#9
|
|||
|
|||
Is a Flex Grid What I need?
The flexgrid won't work in 2007. My calendar form and calendar report will
and can be set up to do what you want. See if you get any help from visio john or arno r. Steve "Jacinda" wrote in message news Thank you guys... and Steve, I am interested in free advise/help... not being taken for a ride.... but nice try. I do have the flex grid demo downloaded, and I have seen it in action when I had the 2003 software but now that I have 2007 I can't even get the demo to run.... So really you all are saying that a flex grid would work best for what I want? or is there something else I could use in lieu of the flex grid? -- -Jacinda "Beetle" wrote: Please ignore Steve. He is a troll who chooses to ignore the rules of etiquette around here and fish for work. The type of calendar he is describing is available for free on the web, so there would be no reason to pay him for it even if it would be the solution to your problem (which may or may not be the case). If you want to learn more abouth flex grids, you can download a FREE sample db from this link; http://www.rogersaccesslibrary.com/f..._topic511.html -- _________ Sean Bailey "Jacinda" wrote: I am looking to set up a schedule for my production team so that they can see all of their open orders, what machine and or operator is working on them, the material used, the qty needed for the order and the due date. I really would like this to be a dynamic form where they can tweak dates or move around the orders to move in a rush order or move back an order etc... dates and times are changing all the time, and I'd like my production team to have a screen to view each machine and the orders assigned to that machine. In the past I have looked at the flex grid control (can't get it to work in 07 software- working on that issue). But I do think this may be something that would work. If the flex grid is what I need then -How does it work exactly? If not - what would you suggest. -- -Jacinda |
#10
|
|||
|
|||
Is a Flex Grid What I need?
"Steve" wrote in message
... The flexgrid won't work in 2007. My calendar form and calendar report will and can be set up to do what you want. See if you get any help from visio john or arno r. Steve Warning posts about con artists like you is doing the OP a BIG favour. .... and the help we provide is FREE. John... Visio MVP |
|
Thread Tools | |
Display Modes | |
|
|