A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is a Flex Grid What I need?



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 08:33 PM posted to microsoft.public.access
Jacinda
external usenet poster
 
Posts: 41
Default 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
  #2  
Old April 21st, 2010, 09:08 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Is a Flex Grid What I need?

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



"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



  #3  
Old April 21st, 2010, 09:17 PM posted to microsoft.public.access
Stop$teve
external usenet poster
 
Posts: 76
Default 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  
Old April 21st, 2010, 09:21 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old April 21st, 2010, 09:57 PM posted to microsoft.public.access
Beetle
external usenet poster
 
Posts: 1,254
Default 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  
Old April 22nd, 2010, 02:57 AM posted to microsoft.public.access
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old April 22nd, 2010, 04:26 PM posted to microsoft.public.access
Jacinda
external usenet poster
 
Posts: 41
Default 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  
Old April 22nd, 2010, 04:56 PM posted to microsoft.public.access
Peter Hibbs
external usenet poster
 
Posts: 871
Default 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  
Old April 22nd, 2010, 05:42 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old April 22nd, 2010, 08:30 PM posted to microsoft.public.access
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.