Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    402

    Re: Access: Change Query Sql with VBA

    Yes I admit, I use that method rather than continuation characters.
  2. Replies
    8
    Views
    514

    Re: Access: If Statement to Run Macro

    Hmm, strange.:confused:

    I did test in 2007 before I posted, as I was keen to know.
    Good to know though. Thank you.
  3. Replies
    2
    Views
    316

    Re: Access: Form w/table as Source Filter

    Why can't you use the filter



    Me.Filter = "Client Like ""*" & Me.txtFilter & "*"""
    Me.FilterOn = True


    Do you do any research before you post here. Google even?
  4. Replies
    8
    Views
    514

    Re: Access: If Statement to Run Macro

    No you can do it, do not even need the Application.Run, just use ModuleName.SuborFunctionName if the code is marked Private.

    HTH
  5. Replies
    15
    Views
    687

    Re: VBA write data from Excel to Access

    Use a recordset?

    https://www.exceltip.com/import-and-export-in-vba/export-data-from-excel-to-access-ado-using-vba-in-microsoft-excel.html

    Or with a query
    ...
  6. Replies
    4
    Views
    402

    Re: Access: Change Query Sql with VBA

    I always put my spaces at the beginning of the line. That way you do not have to scroll all the time to check your string.?

    Also I'd start using meaningful names for controls, Combo227 is not...
  7. Replies
    6
    Views
    554

    Re: how to update records through Forms

    Just bind the controls to the source data and it will do it for you.

    Use the form wizard to create a form when on the table or query that will be the recordsource for the form.
  8. Re: What guidelines I should follow while editing ‘Globe with blue arrow’ table

    It is as it states, edit any linked table desin wise in the back end, or delete the link and import the table into your front end.
    The latter is not something I would do.
    You can edit the table...
  9. Replies
    12
    Views
    750

    Re: What is early binding and late binding

    This explains it better than I could.
    From what you have mentioned so far, late binding woul dbe your choice and lose the vba intellisense.
    Alternatively develop in the same version.
    ...
  10. Replies
    3
    Views
    435

    Re: Access Split form Refresh Problem

    Not sure what else to suggest.
    I would have thought that you would execute a MakeTable query and not just open it.?, but that does appear to be one of the options?...
  11. Replies
    3
    Views
    435

    Re: Access Split form Refresh Problem

    Ever heard of the Refresh event for a form?

    https://docs.microsoft.com/en-us/office/vba/api/access.form.refresh

    However I think you would need the requery method, not the refresh?
  12. Re: "subform datasheet view will only allow me to edit when first opened"

    Well I'd start by seeing it it worlks when not filtered.?

    A lot of work went into the ESF on this link

    https://www.access-programmers.co.uk/forums/showthread.php?t=294421&highlight=emulated
    ...
  13. Re: "subform datasheet view will only allow me to edit when first opened"

    You just need a combo in the main form and a subform for that.

    I use the emaulated split form, but only as a replacement for a split form and make sure the datasheet/continous is read only. I use...
  14. Re: "subform datasheet view will only allow me to edit when first opened"

    removed
  15. Re: Tighten up vb code for Access Database

    Use the form's recordsetclone?

    https://accessexperts.com/blog/2011/05/23/when-to-use-a-forms-recordset-and-when-to-use-recordsetclone/
  16. Re: SQL query works in MS Access but doesnt when called from excel VBA

    Do you have On Error Resume Next at all?
    As when I try your code it falls over first with no variables defined (I use option explcicit)

    Then with the connection.?

    From...
  17. Replies
    1
    Views
    490

    Re: Access: VBA code for "Calculate"

    Me.Recalc ?
  18. Replies
    7
    Views
    1,006

    Re: Update Checkbox status

    No, bound controls refer to a form in Access. You are working in Excel and connecting to Access, so to my way of thinking these are unbound controls, and need to be refreshed.?
    Effectively though,...
  19. Replies
    7
    Views
    1,006

    Re: Update Checkbox status

    Ok, not something I have had to do yet.?

    However if controls are not bound (as yours are effectively not) then I believe you need to requery after any update.?

    So I *think* you would need to...
  20. Replies
    7
    Views
    1,006

    Re: Update Checkbox status

    Aren't you missing a With for the rs recordset?
    Plus is ID is numeric no need for the last set of quotes I would have thought.

    Have you tried walking through the code with F8 ?
    Could you not...
  21. Re: Update the imported fields with Replace function

    Could you at least post it, in case someone else finds they have the same problem.?
  22. Re: Update the imported fields with Replace function

    Try Cstr() function?
  23. Replies
    12
    Views
    2,271

    Re: VBA - Populate Word Document

    See post #10
  24. Replies
    12
    Views
    2,271

    Re: VBA - Populate Word Document

    Well it is going to be flaky if you just simply ignore errors.?

    Surround your form controls with the NZ() function.

    Fix the simple errors first before looking for bigger ones. Access sometimes...
  25. Replies
    12
    Views
    2,271

    Re: VBA - Populate Word Document

    Comment these out, so you can at least see any errors.



    On Error Resume Next
    Err.Clear


    Also walk through the code with F8 in the debugger instead of hoping for the best.:D
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4