Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    72

    Re: Bound Column Change Not Working

    The column numbers start from 0 so column 3 would actually be .Column(2)

    Are you using the correct index.?
  2. Replies
    6
    Views
    132

    Re: Maintenance of MS Access Back End

    I cannot offer a reason to the problem, but they used to so this in a bank I worked in for Excel workbooks and it annoyed the hell out of me as I had placed the workbooks on my MRU list.

    Why when...
  3. Replies
    3
    Views
    107

    Re: AccesS Formula help

    Is the last IIF actually needed?
  4. Replies
    1
    Views
    179

    Re: Registration form - Ideas

    If the difference is zero, then disable the add and signup buttons/process ?
  5. Re: Batch Script for New Versions and Shortcuts

    The way I did it, was the create the shortcut with the correct info in it, and place it with the master DB copy.
    Then copy that to the user's desktop.

    I do not have access to the computer that...
  6. Re: Add next number based on previous record SET

    That will likely be because you are not taking the description_location into account when using DLast.?
    Use the criteria option to select the correct description_location.

    Also pay attention to...
  7. Re: Method for maintaining listbox possible values

    That is what I would do, with perhaps an additonal field for sort order, then sort by that and then Selection_value.?
  8. Replies
    4
    Views
    1,293

    Re: Access Query

    Any errant spaces in Item ?
  9. Replies
    3
    Views
    916

    Re: Crash When Use SetWindowLongPtrA

    Seriously? :(
  10. Re: Run many large update queries in the right order one at a time possible?

    Yes, as the video shows.
    That is about the only use I make of macroes :D
  11. Replies
    3
    Views
    1,412

    Re: dynamic report header

    Could you have ?


    Private Sub Report_Open(Cancel As Integer)

    Select Case Forms!f_QBF!cboGrouping
    Case "1" 'Site & District
    Me.GroupLevel(0).ControlSource = "Site"
    ...
  12. Replies
    11
    Views
    1,111

    Re: disable check box based on other checkbox

    Yes, not user friendly at all I agree, but my thoughts were, you untick and that enables again.
    I think we all agree, radio buttons are the way to go, but it is up to the o/p at the end of the day.?
  13. Replies
    11
    Views
    1,111

    Re: disable check box based on other checkbox

    By the change in state of whatever drives the condition to enable/disable ?
    If combined is checked, disable USA & Canada
    If combined is unchecked enable USA & Canada
    If either of USA or Canada are...
  14. Replies
    2
    Views
    640

    Re: Remove conditions

    Why not share it in case it would help someone else?
  15. Replies
    11
    Views
    1,111

    Re: disable check box based on other checkbox

    +1 for radio button as well.
    Post was about enable/disable?, though clearing out the values as well would be a good idea?
    Look at Me.ControlName.Enabled = True and Me.ControlName.Enabled = False
  16. Thread: validation

    by welshgasman
    Replies
    7
    Views
    1,069

    Re: validation

    Literally test for that in the BeforeUpdate event of the form as xenou explained and display an appropriate error message.?
    Alternatively in the LostFocus event of each control, disable d, if a, b...
  17. Re: Format field as a phone number in report

    PMFJI,
    Care to share, in case it can help others?
  18. Replies
    2
    Views
    769

    Re: Back End Only Opening Read Only

    I would look at the properties for the file and see if it has been set to read only?

    If so, are the other files in the folder also set.?
    Is some process running that sets all files in folder to...
  19. Replies
    5
    Views
    1,252

    Re: VBA - Populate Word Document

    Just noticed that you said you changed the path name. Never a good idea, as that could be the problem.?

    Regardless, that code works if a file by that name and path exists.
  20. Replies
    5
    Views
    1,252

    Re: VBA - Populate Word Document

    I can't believe you have a document with a path of this?



    "\\Example\File\Path\Document Name.docx"


    Try a word document that exists.

    I have just tried your code with a file that exists...
  21. Re: Trying to average last 3 records only (top 3)

    I was thinking along these lines?

    https://stackoverflow.com/questions/910894/access-2002-how-to-group-by-and-top-n-records-in-same-query
    ...
  22. Re: Trying to average last 3 records only (top 3)

    Try using a sub query to get the top 3 records, then avg those in the main query.?
  23. Re: MS Access auto/scheduled report export.

    Access has a runtime version.?
  24. Re: The dreaded "Unrecognized database format": what to do?

    Ok, that is good.
    It is just I have seen so many scenarios where the DB was split, but everyone was using a shortcut to the same FE. :(
  25. Re: The dreaded "Unrecognized database format": what to do?

    Does each user have their 'own' FE?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4