Search results

  1. Y

    I forgot to tell you - when you login, just login as Bob and use password pass . you can...

    I forgot to tell you - when you login, just login as Bob and use password pass . you can then access the Maintenance menu and change you login name and make a better password. See you John
    • Yianni
    • Profile post comment
  2. Y

    Hi, Take a look at Protoype HTH John

    Hi, Take a look at Protoype HTH John
    • Yianni
    • Profile post comment
  3. Y

    Hi, Shouldn't the payments relate to the tblProjectDetails instead of the tblProjects. This way...

    Hi, Shouldn't the payments relate to the tblProjectDetails instead of the tblProjects. This way you will allocate the payments to the specific part of the project that you want? We can always get the total for the project. John
    • Yianni
    • Profile post comment
  4. Y

    More ... 3) After we populate the field ProjID in the table tblProjectDetails with the...

    More ... 3) After we populate the field ProjID in the table tblProjectDetails with the corresponding number, we will not need the field ProjectName in the tblProjectDetails. 4) I have a couple of screen clips for you screen clips. Review my suggestion and the screen clips. If I may be of...
    • Yianni
    • Profile post comment
  5. Y

    Hi, I have reviewed your database and see that you have thought through many issues. 1) I...

    Hi, I have reviewed your database and see that you have thought through many issues. 1) I suggest that you use the Autonumber field in tblProjects as the unique number for each project. Access will manage it, keep it unique (never duplicate it) 2) Use the same field name (ProjID) in the...
    • Yianni
    • Profile post
  6. Y

    Make a number field behave like an autonumber

    Hi, Take a look at the following. DMAX is the way to go Private Function AssignNextCheckNum() As Long Dim LargestChkNum As Long LargestChkNum = Nz(DMax("ChkNum", "CheckRegT", "AccountID=" & AccountCombo), 0) LargestChkNum = LargestChkNum + 1 AssignNextCheckNum = LargestChkNum...
  7. 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
  8. Y

    Solved Code syntax help

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

    Solved Code syntax help

  10. Y

    Solved Code syntax help

    Thanks so much for the advice. I will follow your advice. john
  11. 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...
  12. 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...
  13. 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...
  14. Y

    Solved Code Library

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

    Solved Code Library

    Thanks for the help. john
  16. 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
  17. 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
  18. Y

    Mail Merge Headache

    Why not use a make table query?
  19. Y

    Solved Code Library

    I am looking for Information/examples of creating a Code Library that I can reference in Application Thanks
  20. 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...
Top Bottom