[SOLVED]
When set Index Ascending a PLUS sign (+) apear before field name.
Sub acc2010_11()
Dim result As Boolean
result = False
Dim i As Integer
For i = 0 To CurrentDb.TableDefs("Services").Indexes.Count - 1
If UCase(CurrentDb.TableDefs("Services").Indexes(i).Name) = "MFT" Then
If...
Dear Expert
I want to check "SORT ORDER" of a specific Table's Index.
I write this code :
Sub acc2010_11()
Dim result As Boolean
result = False
Dim i As Integer
For i = 0 To CurrentDb.TableDefs("Services").Indexes.Count - 1
If UCase(CurrentDb.TableDefs("Services").Indexes(i).Name) = "MFT"...
Dear Experts.
I am new in Access VBA.
:confused:I want to find a value in a Filed(for example : stdName) of a Table (for example stdtbl) by VBA code in Access2010.
Need to sample code for do this.
any available?