Results 1 to 16 of 16

Thread: [RESOLVED] Creats an access database

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2005
    Posts
    118

    Resolved [RESOLVED] Creats an access database

    Hi All,
    I have recently downlodaed some code that displays images which i have found very useful. In the sample app that i downloaded there was a form that let you create access databases. I clicked it and hey presto it created a database! only problem is I have searched through all the code but I cant work out how it does it????. I have included the code below that starts when you click the make database button.
    If anyone could help me out I will be over the moon....
    VB Code:
    1. Private Sub LaVolpeButton3_Click()
    2.     With frmMain.CommonDialog1
    3.         .DialogTitle = "Create a very new database"
    4.         .Filter = "Archive Design Database |*.mdb"
    5.         .Flags = cdlOFNExplorer Or cdlOFNHideReadOnly
    6.         .FileName = ""
    7.         .ShowSave
    8.     End With
    9.    
    10.     If frmMain.CommonDialog1.FileName = "" Then Exit Sub
    11.     'filecopy copies a file -which file?
    12.     FileCopy App.path & "\shell", frmMain.CommonDialog1.FileName
    13.  
    14.     If TestDb(frmMain.CommonDialog1.FileName) = True Then
    15.         srcDB = frmMain.CommonDialog1.FileName
    16.         lblDatabase.Caption = srcDB
    17.         frmMain.loadcat
    18.         frmMain.ListView1.ListItems.Clear
    19.     End If
    20.    
    21. End Sub

    Thanks
    Franki
    Last edited by Hack; Jun 13th, 2006 at 10:51 AM. Reason: Added [vbcode][/vbcode] tags for more clarity.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width