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
Ranked #31.8K
~4K People Reached
Favorite Forums
Favorite Tags

5 Posted Topics

Member Avatar for BombAppetit
Member Avatar for swappy
Member Avatar for dinilkarun

Simple answer, no you cannot change individually a row in a list box, but what you can do is create a subform that emulates a listbox in the same way. obviously the subform itself will be designed bound to a table or query on your db and the data needs …

Member Avatar for vb5prgrmr
0
112
Member Avatar for 88omar

88omar, have you ever heard of arrays? I'm looking briefly at what your doing and the code looks extremely long and unneccesary. Why not create an array of the name 'Parish' for example then store all your values into that, and have things reference it.

Member Avatar for 88omar
0
135
Member Avatar for ohyeah

Private Sub cmdAdd_click() Dim str As String Dim rs As New adodb.Recordset str = txtfname.Value rs.Open "SELECT * FROM [Customer]", CurrentProject.Connection, adOpenStatic, adLockOptimistic ' With rs .addnew .Fields("FieldName") = str .Update .Close End With End Sub

Member Avatar for ohyeah
0
108

The End.