Search results for query: *

I noticed that you qualified your tables in your first example (exists), SELECT ADR_NO FROM ADDRESS A WHERE NOT EXISTS ( SELECT * FROM ADDRESS_OCC B WHERE A.ADR_NO = B.ADR_NO) but not the second (in). SELECT ADR_NO FROM ADDRESS WHERE ADR_NO NOT IN (SELECT ADR_NO FROM ADDRESS_OCC) I...

I am not really familiar with dsntaid as I prefer to use DSNTEP2 another db2utility. I believe that dsntaid does automatic commits and will actually keep processing until a pre-defined number of sql error have been encountered. I seem to remember having had this problem myself, which is why I...

If I understand your question correctly you will want to Create a query selecting the data you want to show in the combo box. In your query you can sort your data in the order that you want. Then look at the properties of your combo box: on the 'data'tab You will find 'ROW SOURCE TYPE' -...

Thanks to cmmrfrds and nberryman for the rapid response. I found a freeware utility on www.downloads.com that puts the contents of a directory in a text file that can be loaded into an excell spreadsheet. I can import this into an access table. The utility is called Directory Lister written by...

I am creating a database to organize a large number of jpeg files. I don't want to store the jpegs in access, just the name and location of each. Is there a way to import the names of the files from the directory into an excel spreadsheet, a text file or directly into an access table without...