Recent content by axionvb

  1. A

    (DQB) Dynamic Query Builder - Dynamically build VBA queries fast

    Hi ironfelix717, I did as you said. I created a database from scratch and created a form from scratch and added the codes. It doesn't give me this warning. There are no missing references. I am not getting any compilation errors. You can transfer the codes to the database file you created and...
  2. A

    (DQB) Dynamic Query Builder - Dynamically build VBA queries fast

    Dear ironfelix717, I rearranged the SQLSource property you wrote in the DQB class with the following codes. It seems to work. But it needs to be simplified a bit and it needs to be tested whether it fits every query shape. piece of code is a bit novice. Because when we find the related field, we...
  3. A

    (DQB) Dynamic Query Builder - Dynamically build VBA queries fast

    Hello, I found a piece of code like below. This code is returning all the associated table and field names in the database. connect this code to the table we are processing and use in your DQB class and then strSQL="FROM" For x=0 ..... strSQL=strSQL & T4 & " RIGHT JOIN"..... next If we can...
  4. A

    (DQB) Dynamic Query Builder - Dynamically build VBA queries fast

    Tekrar merhaba, İngilizcem için üzgünüm. Dosyayı yeniden oluşturdum. Dediğiniz düzenlemeyi yaptım. Çözüm önerinizi bekliyorum. Yapabileceklerim üzerinde çalışıyorum. Teşekkür ederim. Not: Bu bir google translate çevirisidir. İngilizcem çok kötü bu yüzden çeviri olarak yazıyorum. Google...
  5. A

    (DQB) Dynamic Query Builder - Dynamically build VBA queries fast

    Hi ironfelix717, I adapted the DQB example to my own database. Queries like "SELECT * FROM TableName ORDER BY ID" are fine, as long as the fields are text or numbers, there is no problem. Well, if the query is set with the search feature in more than one field in the table in the list box, how...
Back
Top Bottom