Search results

  1. Rich

    switchboard buttons not responding after adding macro to open event

    I know but it beats having to write reams of code
  2. Rich

    switchboard buttons not responding after adding macro to open event

    Been using one since 95/96 still works fine in 2010:D
  3. Rich

    How to replace vba Sum Result with Zero if Null

    Sorry for appearing thick but how can you have a TRNACTDTE>Date() ?:confused:
  4. Rich

    2010 equiv for set rst

    The maximise part works, the menu button simply calls a Restore function etc. I guess the only way is to use the close event of the Reports that had the menu bar attached. I have to say though in 2010 defence, it's much faster and the graphs actually display which they didn't in Vista
  5. Rich

    2010 equiv for set rst

    I have to find the new code to maximise and restore the Access window first, I'll be back in about 3months:eek:
  6. Rich

    2010 equiv for set rst

    I went to my daughters, converted and saved to 2007, came home and repaired the access inst. opened the new version and voila, most of it worked including my switchboard to hide that ugly bloody window. Now all I've got to figure out is how to get my custom menus to show and work:D
  7. Rich

    2010 equiv for set rst

    The code works fine in 2007, there are loads of errors in 2010:mad:
  8. Rich

    2010 equiv for set rst

    I've checked the references, but can't see any missing, but that's not all. rs.FindFirst errors as well, Method or data member not found:o
  9. Rich

    2010 equiv for set rst

    It's everywhere that use Rs, this is just one of them Dim rs As Recordset Dim result On Error GoTo Err_RunSum ' Get the form Recordset. Set rs = F.RecordsetClone ' Find the current record. Select Case...
  10. Rich

    2010 equiv for set rst

    Error 13 TypeMismatch, it is just that line that I posted. I don't know where the references are to see if it's one missing
  11. Rich

    2010 equiv for set rst

    Had to "upgrade " to 2010 from 97, Is there a different method of doing this it worked in 2007:o Set rst = dbs.OpenRecordset(strSQL)
  12. Rich

    Atheists and theists are the same.

    Doesn't the junk mail filter work Dennis?:D
  13. Rich

    European Diaspora

    Will you do it religiously?:eek:
  14. Rich

    European Diaspora

    I've always wondered why athiests don't go around knocking on doors looking for new members or money for some bloody old building or the leader of the group:confused:;)
  15. Rich

    Atheists and theists are the same.

    Just because we can't fathom a reason for existance doesn't mean there has to be one
  16. Rich

    Atheists and theists are the same.

    Why? :confused:
  17. Rich

    No Americans

    A kingdom is a sovereign state instituting a monarchy, or having a monarch as its head.A kingdom is a sovereign state instituting a monarchy, or having a monarch as its head.:rolleyes:
  18. Rich

    No Americans

    Yes it used to be part of GreatBritain;)
  19. Rich

    No Americans

    It's part of the British Isles, which is of course Great Britain
  20. Rich

    No Americans

    Not part of my vocalb., why would it be, I'm not American
Back
Top Bottom