Search results

Hi, I'm just wondering if there is any differences in writing queries in vba in different versions of access. i'm developing a search function in access 2000, but it doesn't seem to be working. however, the same code in access 2003 works fine. Here's an extract of the code when the search...

Is there a way of setting the columns of a subform, to what ever columns are used when a query is run? The query itself takes in user input and based on those requirements it displays the result in the subform. So, the columns of the subform (in datasheet view) doesn't stay constant.

Hi, I'm just wondering if it's possible to display the result of a query on a subform which does not have a relationship with any other table. What I'm doing is creating a search form where a query is built from the users input (through combo boxes and text boxes) of what table, attribute and...