Timeline Control?

[KRose]

I am looking for a control that would look like a timeline (12 hours)
which would allow the user to click at a particular location on the
timeline, then allow characteristics to be associated with that point.


Free or For Profit either one.


The idea is I am developing an activity tracking system for a
manufacturing environment where they want to track activities that are
occuring throughout a shift. Activities have start and stop times and
have characteristics.


I would like to modify/edit the times if they make a mistake (my vision
is to be able to slide the points on the timeline thus adjusting the
start and stop times on the fly).


If anyone has any other ideas on UI development, I would like to hear
them.


Thanks in advance,
Kevin

--

 

[Rick Brandt]

KRose wrote:
[snip]

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html#why

 

[KRose]

KRose wrote:
[snip]

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html#why

Thank you for the information. I apologize, and will take this into
consideration in the future. It is my sincerest intent to exist in
harmony, assisting where I can, and accepting all assistance gratefully.

Kevin

--

 

[Guest]

Kevin,

It looks like you need Gantt chart control or similar. There are many ways
to accomplish a timeline on MS Access forms and reports. One way is to use
custom Gantt ActiveX controll (I found some free examples on the www). The
other way is to use fixed-size box font as a timeline controll in a textbox
and manipulate the length of the string. You can download LaBox font (it is
free) and use it.

To reference mouse click point on a controll on a single or continuous form
I use two events: Mouse_click to get x and y values, and Mouse_doubleclick to
execute a procedure based on x and y values captured earlier. You want to be
clicking on label, not on textbox which should be locked and disabled for
proper display.
Screenshot: http://depthome.brooklyn.cuny.edu/bcpc/images/AMRoomAssigns.jpg


I have a sample ap

 

[KRose]

Kevin,

It looks like you need Gantt chart control or similar. There are many
ways to accomplish a timeline on MS Access forms and reports. One way
is to use custom Gantt ActiveX controll (I found some free examples
on the www). The other way is to use fixed-size box font as a
timeline controll in a textbox and manipulate the length of the
string. You can download LaBox font (it is free) and use it.

To reference mouse click point on a controll on a single or
continuous form I use two events: Mouse_click to get x and y values,
and Mouse_doubleclick to execute a procedure based on x and y values
captured earlier. You want to be clicking on label, not on textbox
which should be locked and disabled for proper display.
Screenshot:
http://depthome.brooklyn.cuny.edu/bcpc/images/AMRoomAssigns.jpg

[snip]

Don1,

Thank you for the information. You are exactly correct, I have thought
Gantt control or a MS Outlook style calendar might do the trick.

Your app has a very nice clean and non-complicated look to it.

It also appears from the screenshot, the user can click on the time to
access details associated with the reservation. This would be idea for
me, as there are many details involved with every activity on the floor.


Would you mind sharing a list of Gantt controls you have experience
with? Or possibly the name of the one you used to create this app.


Thanks in advance,

Kevin

 

[PC Datasheet]

Don,

Your timeline screen is great!! Would you share a copy of your database with
me?

Steve
(e-mail address removed)

 

[John Marshall, MVP]

Are you planning on selling it as your own work?

John... Visio MVP

 

[PC Datasheet]

You're just reinforcing what a poster said about John Marshall dwt ---

"That's good, you hypocritical piece of shit. "

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Over 1000 Access users have come to me for help. My fees are very
reasonable.

Are you planning on selling it as your own work?

John... Visio MVP

 

[John Marshall, MVP]

It was a fair question. You have proven in the past that you have no ethics,
abuse the newsgroup and plagarize. So it is not beyond belief that you would
obtain something for free and then turn around and sell it as your own.

John... Visio MVP

You're just reinforcing what a poster said about John Marshall dwt ---

"That's good, you hypocritical piece of shit. "

PC Datasheet

Over 1000 Access users have come to me for help. My fees are very
reasonable.

and how many of those were expecting free help?

 

[Guest]

