Recent content by Bram de Groot

  1. B

    list filenames without path

    That's what I was looking for! Thanks!
  2. B

    list filenames without path

    I managed to list filenames using the following code: With Application.FileSearch .NewSearch .LookIn = MyValue .SearchSubFolders = True .filename = "" .FileType = msoFileTypeAllFiles If .Execute() > 0 Then For i = 1 To .FoundFiles.Count rstmdb.AddNew...
  3. B

    export forms to other databases

    For some logistic reason I thought it would be better to split my database into separate databases with the same forms and since I don't really like to copy/paste and rename for x times I was looking for a way to create new db's and export all tables and forms in VB. Now, I reconsidered the...
  4. B

    export forms to other databases

    I used the suggested code in my export module but I don't see any results. No forms are exported, but it doesn't give errors. I tried to print the frm.names with your sample code, but that also doesn't seem to work. I don't see the frm.names printed in the directview. I'm just a beginner with VB...
  5. B

    export forms to other databases

    I want to export forms to other databases. I managed to export tables with: Dim db as DAO.database Dim tdf As DAO.TableDef For Each tdf In db.TableDefs DoCmd.TransferDatabase acExport, "Microsoft Access", strdbpath, acTable, tdf.Name, tdf.Name Next I want to do the same thing with forms but I...
  6. B

    move tables to other db

    Works perfectly! Thanks! Bram de Groot
  7. B

    move tables to other db

    I want to move tables into new databases and since there are quite a lot of tables in my database I want to automate this procedure in VB. suppose I want to move table1 to database1 , table2 to database2, etc.... Can anyone help me out? Thanks! Bram de Groot
See more
Back
Top Bottom