Search:

Type: Posts; User: AndrewKKWalker; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Yep.. That's what I meant re Advanced. A...

    Yep..
    That's what I meant re Advanced.

    A criteria Calculation that returns True or False in the second Row of Criteria that covers the necessary combined condition.

    I might even play around...
  2. I think I see where you are coming from Rory....

    I think I see where you are coming from Rory.
    Sorry for my misunderstanding.
    It had been a LOOOONNG day and I was tired.

    Tell me if I am wrong......

    If going for AutoFilter method, which...
  3. That works with distinct values, BUT, when when...

    That works with distinct values, BUT, when when there are several options all embedded needing wild cards it is the same problem I think.
    Unless I have missed a bit of basic logic somewhere.

    If I...
  4. Be too many fields zeddy, I would have to make...

    Be too many fields zeddy, I would have to make them up on the fly for each field
    So, if there were 10 wild card variants of 1 field I'd need an extra 4 dummy fields just for that one.
    I reckon a...
  5. More than 2 contains filters using autofilter in VBA

    OK, I am posting this, pretty sure the answer is NO
    But worth an ask.

    And I know the work around is either all coded extracts, OR advanced filters.
    And YES it ought to be in a database, but it...
  6. I GUESS I WAS RIGHT! They never considered...

    I GUESS I WAS RIGHT!

    They never considered that a requirement... :mad::( 39050
  7. I would suggest something like this on an open...

    I would suggest something like this on an open report button

    This allows for ALL or NONE of the filter components to be entered

    It is a bit more long winded, but more flexible




    Dim...
  8. STOP RIGHT MOUSE Button selecting items in a MULTISELECT listbox

    Maybe I am being dumb, but more than likely MS are..

    I have a form with a multi select listbox (simple)

    I also have a custom right mouse menu on the list box

    And yes.. it is important I have...
  9. OK, to follow this up, with a possible solution,...

    OK, to follow this up, with a possible solution, that is working for me anyway...

    I tried a different slant on design changes, which I should have thought of at the start.

    I changed the design...
  10. Thanks Wendell. I had a feeling it was a bug. I...

    Thanks Wendell.
    I had a feeling it was a bug.
    I thought I might be pushing the envelope.
    I will try doing a colour set on load and see if that fixed it.
    If not I will just do an old school Menu...
  11. Access 2013 Navigation Forms On Navigation Forms buttons lose colour

    This ought to work.

    BUT when I have a navigation form as the target of another navigation form.
    Meaning the form that get loaded by the navigation button is another navigation form.
    The form...
  12. Missing Characters in Report Text boxes

    Using Access 2010.
    We have reports that have text boxes.
    The page is withing margins
    The text boxes are within the printable page
    The text boxes have can grow set to yes and so does the detail...
  13. Just as an additional to this already solved...

    Just as an additional to this already solved problem.
    You could use SUMIF like this


    =SUMIF(DatesOfDeposits,"<>",ChecksReceived)

    This gives the same result, unless I have misread the...
  14. Unfortunately the setting on the PC is not for...

    Unfortunately the setting on the PC is not for exclusive.
    I suspect it is something to do with user permissions, or maybe something on the thin client settings.
    I reckon I am going to need to sit...
  15. Shared database reports it is in exclusive use - Access 2003

    OK, this may or may not make sense, but here goes.
    And this may well be a permissions issue rather than a database one.

    I have a database in 2003 mdb format.
    It is a shared database, and on some...
  16. Replies
    3
    Views
    5,821

    Thanks. We'll give it a try.

    Thanks.
    We'll give it a try.
  17. Replies
    3
    Views
    5,821

    In case anyone is going to suggest printing it to...

    In case anyone is going to suggest printing it to adobe acrobat, which DOES work ok.
    They do not have that.
  18. Replies
    3
    Views
    5,821

    Save Visio as PDF

    I have (or at least someone I know) has a 2 page A4 Visio document
    They want to save it as PDF.
    When they save it as a PDF, it saves it as a 1 page document not a 2 page document
    as ou see it in...
  19. That was tables not tablrs. I hate typing on...

    That was tables not tablrs.
    I hate typing on this phone.
    I must wear my glasses!
  20. use tablrs from secure access db in non secure fe

    Ok. I can do this with ado code.
    But...Is there an easier way to link a table from a user security access database.
    The FE is access but is not part of the secure mdw.
    And i only want to reference...
  21. OK, in answer to my own question, this appears to...

    OK, in answer to my own question, this appears to work



    oW.WordBasic.DisableAutoMacros 1


    If I run that bit of OLD Code against the Word Object, before I open the document, then it is OK.
    ...
  22. Prevent Word Autoexec Macros from running when opened from Access

    Not sure if this should be on Access OR Word but .....

    I have an access database that opens a word document.
    I can open the document no problem

    BUT.... The word document has an Auto_Open Macro...
  23. I am sure you know, but if you are scrolling...

    I am sure you know, but if you are scrolling through records on the form, then this code needs to go on both the After Update Event of the check box, and also the On Current event of the form.
  24. Replies
    15
    Views
    18,064

    Application.Build Will return Build No. If you...

    Application.Build
    Will return Build No.
    If you can map that to the Service Pack you could do it.
  25. Replies
    22
    Views
    4,666

    File Info with Scripting Run Time

    You can also find out a lot of useful information with the Scripting Run Time Library
    This is just a small amount of information

    You might not need the StrID on the end of the Path.
    I am not...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4