Toni Maxx: 2007

Dim strDataBaseName As String
Dim strDBCursorType As String
Dim strDBLockType As String
Dim strDBOptions As String
Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection

Private Sub Command1_Click()
On Error GoTo Command1_Click_Error
Dim b as Long
strDBCursorType = adOpenDynamic  'CursorType
strDBLockType = adLockOptimistic   'LockType
strDBOptions = adCmdText         'Options

Set cn = New ADODB.Connection
Me.MousePointer = 11

cn.Open ConnectString()
  
   With cn
       .CommandTimeout = 0
       .CursorLocation = adUseClient
   End With

   Set rs = New ADODB.Recordset       'Creates record set

   strSQL = ""
  
   rs.Open strSQL, cn, strDBCursorType, strDBLockType, strDBOptions
  

if rs.Eof then
  Goto ExitSub   
else
   For b = 1 To rs.RecordCount
 '
   Next b
end if
  
ExitSub:

rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing

On Error GoTo 0
Exit Sub

Command1_Click_Error:
   MsgBox "Error " & Err.Number & " (" & Err.Description & ")  & _
                    in procedure Command1_Click of Form " & Me.Name
End Sub

Private Function ConnectString() As String
Dim strServerName as String
Dim strDatabaseName as string
Dim strUserName as string
Dim strPassword as string

   'Change to IP Address if not on local machine
   'Make sure that you give permission to log into the
   'server from this address
   'See Adding New User Accounts to MySQL
   'Make sure that you d/l and install the MySQL Connector/ODBC 3.51 Driver

strServerName = "localhost"
strDatabaseName = "DatabaseName"
strUserName = "UserName"
strPassword ="Password"

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
               "SERVER=" & strServerName & _
               ";DATABASE=" & strDatabaseName & ";" & _
               "USER=" & strUserName & _
               ";PASSWORD=" & strPassword  & _
               ";OPTION=3;"

End Function

