Search results

  1. ChrisO

    Copy a Control in Form Design

    I'm not entirely sure what you are trying to do but it sounds like this might help:- http://www.access-programmers.co.uk/forums/showthread.php?t=228040 The above demo uses Labels but Command buttons or Image controls could be used. You will not need to go into design mode to copy/paste a...
  2. ChrisO

    Persistent connection to backend, 'Dim dbsAlwaysOpen As DAO.Database' causing error

    From memory, Access 2002 did not have a reference set to DAO. Chris.
  3. ChrisO

    Instanced Forms Disappearing / Drop-down based MsgBox

    From what I have seen so far the requirement should be data driven. Small demo attached. Chris.
  4. ChrisO

    Send variables from modal to main form

    Yep, their fine. Public Subs could not be called directly from the property sheet (well they could but they would be called more than once) so they had to be Functions for that. (I think that was fixed after XP/Access2003). But Subs are okay for the use they are being used for here. Chris.
  5. ChrisO

    Send variables from modal to main form

    Actually, public Subs are fine. Chris.
  6. ChrisO

    How use variables in form code…

    Sub-forms can be regarded as being in parallel if they share a common parent else they can be regarded as being in series if directly connected. From an electrical perspective:- http://en.wikipedia.org/wiki/Series_and_parallel_circuits With forms and sub-forms it makes a difference to know the...
  7. ChrisO

    A 2013 error handling

    Dick. >>Can anybody tell me why this thread was removed from "new post"?<< I don't understand what that means but I have now moved this thread to the 'Modules and VBA' forum. Chris.
  8. ChrisO

    How use variables in form code…

    The requirement is not well specified. We do not know if the sub-forms are in series or parallel. Nor do we know how deep the series is or how wide the parallel is. If we make the assumptions that there is a starting point in the form's structure, let's say the outermost parent form, and we...
  9. ChrisO

    Email notification

    Another attempt. Chris.
  10. ChrisO

    Email notification

    I got your message via gmail so it still seems to be okay.
  11. ChrisO

    Email notification

    Responding to post #15. Chris.
  12. ChrisO

    Procedures

    If you need to go into design mode then it will not work in a compiled version of your database. Chris.
  13. ChrisO

    Friday plane crash.

    Okay, I was going to leave the question here for much longer before answering but there doesn't seem to be much interest. There are a few different answers available on the web but it surprises me how many people think we don't bury survivors. (You can Google the question and try to get an...
  14. ChrisO

    Friday plane crash.

    Question: ------ If an aircraft crashes on the border between Canada and the US, where will the survivors be buried? ------ Even if you see your answer already posted please repost your view and, if you like, give any brief reason you think your answer is correct. Chris.
  15. ChrisO

    Create shapes

    Most things are possible in Access... http://www.access-programmers.co.uk/forums/showthread.php?t=232752 Chris.
  16. ChrisO

    Access Exit behaves differently depending on how it is run

    1. And cross posted at: http://www.utteraccess.com/forum/Access-Find-Nonexistent-t2009762.html By the way, unless Microsoft have changed the Cancel behaviour of Forms after A2003, Brent's code in post #3 on the above link won't work. The Form Unload event can't be cancelled after a VBA Quit...
  17. ChrisO

    Lately, AWF slow

    Hi Jon. When I say new members will not be able to join I mean new members using bigpond as a domain, or any other domain which may have been blocked, will not be able to join. Some people are getting emails, I can redirect my emails through GMail, but the bigpond domain is currently blocked...
  18. ChrisO

    Lately, AWF slow

    Hi Jon. It again appears that bigpond (at least) is not getting emails from this site. This also means that new members can not join because they can't reply to the confirmation email. Regards, Chris.
  19. ChrisO

    Email notification

    Email notification test 4.
  20. ChrisO

    Email notification

    Email notification test 3. Fred
Back
Top Bottom