Recent content by FloBob

Thanks Scott, I have tried group by queries but it does not produce one Username.. Maybe I haven't explained my problem with clarity. I would like a query that produces one username when I give it one computer. So that it will filter out all other usernames that might of logged onto the...

aye, I do.. the issue here is I would like it to be dynamic to populate both a form and a report. So that a computer inventory is constantly being updated. I would need solution that is not very cumbersome, I was hoping SQL had a function I had not been previously aware of. If anyone has any...

Thank you for your reply, however the issue is not the last user that logs onto the machine but the user who logs onto the machine most. The primary user so to speak. I believe that using date would only allow me to find the last user who logged on which I can accomplish with last(). Thank...

Situation: When logging into my network I record several key information about every computer. The only two fields that concern me at the moment are Username and Computername. I am trying to retrieve the user of each machine. My problem is sometimes users will log into machines that are not...

Yah its active X I currently use A2k so if you dont have the version I am not sure if you have that option or not... but I use it when I can. Anyway Does anyone have a solution to my original problem I am very excited to use this control but if it will not work properly obviously that means I...

TreeView full name is Microsoft TreeView control 6 (sp2) many people use them for menus, if you look up on the website for treeview I am sure you will find many entries. Basically if you go to explorer and look in the left hand window where you can plus and minus items and select from them...

P no thats a treeview... I just dont have any pictures attached to it. and I know how to place it on the tab.. what I am saying is when I run the form, from design view it pops the treeview up to the top left corner. I dont know why it does this because in design view it is firmly planted on...

I am having a bit of an issue using treeview with a tab control. Has anyone else had this problem? It is a hard issue to explain so I have attached an ss, but to be breif it seems that when you place the treeview on the tab itself and then run the form it places the treeview control in the top...

Not that this is a new thread but you want to look for posts on treeview controls, if you happen to see this message. I would say that this is a moderate programming task and not a novice one but with a little research I think anyone can figure it out(Sept maybe my mother in law). Gluck.

I would suggest that you copy the FE down to the local computer and a shorcut to the FE placed on the users desktop. Once the bat file is finished running just have the users double click on that shortcut. You can also do a zip extract but it doenst work aswell because it wont use operating...

here is a function that will remove all but alpha characters from a string. I will leave it to you to build a function to remove every character accept numeric ones from your string (for your phone numbers). What I did was convert the string to the ASCII numeric values of each character and...

Thanks... Nevermind though I had the sorted check box in the controls properties checked. That fixed it, thanks for the reply.

Does anyone know how to arrange the icons in treeview in a specific way.. not acending or descending but just how their inputed or whatnot. Im setting up a menu and woudl ranter have Exit the very last item. Thanks a bunch.

Welp nevermind it looks like I got beaten to the punch P...

You could use the random number generater to pick random numbers and then translate the results back to the letters. If you wanted the characters to be between 4 and 6 and a 2 digit number at the end you could do this: Function RanPass() As String 'Random Password Generator 'By...