Hi guys,
I have a database which is going to be used in network of the company.
I have defined authorized Domain usernames and Computer Names in a table.
There is a Login form in which I placed a code to get the computer name and domain username to compare with the ones I have defined in the mentioned table.
The problem is that the defined phrase is text, but I don't know what kind of data the gotten computer name is!
For example I have defined a computer name like Smith in the table that has 5 characters and also there is a domain computer name with Smith name but vba doesn't detect them equal and shows Len of the gotten computer name as 255.
How can I convert that phrase to its real number of characters??? :banghead:
Any helps will be appreciated,
Thanks
I have a database which is going to be used in network of the company.
I have defined authorized Domain usernames and Computer Names in a table.
There is a Login form in which I placed a code to get the computer name and domain username to compare with the ones I have defined in the mentioned table.
The problem is that the defined phrase is text, but I don't know what kind of data the gotten computer name is!
For example I have defined a computer name like Smith in the table that has 5 characters and also there is a domain computer name with Smith name but vba doesn't detect them equal and shows Len of the gotten computer name as 255.
How can I convert that phrase to its real number of characters??? :banghead:
Any helps will be appreciated,
Thanks
Last edited: