Search results for query: *

I have seen this done before but do not how how to make it work: I have linked my Access db to several tables in an Oracle database via ODBC. The Oracle database has an Id and password. I have seen someone put in a passthrough query that opened up the ODBC connection so that you did not have to...

I have added a button onto a form that runs a macro. The macro runs two queries and also closes the form that the button is in. For some reason, as soon as the queries are processed, the database locks up. The form never closes and I have to shut down the database. Has anyone ever run across...

A co-worker added the MonthName function to an Access 2000 db in a query. It works on his machine but not on mine and I cannot find out why. We both have Access 2000 on Windows 2002 OS. On my machine I get the following error message "Undefined function 'MonthName' in expression". I...

I need to take a list of names in one table (Table A) and search for that list in another table (Table B). The names can exist in any of several columns of names in Table B. I need to start at the right-most column of Table B and search each column, by row, to the left until I find the matching...

I need to write a query to select data from a table, and then go back and select data from the same table based on different criteria excluding any data selected in the previously run select statement. For example, I have a two tables: Table 1 has three columns: Name 1, Name 2, Data 1 Table 2...