Search results for query: *

That's great! Thanks for the response!!! I will definitley use it now!!

Thank you! That's it!

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...

Now you KNOW that isn't what I want to hear. I am having a tough time learning vba - not sure of the best way to get started. any suggestions? Candy

I can run the macro with AND without the Close Form piece and from the macro itself, it runs fine. However, I attach that macro to a button on a form, and it locks up. I also tried it with and without Close Form from the button as well and no dice. However, I removed the Echo - Off part of the...

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...

Daniel, The elusive MonthName function frustrated me completely yesterday!!! I used the Format function and voila! problem solved. Thank you so much Daniel! John, I wasn't aware of the MonthName function either and since it is not available to me in the function menu then I wish I had never...

godawgs: I think you are exactly right, but we cannot figure out which reference we may be missing. The problem is that while my co-worker was out on leave for a broken leg, his hard drive was replaced because it had crashed. After re-install, he no longer has the functionality either :( I am...

This is not code in a module. It is a built-in function in Access so there is no VBA to go and look at. Candy

This is the code: 'Department DIM DMT_EFF_ENDDT: MonthName(Month(([DMT_EFF_ENDDT]))) & ', ' & Year([DMT_EFF_ENDDT]) It is not referecing anything external, it is simply that the functionality is not working in my version of Access an dI cannot figure out why. The "Depart DIM DMT...&quot...

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...

Rudy's solution was correct as stated above for anyone wanting to follow up. CandyT

Rudy: I fyou are willing to share an email address I can send excerpts of the table and the query and results I got. CandyT (Candy.Turbeville@wachovia.com)

Rudy: I love the tip and will have infinite uses for it. Thank you!! Unfortunately, it still doesn't quite do what I need. The Exists sub query would have to look for matches outside of the specific row. The match might exist on another row in the column of names. I am still searching......

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...

The reason a straight Union query won't work is this: the list of names in Table 2 can be as follows: John Smith Joe Brown Ginny Robinson Table 1.Name 1 can be John Smith and on that same row, Table 1.Name 2 can be Joe Brown. A Union query will select both, matching my names (correctly) to...

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...