The method used on the sample form is building variable length strings with
LaBox font. Bound function takes two parameters - StartTime, EndTime - and
builds variable length strings based on them. Those strings look exactly like
Gantt chart timelines. User can double click on those timelines and view
record details associated with them. The biggest difficulty was not to write
the code but to do exact measurements of graphic interface, which took A LOT
of trial and error work.

Yes, the application that uses this method is for sale. The application is
MS Access solution for Community Arts Schools and is available for download
at http://depthome.brooklyn.cuny.edu/ArtsManager.htm
Source code is not for sale though, sorry. Application implements FTP,
Email, ZIP, RC4, CRC32, MD5, MS Office Links and other VB tools.

Sample Gantt ActiveX project:
http://depthome.brooklyn.cuny.edu/bcpc/files/Gantt.zip
It was done by some programmer in Phillipines, it is free...

 

[Guest]

Mistake in the link, here's the correct one:
http://depthome.brooklyn.cuny.edu/bcpc/ArtsManager.htm

 

[KRose]

Don1,

Thank you for following up with the links. I sincerely appreciate you
taking your time, and look forward to reviewing the sample project.

Kevin

The method used on the sample form is building variable length
strings with LaBox font. Bound function takes two parameters -
StartTime, EndTime - and builds variable length strings based on
them. Those strings look exactly like Gantt chart timelines. User can
double click on those timelines and view record details associated
with them. The biggest difficulty was not to write the code but to do
exact measurements of graphic interface, which took A LOT of trial
and error work.

Yes, the application that uses this method is for sale. The
application is MS Access solution for Community Arts Schools and is
available for download at
http://depthome.brooklyn.cuny.edu/ArtsManager.htm Source code is not
for sale though, sorry. Application implements FTP, Email, ZIP, RC4,
CRC32, MD5, MS Office Links and other VB tools.

Sample Gantt ActiveX project:
http://depthome.brooklyn.cuny.edu/bcpc/files/Gantt.zip
It was done by some programmer in Phillipines, it is free...

--

 

[PC Datasheet]

Ditto for me too!!

Steve

Don1,

Thank you for following up with the links. I sincerely appreciate you
taking your time, and look forward to reviewing the sample project.

Kevin

 

[PC Datasheet]

You're just reinforcing what a poster said about John Marshall dwt ---

"That's good, you hypocritical piece of shit. "

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Over 1000 Access users have come to me for help. My fees are very
reasonable.

 

[John Marshall, MVP]

Sorry steve, I do not plan in joining in your childish games.

Your reputation precedes you and I was making a fair comment. Since you have
not bothered to deny it, then you must be planning on reselling Don's
project.

John... Visio MVP

 

[PC Datasheet]

You're just reinforcing what a poster said about John Marshall dwt ---

"That's good, you hypocritical piece of shit. "

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Over 1000 Access users have come to me for help. My fees are very
reasonable.

 

[WSF]

I am a loss to understand why anyone would employ you or enter into a
contract you with your temperament. Is this how you behave when a client
disagrees with you? Probably, given the postings by and about you.

I don't see the point in you continuing to abuse people who stand head
and shoulders above you in terms of knowledge and who contribute more to
the public knowledge base that you could ever take for nothing.

The repeated requests for you to play fair and stop using the newsgroups
as your business hunting ground seem fair and reasonable.

 

[PC Datasheet]

We don't see you making any contributions to the newsgroups and why do you
hide behind some ficticious initials instead of telling us who you are?


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

 

[WSF]

I'm not sure who the "we" and the "us" are Steve - is there more than
one of you? It doesn't matter who I am and frankly I wouldn't want you
of all people to know. I have certainly taken much more from the
newsgroups than I have contributed and am very appreciative of the help
I have received - all freely given to me by people who don't stoop to
stalking the newsgroups like you do.

 

[John Marshall, MVP]

We don't see you making any contributions to the newsgroups and

Keeping the newsgroups free of abusers seems like a good contribution.

why do you hide behind some ficticious initials instead of telling us who
you are?

That's brilliant coming from you. So PC Datasheet is your real name?

PC Datasheet

JVM