Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. I GUESS I WAS RIGHT! They never considered...

    I GUESS I WAS RIGHT!

    They never considered that a requirement... :mad::( 39050
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. Replies
    3
    Views
    4,577

    Thanks. We'll give it a try.

    Thanks.
    We'll give it a try.
  12. Replies
    3
    Views
    4,577

    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.
  13. Replies
    3
    Views
    4,577

    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...
  14. 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!
  15. 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...
  16. 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.
    ...
  17. 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...
  18. 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.
  19. Replies
    15
    Views
    12,576

    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.
  20. Replies
    22
    Views
    3,545

    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...
  21. Replies
    18
    Views
    4,575

    Sounds to me like there is a Macro running as a...

    Sounds to me like there is a Macro running as a result of the change in the drop down.
    Also is the drop down Data Validation, A Form Drop Down Box or an Active X Control?
    You probably are not...
  22. You could put a calculated field on the form and...

    You could put a calculated field on the form and just have it showing the content of the combo box

    =cboCommodityCode.Column(2) Note the column no is 1 less than the position

    OR you could...
  23. Replies
    15
    Views
    12,576

    It is 14.0 in Office 2010. Trust me.

    It is 14.0 in Office 2010.
    Trust me.
  24. Replies
    15
    Views
    12,576

    You can also use Application.Version This...

    You can also use
    Application.Version
    This returns the Office Suite Number

    So 2010 = 14.0, 2007 = 12.0, 2003 = 11.0, XP = 10.0, 2000 = 9.0 etc

    No 13. Bit superstitious the MS Lot! 2010 is...
  25. Replies
    2
    Views
    677

    Is this going in the right direction

    Example using Form Option Buttons in a Group Control
    With Macro attached to each button

    See Attached
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4