Search results

  1. MajP

    Change background color on click

    Easiest is to put a hidden textbox in the header. 1. Call it txtLink 2. in the forms current event set the primary key. Lets assume it is called ID me.txtLink = me.ID 3. set the condition format to something like expression: [id] = [txtLink]
  2. MajP

    How to present a list of items to the user where some of those rows may be unavailable (i.e. -greyed out /disabled)

    I realized I posted the wrong example database. Here is the correct db. https://www.access-programmers.co.uk/forums/threads/how-to-present-a-list-of-items-to-the-user-where-some-of-those-rows-may-be-unavailable-i-e-greyed-out-disabled.331346/post-1923614
  3. MajP

    Moving dynamically records

    Post in thread 'MS Access: custom control built in another language' https://www.access-programmers.co.uk/forums/threads/ms-access-custom-control-built-in-another-language.307414/post-1646046
  4. MajP

    Calendar that displays appts in date range across multiple months

    Use the peter Hibbs calendar https://www.access-programmers.co.uk/forums/threads/date-pickers-calendar-controls-and-calendar-resources.315041/
  5. MajP

    Solved Cannot find Referenced Form

    Easy enough test
  6. MajP

    Solved Cannot find Referenced Form

    I do not understand. I explained clearly that a form has a form property and demoed this in working code. What else I have to do?
  7. MajP

    Solved Stop automatic save

    That is the approach is what @Pat Hartman is referring to but as @CJ_London said that would not allow you to enter main form information and sub form information without saving the main form record. All that is going to do is allow you to cancel the main form. If that is sufficient it is good...
  8. MajP

    Solved Stop automatic save

    You can come up with all kinds of convoluted solutions. Unbound forms or transactions and likely beyond your skillset. And 99 times out of 100 when people ask to do this, it is for no good reason. Your case looks the same. For what good reason would you not save the main record until a note is...
  9. MajP

    Display Selection of a List Box in a Text Box

    You set your variables outside of the loop it would be something like this inside the loop expression.Column (Index, Row) FlNum = Me.TestListBox.Column(0,i) FlNam = Me.TestListBox.Column(2,i)
  10. MajP

    Access 2007/2010's lack of automatic capitalization of function names in an external library

    I am guessing they just did not account for checking capitalization across external references when developing the vbide. I would think it is possible because intellisense knows the correct caps.
  11. MajP

    Solved Cannot find Referenced Form

    There is a second way to open a form without using the DOCMD, but it is harder to use and can have problems. Private frm As Form Private Sub Command0_Click() Set frm = New Form_Form2 ' This actually causes the form to open hidden and in design mode but needs to have a module 'You can set a...
  12. MajP

    Solved Cannot find Referenced Form

    That is definitely not why it failed. It simply failed because the forms collection only holds references to Open forms not all forms. So since it is not open you cannot get a reference from the Forms collection. If the OP simply opened the form first the code works fine Private Sub...
  13. MajP

    Hoping to use Form_AfterRender or Form_AfterFinalRender, but No Joy...

    I tested my suggestion and it will probably not work. Although you can "turn off" the event procedure you cannot stop access from actually doing the event. So it will continue to paint, just your code in the event handler will not execute. This means when it does repaint it will likely update...
  14. MajP

    Hoping to use Form_AfterRender or Form_AfterFinalRender, but No Joy...

    Completely un tried but maybe you could turn off the event handler after the last record is painted. in the on paint event remove "[event procedure]" from the event handler after the last record is painted the first time. if me.recordset.absoluteposition = me.recordset.recordcount - 1 then...
  15. MajP

    How to present a list of items to the user where some of those rows may be unavailable (i.e. -greyed out /disabled)

    I saw an issue with new records so I meant to replace it with an updated version. The new version is now in thread #20 (Version 3). I also put a button to delete the last action Normally I do the opposite an discourage people from trying to come up with a non standard form design where the...
  16. MajP

    DLookup returning Null instead of empty string

    I believe this is a known problem. http://allenbrowne.com/ser-42.html
  17. MajP

    How to present a list of items to the user where some of those rows may be unavailable (i.e. -greyed out /disabled)

    Again I think you just need to track if the Issue has been resolved not if the warning/legal action has been resolved. unless somehow those represent two different things which has not been explained. If this is the case you will have to explain. If you had open 1st warning, 2nd Warning, and...
  18. MajP

    Which way do you DIM your variables?

    Not much of an issue now a days for anyone writing much code. Since you are likely to have a code writing utility like MZTools which will show all dead code.
  19. MajP

    Which way do you DIM your variables?

    There is an existing thread here too. https://www.access-programmers.co.uk/forums/threads/premature-declaration.331042/
Top Bottom