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 >