Search results

lol You are correct sir. I have the following for First Name in the Assets Table: SELECT Users.ID, Users.[First Name] FROM Users ORDER BY Users.[First Name]; I have this because I made a drop down on my Assets form to tie each asset to a particular user. This was the only way I could think...

To clarify, if I run the query itself, the data displays correctly. When the data displays in the unbound object (list box) it shows the First Name and Last Name fields as numbers. Why is it showing numbers in the list box but not in the original query? Any help would be greatly appreciated.

Awesome. Thanks. :)

Ok, I'm loving the site. I added my picture but for some reason I can't get it to show up with my posts. What's the magic password to get the two together on here? :cool:

I do routine maintainence on all of our users PCs and have been trying to RDP to them instead of physically going there. Plus I use RDP to manage my servers from one location. I'm going to download Terminals and check it out. Thanks. :o)

I'm trying to fix this design flaw. I have broken the Employee field up into FirstName and LastName fields in both the Users Table and the Assets Table (and associated forms and queries of course). So, now I have the Assets.FirstName & Assets.LastName fields populated by a query from the...

Hey Coach. Thanks for all your help on my double-click issue. Now that I got everything working I've been brainstorming and while looking through the ActiveX control options I saw an RDP Client Control object. I found your discussion...

Thanks Coach. I understand Where clauses for the most part. But I don't see where the "where" clause is in the code. Here's the code I'm using: DoCmd.OpenForm "Users", acNormal, , , , , Me.User I'm not trying to use a command button. I'm using a combo box that has the User name associated...

Greetings. I have an Assets database and I have an Employee field that is a combo box. The combo box has a row source gathering the first name and last name from the Contacts table. I found code to make it so that if I dbl click on the Employee field on my Asset form, that it opens the...