Recent content by Santiago

  1. S

    Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

    June7 code worked like a charm thank you! Dim db As DAO.Database, rs As DAO.Recordset Dim xl As Excel.Application, wb As Excel.Workbook Set db = OpenDatabase("", False, False, Globales.ConnString) Set rs = db.OpenRecordset("SELECT Verificado, Factura, Fecha, NombreLocalidad...
  2. S

    Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

    Saw it working on it now! Will post results soon! Thank you!:D
  3. S

    Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

    No. It means there are no linked tables and I'm connecting directly to the server from my forms. So the Access file is a Front End and MySQL Server is my Back End database. I'll check what the string is printing in a bit. Thanks for the help!:D
  4. S

    Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

    I get Run-time error '3251': Operation is not supported for this type of obeject. And it shows me to this line: Set qdf = db.CreateQueryDef("qryTemp", SQL)
  5. S

    Save DAO MySQL QueryDef to a Temp Query and Output Results to Excel

    Hello good people! :D So I'm in the middle of this Access project where I'm changing every form to connect directly to a MySQL server instead of using local tables. I have been able to change everything correctly up to now. In one of my forms a use a botton to pass everything that has been...
  6. S

    Hello!

    Hi, Well my name is Santiago and I'm in the middle of completing an Access project and have come to a stump :banghead: so I thought lets use Google and found this forum :D Hope to get to know some of you, help some of you, and get help from some of you :)
Top Bottom