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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Chip Pearson's DistinctValues fctn, Run-time error '13': Type mismatch
Hi All I'm trying to use Chip Pearson's DistinctValues() function (http://www.cpearson.com/excel/distinctvalues.aspx) which should be pretty straightforward (following is just the relevant code): Dim SdqAllIDsSSRSArray, SdqUniqueIDs, BigBoxArray() As Variant Dim LastRowSdq As Integer...- alevol
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
Switch vs Mapping Table (how to use "greater then or equal to")
Hello All I've been using Switch() in queries, but want to change to the joined Mapping Table method discussed in thread701-1556644 An example of the Switch I was using in the SELECT statement: Switch( Schizophrenia_SeveritySum_Twin1 >= 12, 78, Schizophrenia_SeveritySum_Twin1 = 11, 76...- alevol
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
-
Altering validation rules for all fields in a table through VBA
Hi all. I'm new to Access and VBA. I have to change the validation rules of every field (except the record ID) in several tables that have about 200 fields each (they were made to for entering the answers of research questionnaires). I'm thinking the best way to do this is with a VB script. I...- alevol
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
