Search results

I am navigating through a few unbound forms using a global variable to get set the recordset. That in its self was difficult for me to grasp at the begining, but now I realize that you can use Querydef to do much thesam thing. In your opionon, which is the best or most efficient way to do...

I need to declare a global variable so it can be used by several forms. The forms will open another form, tied to the record. I was using something like the following to put the data into the sql query, but now that the project has grown and additional functions need to be added, this form...

I know that this is more than likely very easy, but I can not seem to get the language right. I am trying to append all records from table 1 where the feild closed in table 2 is checked. I can get the append to work using the query generator in access, but I am trying to minimize the use of...

Is it possible to pass a number from a textbox into a TOP clause query?

All I have a textbox that contains values seperated by a comma (exampel: tree, boat, house). I am trying to do an sql query that builds a table from another table only if the record has either of the items listed in the field. If I have only 1 item in the text box (boat), the table is built...

Experts Here is what I have currently going on. On my form there is a list box (multiselect) that creates a criteria that is passed to a query. The problem is that I dont like the way the form looks with this huge list box. I would like to replace the listbox with a combobox and allow...