Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    388

    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"
    ...
  2. 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.?
  3. 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...
  4. Replies
    2
    Views
    563

    Re: Remove conditions

    Why not share it in case it would help someone else?
  5. 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
  6. Thread: validation

    by welshgasman
    Replies
    7
    Views
    958

    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...
  7. Re: Format field as a phone number in report

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

    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...
  9. Replies
    5
    Views
    1,089

    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.
  10. Replies
    5
    Views
    1,089

    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...
  11. 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
    ...
  12. 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.?
  13. Re: MS Access auto/scheduled report export.

    Access has a runtime version.?
  14. 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. :(
  15. Re: The dreaded "Unrecognized database format": what to do?

    Does each user have their 'own' FE?
  16. Re: Combo Box List - Suggestion as I type (not just beginning matches)

    A quick Google brings this up.?

    https://www.tek-tips.com/viewthread.cfm?qid=1756368
  17. Re: Need to export data to existing Excel file, using variable in the file name

    I don't believe you should have any single quote in there.?
    I would Debug.Print Application.Currentproject.Path and ProjExport and then concatenate them.?
    For a start...
  18. Re: Need to export data to existing Excel file, using variable in the file name

    I copied your code and created variables for the form controls and that compiles OK?
    The compiler would not have any idea of worksheet names, so it is not that.?

    Put a breakpoint on where you...
  19. Replies
    4
    Views
    662

    Re: Checkbox issue

    Export as csv and import to Excel
  20. Replies
    3
    Views
    682

    Re: Show Duplicates Across 2 Queries

    Remove status field, group on RegNo and add a count with criteria > 1 ?

    HTH
  21. Re: Copying and Pasting Between Word Docs from MS Access

    Not done it myself, but
    https://stackoverflow.com/questions/21317885/using-vba-to-copy-the-contents-of-a-word-document-into-another-word-document
  22. Re: Access 2010 - Make Table Query Losing LookUp data

    Lookups in Access tables confuse a lot of people. I believe most developers do not use them, as they just disguise the fact that all that is really held is a key.?
    When you create a query and then...
  23. Replies
    5
    Views
    1,089

    Re: VBA - Populate Word Document

    This should get you started.

    https://www.google.com/search?q=word+bookmarks+in+access+vba&oq=word+bookmarks+in+access+vba&aqs=chrome..69i57j33.13423j0j7&sourceid=chrome&ie=UTF-8

    One of those...
  24. Replies
    6
    Views
    745

    Re: Select A Textbox

    I think the O/P means VBA when they say Macro, as in Excel macro.
    If it was an Access macro they would use the GoToControl action. However it does not supply control names, you have to type them in...
  25. Re: Pick detail of speific GL account with details

    I would start with the macro recorder, and build from that.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4