Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Only What is Chosen

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Charles Phillips - 30 Jul 2007 23:59 GMT
Hello,
I am using MS-Access 2003.
I have created (copied) a process, that allows me to choose the User I want.
The Combo Box, allows me to type the letters of the last name of the User
whose data I work with.
The Combo Box gives a listing of ALL of the 1st letter of the last name of
the User.
Ex: S, displays S-Sz, then every letter after S.
I just want to see S-Sz, or C-Cz.
Can someone point me to some examples???
I have included my code below:

           Private Sub Combo90_AfterUpdate()
                   ' Find the record that matches the control.
                   Dim rs As Object

       Set rs = Me.Recordset.Clone
       rs.FindFirst "[ContactID] = " & Str(Nz(Me![Combo90], 0))
       If Not rs.EOF Then Me.Bookmark = rs.Bookmark
   End Sub

Thank you,

Charles L. Phillips
KARL DEWEY - 31 Jul 2007 00:48 GMT
No code needed.

Set the Auto Expand property of the combo box to Yes.

Signature

KARL DEWEY
Build a little - Test a little

> Hello,
> I am using MS-Access 2003.
[quoted text clipped - 20 lines]
>
> Charles L. Phillips
Charles Phillips - 31 Jul 2007 18:27 GMT
Hello,
"Thank You"...

Charles L. Phillips

> No code needed.
>
[quoted text clipped - 26 lines]
>>
>> Charles L. Phillips
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.