Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~243 People Reached
Favorite Forums
Favorite Tags
Member Avatar for raniel1314

[CODE] Option Explicit Dim rs As ADODB.Recordset Dim savePurpose As String Private Sub getData() Call EnableEntryControls(False) lvRec.ListItems.Clear Set rs = GetRecordset("Select * from tblDocSched") If Not rs.EOF Then 'records exists Call SearchMode(True) While Not rs.EOF lvRec.ListItems.Add , , rs.Fields("PhysicianNo").Value lvRec.ListItems(lvRec.ListItems.Count).ListSubItems.Add , , rs.Fields("PhysicianName").Value lvRec.ListItems(lvRec.ListItems.Count).ListSubItems.Add , , _ IIf(IsNull(rs.Fields("Department").Value), "", rs.Fields("Department").Value) …

Member Avatar for AndreRet
0
243