Posts by Rafael Carmanini • 43 points

• 1

  votes

  1

  answer

  504

  views

  A: ADO Command / Parameter in Excel (VBA)

  Hello, The problem has been solved. I was not removing the command object parameters from the old queries, so the object performed certain action with incompatible data. I added the following…

  excel vba ms-access

  answered 9 years, 2 months ago Rafael Carmanini 43

• 2

  votes

  1

  answer

  504

  views

  Q: ADO Command / Parameter in Excel (VBA)

  Hello, I am developing a code in VBA in Excel 2010 in conjunction with a database Acces 2010. In this code, I use ADO Command to manipulate the data in the database, but I am receiving an error…

  excel vba ms-access

  asked 9 years, 3 months ago Rafael Carmanini 43

• 1

  votes

  2

  answers

  189

  views

  A: Search for results in related tables

  Hello, Try to use this code: SELECT * FROM tabela INNER JOIN tabela_usuario ON tabela_usuario.id = tabela.created_by WHERE tabela.status='open' ORDER BY tabela.priority DESC…

  php mysql

  answered 9 years, 3 months ago Rafael Carmanini 43