Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Clear Combo Box Selection on refocus
Try adding this to the "On GotFocus" event for the combo box. (Combo name).Value = "" (Combo name).Requery Replace (Combo name) with the name of your combo box. This isn't the cleanest way to do it, but it should clear the combo box everytime it receives the...- lillypad
- Post #2
- Forum: Microsoft: Access Forms
-
Now() Function Help Needed ASAP
Not sure which library it's in, but I had the same problem with an Access database on a new computer. I had to have our I.S. department do a full install of office to get it to work (which it did work just fine after that). Lillypad- lillypad
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Combo box - display more than one field
You can do this by changing the "Row Source" for the combo box to a query rather than direct from a table. Here is an example that I used to display UserLastname, Userfirstname from a combo box. SELECT Users.UserID, [UserLname] & " " & [UserFname] AS Expr1 FROM Users; You...- lillypad
- Post #3
- Forum: Microsoft: Access Forms
-
Saving an OLE Object to original file name.
I am creating an Access database which will store generic files as OLE objects in a backend MDB (No problem with this so far). I can import the files to the MDB programmatically and I can extract them using the Object Packager->File->Save Contents option. I would like to be able to save the...- lillypad
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
