[AccessD] Gantt chart in Access

William Hindman wdhindman at dejpolsystems.com
Tue Feb 9 12:16:56 CST 2010


...tks for the suggestion Charlotte, but again, if you're looking for a wide 
range of full sized character blocks, wingdings falls far short.

William

--------------------------------------------------
From: "Charlotte Foust" <cfoust at infostatsystems.com>
Sent: Tuesday, February 09, 2010 11:25 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Gantt chart in Access

> I seem to recall you could use wingdings for the same purpose.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Monday, February 08, 2010 9:35 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Gantt chart in Access
>
> ...quite true, but my install takes care of that ...the disadvantage of
> Courier New is that it has a very limited box selection and they are not
> full size ...use it in a text box and you will see a narrow line in the
> background color at the top ...LABOX otoh has a very wide selection of 
> full
> sized boxes in a well designed combination of standardized widths, as well
> as different sized heights/widths, that make it ideal for gantt type
> displays ...install it and take a look at the difference.
>
> William
>
> --------------------------------------------------
> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> Sent: Monday, February 08, 2010 10:35 PM
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Gantt chart in Access
>
>> The advantage of using Courier New is that it is a standard Windows font.
>> You don't need to
>> worry about installing extra fonts on every machine that will use
>> application.
>>
>> -- 
>> Stuart
>>
>> On 8 Feb 2010 at 20:48, William Hindman wrote:
>>
>>> http://www.mvps.org/access/forms/frm0055.htm has a much better font for
>>> this
>>> than Courier New
>>>
>>> ...but I will certainly give your code a spin ...thanks :)
>>>
>>> William
>>>
>>> --------------------------------------------------
>>> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
>>> Sent: Monday, February 08, 2010 5:09 PM
>>> To: "Access Developers discussion and problem solving"
>>> <accessd at databaseadvisors.com>
>>> Subject: Re: [AccessD] Gantt chart in Access
>>>
>>> > Of course! <slaps self on forehead>
>>> >
>>> > Just use a block character with a fixed width font in a text string:
>>> >
>>> > Create a stack of text boxes each of which runs across the full form.
>>> > Set the font to Courier New (a fixed width, unicode font).
>>> > Set the font colours of the textboxes to different values if you want
>>> > different coloured lines.
>>> >
>>> > Create the following function.
>>> >
>>> > Function Plot(startpos As Long, endpos As Long) As String
>>> >  If Nz(startpos) < 1 Then Exit Function
>>> >  If Nz(endpos) < 1 Then Exit Function
>>> >  If endpos < startpos Then Exit Function
>>> >  Plot = IIf(startpos > 1, Space$(startpos - 1), "") & String$(endpos -
>>> > startpos + 1,
>>> > ChrW(&H2588))
>>> > End Function
>>> >
>>> > To display a line running from Day 3 to Day 5 in the first row:
>>> >  txtLine1 = Plot(3,5)
>>> >
>>> > You can also use the shaded unicode characters
>>> > &H2591 - &H2593 to get more variety.
>>> >
>>> > -- 
>>> > Stuart
>>> >
>>> >
>>> > On 8 Feb 2010 at 14:04, Susan Harkins wrote:
>>> >
>>> >> William, I am so sorry... years ago I wrote about this in Inside
>>> >> Microsoft
>>> >> Access. Those old issues are packed up in my daughter's basement and
>>> >> they're
>>> >> not online, as far as I know. I did a google search, just in case. :(
>>> >>
>>> >> AIR...it was an extremely simple formula using Chr() -- I just don't
>>> >> remember how I repeated that function that appropriate number of
>>> >> times.
>>> >> It
>>> >> was... as you and JC would put it... dead simple.
>>> >>
>>> >> If anyone has access to those old issues of IMA, maybe they might 
>>> >> look
>>> >> it
>>> >> up -- would've been pre 1998.
>>> >>
>>> >> Susan H.
>>> >>
>>> >>
>>> >> > Charlotte
>>> >> >
>>> >> > ...that remains an option but I generally don't like embedded
>>> >> > reports
>>> >> > in
>>> >> > runtime installs ...not just the appearance of them but they're
>>> >> > fragile
>>> >> > as
>>> >> > well ime ...but I'm not dismissing it if I can't come up with a 
>>> >> > form
>>> >> > approach that works.
>>> >> >
>>> >> > William
>>> >>
>>> >> -- 
>>> >> AccessD mailing list
>>> >> AccessD at databaseadvisors.com
>>> >> http://databaseadvisors.com/mailman/listinfo/accessd
>>> >> Website: http://www.databaseadvisors.com
>>> >
>>> >
>>> > -- 
>>> > AccessD mailing list
>>> > AccessD at databaseadvisors.com
>>> > http://databaseadvisors.com/mailman/listinfo/accessd
>>> > Website: http://www.databaseadvisors.com
>>> >
>>>
>>> -- 
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list