Recent content by MikeKIA

  1. M

    Delete tables VBA code

    Hi, I'm trying to delete a table once I've used it and always get the same error saying that the table is already in use, these are the commands I've tried: DB.TableDefs.Delete ("Report") AND strSQL = "DROP TABLE Report" DB.Execute (strSQL) Can't figure out how to avoid this. Please help Mike
  2. M

    Create table from a recordset

    I think I understand now. Thank you very much for the quick reply. Miguel
  3. M

    Create table from a recordset

    Yes, the query is done as in my original post. The problem is that I need to write it in vba and this code doen't let me create a new table. It's a vba problem....
  4. M

    Create table from a recordset

    Ok, thanks. But what I really need is to automatize it in vba for the source tables will vary....
  5. M

    Create table from a recordset

    Sorry but I'm still learning vba access. "Make table query"?????........
  6. M

    Create table from a recordset

    Hi, I'm trying to create a new table from another existing two in vba. I'm using this code without success... Any help will be gratefully taken. --------------------- Dim strSQL as string Dim tablaSuma As DAO.TableDef Dim rst As DAO.Recordset strSQL = "SELECT * FROM Necesidades_TRS1, Pedidos...
See more
Back
Top Bottom