[dba-Tech] Drawing text/graphics on MS Access forms usingWin32API

William Hindman wdhindman at bellsouth.net
Mon Feb 16 22:39:41 CST 2004


...put me down for Win XP and Access 2002! :)

William Hindman "My idea of an agreeable person is a person who agrees with
me." Disraeli


----- Original Message ----- 
From: "Shamil Salakhetdinov" <shamil-users at mns.ru>
To: "Discussion of Hardware and Software issues"
<dba-tech at databaseadvisors.com>
Sent: Monday, February 16, 2004 7:36 PM
Subject: Re: [dba-Tech] Drawing text/graphics on MS Access forms
usingWin32API


> >...love to  see the results if he takes it any further  :)
> You're welcome, William and all! :)
>
> I made it.
>
> Here are the pics of the two test cases:
> http://www.extvba.spb.ru/hypocycloid/fav34.jpg
> http://www.extvba.spb.ru/hypocycloid/fav56.jpg
>
> This is an MS Access form without any activeX etc. - the pics are drawn
> on the detail section surface. I use my custom C++ DLL but not for
> visual part of this MS Access application...
> Resize is still a problem. Repaint seems always work OK after minimize
> or making hidden/visible the form or its parts etc.  I don't think I
> will work on fixing resize now - it was quite some free labor work and
> it is enough for now...
>
> I tested it on MS Win2K and MS Access 97/2000/XP. Hopefully it will work
> on other MS Windows/Access versions too. Of course there is some tricky
> hacking here but it shows itself as stable and no GPF after heavy load
> with all that incredibly wonderful hypocycloid graphics...
>
> Now I need volunteer testers who wanted to test this sample on:
>
> - MS Win95
> - MS Win98
> - MS WinNT
> - MS WinXP
> - MS Windows .NET Server and
> - all the versions of MS Access starting MS Access 97.
>
> I will send you an MDE version for testing purposes.
> I have to ask you to not redistribute this stuff until it will not be
> clear it works OK and until I will not publish this info on my site.
> I plan to do that in approx. 1 - 1.5 months - I plan to publish the
> sources and quite some other tricky and unique Win32 API VBA programming
> stuff I'm cooking here...
> I need to work intensively on a new project now - so there is no  enough
> time here to
> continue with quick preparing of this info for publication.
>
> Mark, thanks for your proposal  to play with Hypocycloids - they are
> fascinating!
>
> Shamil
>
> P.S. I will need only one volunteer tester for each MS Windows/MS Access
> version combination. I will  publish on my site the info on testing
> results and the tester(if they want) as soon as I get positive feedback.
>
> ----- Original Message ----- 
> From: "William Hindman" <wdhindman at bellsouth.net>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com>
> Sent: Saturday, February 14, 2004 2:11 AM
> Subject: Re: [dba-Tech] Drawing text/graphics on MS Access forms
> usingWin32API
>
>
> > ...I've never tried anything anywhere near that complex ...round and
> polygon
> > windows are more than enough to impress the hell out of my clients  :)
> >
> > ...but it looks like Shamil even has the source for that source
> ...love to
> > see the results if he takes it any further  :)
> >
> > William Hindman
> > Government is not reason, government is not persuasion,
> > government is force. It is a dangerous servant." G. Washington
> >
> > ----- Original Message ----- 
> > From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com>
> > To: "'Discussion of Hardware and Software issues'"
> > <dba-tech at databaseadvisors.com>
> > Sent: Friday, February 13, 2004 11:20 AM
> > Subject: RE: [dba-Tech] Drawing text/graphics on MS Access forms
> > usingWin32API
> >
> >
> > > >> produce circular, elliptic, or polycentric forms <<
> > >
> > > William,
> > >
> > > I remember a demo..."ShapedForm.mdb".  Was that your inspiration?  I
> > > downloaded it long ago because I thought a submarine shaped form
> would be
> > > very unique;)  I never got around to actually researching the full
> > > capabilities.  Are complex shapes such as that even possible?
> > >
> > >
> > >
> > > Mark
> > >
> > >
> > > -----Original Message-----
> > > From: William Hindman [mailto:wdhindman at bellsouth.net]
> > > Sent: Friday, February 13, 2004 10:55 AM
> > > To: Discussion of Hardware and Software issues
> > > Subject: Re: [dba-Tech] Drawing text/graphics on MS Access forms
> > > usingWin32API
> > >
> > >
> > > Shamil
> > >
> > > ...lebans also has code for using images to imitate drawing
> circles/shapes
> > > around controls ...I've used it to highlight calc results, etc.
> > >
> > > ...I've also got an api module that I've used since A97 that lets me
> > produce
> > > circular, elliptic, or polycentric forms ...which is actually
> drawing on
> > the
> > > form and hiding everything outside of the elliptic ...I've only used
> it
> > for
> > > splash forms and switchboards but it sure does wake up an audience
> looking
> > > to see what you're capable of ...I've had more than a couple swear I
> was
> > > using something other than pure Access :)
> > >
> > > William Hindman
> > > Government is not reason, government is not persuasion, government
> is
> > force.
> > > It is a dangerous servant." G. Washington
> > >
> > > ----- Original Message ----- 
> > > From: "Shamil Salakhetdinov" <shamil-users at mns.ru>
> > > To: "Discussion of Hardware and Software issues"
> > > <dba-tech at databaseadvisors.com>
> > > Sent: Friday, February 13, 2004 9:18 AM
> > > Subject: Re: [dba-Tech] Drawing text/graphics on MS Access forms
> > > usingWin32API
> > >
> > >
> > > > > couldn't you find an ocx to handle that?
> > > > This would be a limited solution by definition - OCX/ActiveX is a
> > > > rogue for MS Access forms and controls...
> > > >
> > > > > Now, I don't know why you would draw something on a form
> > > > 1. "tractor" continuous/datasheet forms
> > > > 2. skins
> > > > 3. Dynamic drawing of circles, ellipses, .., and other geometric
> > > > figures around controls to highlight special values etc... 4. just
> fun
> > > > of extreme VBA programming 5. ??? (something else anybody) ???
> > > >
> > > > Shamil
> > > >
> > > > ----- Original Message -----
> > > > From: "Gustav Brock" <gustav at cactus.dk>
> > > > To: "Discussion of Hardware and Software issues"
> > > > <dba-tech at databaseadvisors.com>
> > > > Sent: Friday, February 13, 2004 2:28 PM
> > > > Subject: Re: [dba-Tech] Drawing text/graphics on MS Access forms
> > > > usingWin32API
> > > >
> > > >
> > > > > Hi Shamil
> > > > >
> > > > > > So this is a challenge to prove the opposite?
> > > > >
> > > > > Certainly!
> > > > >
> > > > > > Any betters here? :)
> > > > >
> > > > > Njah, not me ...
> > > > >
> > > > > Now, I don't know why you would draw something on a form. If it
> were
> > > > > anything more than some decorating stuff, couldn't you find an
> ocx
> > > > > to handle that?
> > > > >
> > > > > /gustav
> > > > >
> > > > >
> > > > > >> That may not be possible at all. Read here:
> > > > > >>
> > > > > >>   http://www.mvps.org/access/api/api0053.htm
> > > > > >>
> > > > > >> /gustav
> > > > > >>
> > > > > >>
> > > > > >> > Have anybody any info on subj?
> > > > > >>
> > > > > >> > TIA for any refs, tips and tricks,
> > > > > >> > Shamil
> > > > >
> > > > > _______________________________________________
> > > > > dba-Tech mailing list
> > > > > dba-Tech at databaseadvisors.com
> > > > > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > > > > Website: http://www.databaseadvisors.com
> > > >
> > > > _______________________________________________
> > > > dba-Tech mailing list
> > > > dba-Tech at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > _______________________________________________
> > > dba-Tech mailing list
> > > dba-Tech at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > > Website: http://www.databaseadvisors.com
> > > _______________________________________________
> > > dba-Tech mailing list
> > > dba-Tech at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>





More information about the dba-Tech mailing list