Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Unanswered: getting at drawing functions on an access form

    I can draw on a report but not on a form. I understand that this is just how access works, but, can anyone tell me why?

    And then, can someone tell me how to get this functionality to run on a form? I've read that if I use VB, I can draw on those forms. But being stubborn, I want to do this on an access form even if it means I have to get under the hood a little.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    access is a front end tool its not a native language. so there are assumptions built in to Access about waht is reasonable, what is expected, whats its capable of, and therefore implicitly what it can't do.

    you probably could do what you want by adding a custom DLL, or perhaps find an activex control for what you want
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What do you want to draw?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jan 2009
    Posts
    4

    what do I want to draw?

    Circles primarily. But they have to move and they will need to change sizes. I'm trying to simulate a new theory on gravitation and have it show the simulation on an access form. I'm really quite good at doing queries, building tables, forms, etc but am a total drooling idiot when it comes to putting graphics on an access form. I've come up with a way to generate multi-body spatial relationships in tables and have those relationships automatically generate in queries quickly. I'm missing some mathematics in the calculations but that is minor compared to the problem of showing the motion inside of an access form.

    I'm pretty sure the functionality exists but getting those functions exposed in vba on an access form is what I need to learn about. Also, I'm kind of ready to take the next step into the windows kingdom where all this stuff is at.

    But I need help doing that.

    Thanks, in advance.

    Steve

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm really quite good at doing queries, building tables, forms, etc but am a total drooling idiot when it comes to putting graphics on an access form
    LOL! I have to admit that I am pretty much the same ^^

    As healdem suggests, you might want to try searching for a custom library to see if you can expose the commands you need.

    Good luck with it!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jan 2009
    Posts
    4
    Aw, come on. I'll sing the praises of dbforums far and wide if you guys help. This is bleeding edge stuff I'm trying to do and if dbforums were connected to it (especially if it proves the theory actually works), you guys will become famous. Incidentally, the physics theory behind this attempt isn't mine, meaning, I didn't come up with it. Someone else did.
    Maybe somebody from another product group would be able to help here? How do I get at native window functions from access? Surely there must be a way? ( 'And don't call me Shirley!' )
    Cheers.

  7. #7
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    your How do I get at native window functions from access? points the way: start your research on APIs now - gdi32.dll contains just about everything you need.

    be warned - it is truly a HUGE project.

    if you want to see some examples of messing about with drawing in A, have a look at lebans.com --- wont solve your problem but will help you to understand the scale of the project you are planning to undertake.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •