Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    160

    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?
  2. 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
    ...
  3. 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...
  4. Re: "subform datasheet view will only allow me to edit when first opened"

    removed
  5. 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/
  6. 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...
  7. Replies
    1
    Views
    441

    Re: Access: VBA code for "Calculate"

    Me.Recalc ?
  8. Replies
    7
    Views
    959

    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,...
  9. Replies
    7
    Views
    959

    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...
  10. Replies
    7
    Views
    959

    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...
  11. Re: Update the imported fields with Replace function

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

    Try Cstr() function?
  13. Replies
    12
    Views
    2,148

    Re: VBA - Populate Word Document

    See post #10
  14. Replies
    12
    Views
    2,148

    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...
  15. Replies
    12
    Views
    2,148

    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
  16. Re: Access: VBA to Make a Table from a Query

    Of course, but that will cause your db to bloat.
    Better to create the table once (either manually or via VBA) and the delete the records and append them each time.

    Just seen this on another...
  17. Replies
    5
    Views
    599

    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.?
  18. Replies
    8
    Views
    1,223

    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...
  19. Replies
    5
    Views
    710

    Re: AccesS Formula help

    Is the last IIF actually needed?
  20. Replies
    1
    Views
    440

    Re: Registration form - Ideas

    If the difference is zero, then disable the add and signup buttons/process ?
  21. 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...
  22. 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...
  23. 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.?
  24. Replies
    4
    Views
    1,382

    Re: Access Query

    Any errant spaces in Item ?
  25. Replies
    3
    Views
    971

    Re: Crash When Use SetWindowLongPtrA

    Seriously? :(
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4