• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. Y

    Looking for a youtube video

    Hi, Some time ago I found a youtube video which showed how to simulate handwriting (actually printing) with a picture of a hand, and the vba code and technique. I cannot find this video. Has anyone else seen it and know where I can locate it? Thanks
  2. Y

    Solved Code syntax help

    Thanks so much for the advice. I will follow your advice. john
  3. Y

    Solved Code syntax help

  4. Y

    Solved Code syntax help

    Thanks so much for the advice. I will follow your advice. john
  5. Y

    Solved Code syntax help

    Thanks for responding Hi, Thanks for responding. EDITED BY THE_DOC_MAN: ADDED CODE TAGS - NO OTHER CHANGES MADE Public Function GetLog() 'Public Function GetLog(myMainForm as string,myForms string) Dim UserID As Long Dim c As Variant Dim strSQL As String '------ Need to change...
  6. Y

    Solved Code syntax help

    Hi, Thanks for responding. Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:- https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Please feel free to Remove this Comment Public...
  7. Y

    Solved Code syntax help

    I am attempting to create a Function that receives 2 values -- myformname and mymainformname. I am not sure of the proper syntax with the " Can anyone help? In the next line of code I want to replace CustomerF with the passed myformname value For Each c In Forms("CustomerF").Controls...
  8. Y

    Solved Code Library

    Thanks, I will follow up Thanks, I will follow up john nks.
  9. Y

    Solved Code Library

    Thanks for the help. john
  10. Y

    Mail Merge Headache

    There is no SQL as the source. The question involved a compiled. Library that I could reference in my Access program. Thanks John
  11. Y

    Solved Code Library

    I guess I need to clarify -I am looking for specific procedure as how to create the Library . A how to! Thanks. John
  12. Y

    Mail Merge Headache

    Why not use a make table query?
  13. Y

    Solved Code Library

    I am looking for Information/examples of creating a Code Library that I can reference in Application Thanks
  14. Y

    Loop through Form Objects

    Hi Again, I have modified your code. I am not a skilled programmer, so it may be crude, but it does what I was looking to do. I am enclosing it for your review. I know it needs to be more elegant but, hopefully that will come. Please feel free to send ways to make it better. Function...
  15. Y

    Loop through Form Objects

    Hi Mark, Thanks for the quick reply. I have been working today on modifying code to change labels on a new form. I am not a masterful programmer, but I am enclosing what I have done for your review. It may be crude, but now does what I am looking to do. I am sure it can be more elegant, but...
  16. Y

    Loop through Form Objects

    I want to thank you for the code. I so study it and adapt as I can. Can you help me understand these lines If ctl.Name = "theNameOfLabel" Then frm("theNameOfLabelHere").Caption = "xxxx" End If I don't understand the first 2 of the 3 lines above...
  17. Y

    Loop through Form Objects

    Hi, I am looking for suggestions and direction, so I can develop a function to allow me to loop through my forms and change names on labels etc. Any suggestions are welcome. Thanks yianni
  18. Y

    What's your best/worst joke?

    If it is appropriate, you may post it. Four old retired men are walking down a street in Yuma, Arizona . They turn a corner and see a sign that says, "Old Timers Bar - ALL drinks 10 cents."They look at each other and then go in, thinking this is too good to be true. The old bartender says in a...
  19. Y

    What's your best/worst joke?

    Congratulations! You have me by 1. I have 1 granddaughter and 1 grandson. They are great to be with. Playing games we haven't played in 30-40 years. Old fashion Monopoly etc.
  20. Y

    Help with vba code

    I am enclosing a screen clip of results. It certainly picked up the A and C as needed. However; why does it not start at the 1's? What did you do to pickup up the A's? You are on the right track! 168 A 171 A 174 A 176 A 176 C 178 A 178 C 178 C 179 A 179 C 179 C 179 C 181 A 181 C 181 C 181 C...
Top Bottom