1-AakarshanAaliyah 2-AaronAasia 3-AbaddonAba 4-AbbaAbbey 5-AbbanAbbie 6- 7-AbbottAbelia 8-AbdelAbella 9-AbdielAbeo 10-AbdiesoAbey 11-AbdulAbha 12-AbdullahAbhilasha 13-AbeAbia 14-AbejundioAbigail 15-AbelAbijah 16-AbelardAbilene 17-AbenzioAbina 18-AbercioAbiona 19-AbernethyAbir 20-AbhayAbira 21-AbhiAbra 22-AbhijitAbrianna 23-AbhinavAbrienda 24-AbhishekAcacia 25-AbhorsonAcadia 26-AbiAcanit 27-AbieAcantha 28-AbielAccalia 29-AbijahAcedia 30-AbirAchal 31-AbishaAchazia 32-AbnerAchen 33-AbrahamAchilla 34-AbramAchit 35-AbrashaAchlys 36-AbsalomAda 37-AbudemioAdabelle 38-AbundiantusAdah 39-AcacioAdalgisa 40-AcarioAdalia 41-AccursiusAdama 42-AceAdamina 43-AcelinAdamma 44-AchillesAdana 45-AchyutaAdar 46-AckerleyAdara 47-AckleyAddi 48-ActonAddie 49-AcuzioAddisyn 50-AdairAddy 51-AdalardoAdela 52-AdalgisoAdelaide 53-AdalricoAdele 54-AdamAdelicia 55-AdarAdelina 56-AddaiAdelinda 57-AddisonAdeline 58-AddoAdelle 59-AdebenAdelpha 60-AdeiphoAdemia 61-AdelAden 62-AdelaisAdena 63-AdelardAdeola 64-AdelbertAderes 65-AdelfriedAderyn 66-AdelinoAdesina 67-AdelmoAdhira 68-AdelphosAdiba 69-AdemaroAdie 70-AdenAdiel 71-AdeodatusAdila 72-AdhamhAdima 73-AdinAdina 74-AdirAdishree 75-AdiranAditi 76-AdityaAdiva 77-AdlaiAdolfina 78-AdlerAdolpha 79-AdleyAdona 80-AdmesAdoncia 81-AdmonAdonia 82-AdnanAdora 83-AdneyAdorabelle 84-AdolfoAdorna 85-AdolphAdriana 86-AdonAdriano 87-AdoniAdrienne 88-AdonisAegea 89-AdonyAemilia 90-AdrastosAeryn 91-AdrianAffrica 92-AdrielAfina 93-AegeonAfra 94-AemiliusAfraima 95-AeneasAfric 96-AeolusAfrica 97-AeronAfton 98-AetosAgape 99-AfroAgate 100-AgaboAgatha 101-AgamemnonAggie 102-AgatoneAglaia 103-AgilardAgnes 104-AgostoAgneta 105-AgrippaAhava 106-AguAhimsa 107-AgustinAhnada 108-AhabAhneta 109-AhearnAhuva 110-AhmedAi 111-AhmikAida 112-AhrenAidan 113-AidanAide 114-AikenAideen 115-AilenAiesha 116-AimeryAijah 117-AimonAiko 118-AindreasAila 119-AinsleyAileen 120-AitanAilis 121-AjaniAilish 122-AjatashatruAilsa 123-AjaxAimee 124-AjayiAin 125-AjitAina 126-AjitabhAine 127-AkaashAingeal 128-AkamaAinhoa 129-AkandoAinsley 130-AkbarAintzane 131-AkelloAirlia 132-AkilAisha 133-AkimAisling 134-AkiraAislinn 135-AkivaAissa 136-AkiyamaAithne 137-AkramAiyana 138-AkselAja 139-AkshayAjay 140-AlAkaisha 141-AladdinAkako 142-AlanAkala 143-AlandAkana 144-AlarbusAkanke 145-AlardAkanksha 146-AlaricAkasma 147-AlasdairAkela 148-AlastairAkila 149-AlbanAkilah 150-AlberAkili 151-AlberichAkilina 152-AlbernAkina 153-AlbertAkriti 154-AlbinAksana 155-AlbionAkshita 156-AlcanderAkuti 157-AlcibiadesAlaine 158-AlcottAlake 159-AldenAlala 160-AlderAlameda 161-AlderneyAlana 162- 163- 164- 165-AldousAlaqua 166-AldredAlarice 167-AldrichAlastrina 168-AldridgeAlatea 169-AldwinAlavda 170-AldwynAlazne 171-AlecAlba 172-AledAlberta 173-AlejandroAlbina 174-AleronAlbinka 175-AleserAlcina 176-AlessandroAlda 177-AlexAldabella 178-AlexanderAldara 179-AlexasAldea 180-AlexisAldercy 181-AlfonsAldonza 182-AlfonsoAldora 183-AlfordAlejandra 184-AlfredAleka 185-AlgerAleksandra 186-AlgernonAleksia 187-AlgrenAlena 188-AliAleshanee 189-AlikaAlessa 190-AlimAlessandra 191-AlisonAlesti 192-AlistairAleta 193-AlisterAlethea 194-AllambeeAlex 195-AllanAlexa 196-AllardAlexandra 197-AllenAlexandria 198-AlleyneAlexavia 199-AllighieroAlexia 200-AllisterAlexina 201- 202-AlmonAlexis 203-AlokAlfonsa 204-AlonsoAlfreda 205-AloysiusAlgerine 206-AlphonseAli 207-AlphonsoAlia 208-AlricAlice 209-AlroyAlicia 210-AlstonAlida 211-AltairAlike 212-AltmanAlima 213-AlunAlina 214-AlvahAline 215-AlvinAlinga 216-AlvisAlisa 217-AlwanAlisha 218-AlwinAlison 219-AlwynAlissa 220-AmadeusAlita 221-AmadiAlithia 222-AmadoAliya 223-AmadorAliz 224-AmalAliza 225-AmarAlize 226-AmaroAlka 227-AmarooAlkina 228-AmatoAlkira 229-AmbarAllayna 230-AmbertAllegra 231-AmblerAllene 232-AmbroseAllie 233-AmeryAllirea 234-AmherstAllison 235-AmidaAllora 236-AmielAllunga 237-AmiensAllyson 238-AminAlma 239-AmirAlmeda 240-AmiriAlmedha 241-AmirovAlmira 242-AmistadAlodia 243-AmitAlodie 244-AmitabhAloha 245-AmitavaAlohi 246-AmmonAlona 247-AmolAlonsa 248-AmonAlonza 249-AmoryAlouetta 250-AmosAloysia 251-AmritAlpa 252-AmsdenAlpha 253-AmulAlta 254-AmulyaAltair 255-AmundAlthea 256-AnandAltheda 257-AnantAlula 258-AnastasiusAluma 259-AnatoleAlumit 260-AnayAlva 261-AncelAlvina 262-AndersAlvira 263-AndersonAlvita 264-AndreusAlyna 265-AndrewAlysa 266-AndroclesAlysia 267-AneurinAlyson 268-AngAlyssa 269-AngadaAlzena 270-AngeloAma 271-AngusAmabel 272-AngwynAmadea 273-AnieliAmadi 274-AnilAmadika 275-AnirudhhAmadis 276-AnishAmadora 277-AnistonAmaia 278-AnjumanAmala 279-AnkerAmalie 280-AnkitAmana 281-AnkurAmanda 282-AnnanAmandeep 283-AnniruddhaAmandine 284-AnnoAmandla 285-AnokeAmani 286-AnokiAmara 287-AnoopAmarante 288-AnsariAmaranth 289-AnscomAmarina 290-AnselAmaris 291-AnselmAmaryllis 292-AnshulAmata 293-AnshumanAmaya 294-AnsleyAmazonia 295-AnsonAmbar 296-AnsticeAmber 297-AntalAmberjill 298-AnthonyAmberley 299-AntigonusAmbika 300-AntiochusAmbra 301-AntipholusAmbria 302-AntonAmbrosine 303-AntoniAmdis 304-AntonioAmeerah 305-AnuAmelia 306-AnwarAmelinda 307-AnwellAmena 308-AnyonAmes 309-ApacheAmethyst 310-ApariAmi 311-ApemantusAmice 312-ApolloAmina 313-ApostolosAminta 314-AquilaAmira 315-AraAmisha 316-AraluenAmissa 317-AramAmita 318-AranAmitola 319-AranaAmity 320-ArchardAmoke 321-ArcherAmorina 322-ArchibaldAmorita 323-ArchidamusAmrita 324-ArchieAmy 325-ArdenAn 326- 327- 328- 329-ArdleyAnais 330-ArdolphAnamika 331-ArdonAnan 332-ArenAnana 333-ArendAnanda 334-AresAnani 335-ArgusAnar 336-ArgyllAnastasia 337-AriAnata 338-AricAnatola 339-AricinAnaya 340-ArielAnca 341-ArikiAncelin 342-ArionAnchoret 343-AristedesAncika 344-AristoAncilla 345-AristotleAndea 346-ArizonaAndie 347-ArjeAndras 348-ArjunAndraya 349-ArkinAndrea 350-ArkwrightAndreana 351-ArlandAndria 352-ArlenAndromache 353-ArleyAndromeda 354-ArloAndy 355-ArmandAneira 356-ArmandeAnemone 357-ArmandoAneya 358-ArmenAnezka 359-ArmonAngela 360-ArmstrongAngelica 361-ArnallAngeni 362-ArnaudAngevin 363-ArneAngharad 364-ArnettAngwen 365-ArnieAniela 366-ArnoldAnika 367-ArnonAnila 368-AronAnisa 369-AronneAnita 370-AroonAnitra 371-ArpiarAnja 372-ArranAnjali 373-ArsenAnjana 374-ArsenioAnka 375-ArtAnkareeda 376-ArthurAnke 377-ArthusAnkita 378-ArtieAnn 379-ArtyAnn-Margret 380-AruiragusAnna 381-ArunAnnabel 382-ArundelAnnabeth 383-AruntaAnnalise 384-ArvadAnnalynn 385-ArvalAnnamaria 386-ArvinAnnapurna 387-ArvindAnnata 388-ArviragusAnne 389-ArwinAnneliese 390-AsaAnnette 391-AscotAnnice 392-AseemAnnika 393-AshAnninka 394-AshburnAnnissa 395-AshbyAnnora 396-AsherAnnunziata 397-AshfordAnona 398-AshishAnoush 399-AshlieghAnselma 400-AshlinAnshu 401-AshokAnstice 402- 403-AshrafAnteia 404-AshtonAnthea 405-AshurAntigone 406-AshutoshAntionette 407-AshwinAntje 408-AshwiniAntoinette 409-AsijaAntonia 410-AsimAntonie 411-AskelAnupama 412-AslakAnuradha 413-AsparouhAnusia 414-AstinAnusree 415-AstonAnvita 416-AsumanAnya 417-AsvathamaAnzu 418-AsvinAolani 419-AswadApanie 420-AswinApara 421-AsztrikAparajita 422-AtalikAparna 423-AtarahAphra 424-AtawnAphrodite 425-AthanApirka 426-AtharvanApolline 427-AthelstanApollonia 428-AtherolAponi 429-AthertonApril 430-AtholAqua 431-AthosAquamarine 432-AtillaAquaria 433-AtiuAquene 434-AtlasArabella 435-AtleyArabelle 436-AtmajyotiAraceli 437-AtmanArachne 438-AtraylAraluen 439-AtrusAraminta 440-AttilaArashel 441-AttisAraxie 442-AtulArcadia 443-AtulyaArda 444-AtwaterArdath 445-AtwellArdelia 446-AtworthArdelle 447-AuberonArden 448-AubertArdere 449-AubinArdine 450-AubreyArdis 451-AuburnArella 452-AudricAreta 453-AudunAretha 454-AugustineAretina 455-AugustusArezou 456-AurekArgenta 457-AurelioAria 458-AureliusAriadne 459-AustellAriana 460-AustenAriane 461-AustinAricia 462-AutolucusAriella 463-AvanArielle 464-AvelAriene 465-AvenallArika 466-AverellArilda 467-AverillArinya 468-AveryArista 469-AvinashAriza 470-AvivArlene 471-AvnerArlette 472-AvonArlynda 473-AvramArmada 474-AvromArmelle 475-AxelArmilla 476-AxtonArmina 477-AyerArmorel 478-AyhnerArmynel 479-AylwardArnalda 480-AylwinArnisha 481-AyushArnurna 482-AzariahAroha 483-AziArora 484-AzimArran 485-AzizArtemis 486-AzrielArtemisia 487-AzzanArti