MajP

Thanks MajP, i will post a new thread now.

HI! MajP, how are you sir, i have been working on a project, have a difficulty in converting txt file data into access because of the spaces in the text file where i am not able to import into access. you had helped me on a similar text trim, but this is of different nature. Would you mind helping me in my project. below is the link of my text file which you had helped me earlier.
https://www.access-programmers.co.uk...=300423&page=3

i will wait for your reply. Thanks MajP

good morning
I don't know if you have gotten any of my responses. I'm not quite up to the 15 posts yet. I did receive your code to help my security login form which now gives me a syntax error. Hopefully, I can find the space or comma. I'm working on another database for the same veterans non-profit to track the assistance given the veteran. The problem I'm having with that one is, I can seem to count a yes/no field on a report. Can you help? I was trained on Access 2001 but, I'm now using 2016 and can't find the right function. Would Dcount work? Should I put the count in the query?
I really hope you get this. If this one counts I'll be up to 13 posts, but I still have problems getting back to my responses on this forum. Thanks again Debbie

HI! MajP, wanted to be your friend, and hope to be in your company to learn vba code.
I am learning vba coding and like the power of access, but unfortunate i have less knowledge, however i have the passion but unable to understand the basic concept. if you wanna accept my friend request.