Search results

I have a current database that will open up other databases and run macros. The current database has a form which lists out the path of the other databases and the macros that need to be run. Currently all of this works fine. However, we are finally moving over to Windows 7 & I am running into...

Changing the CancelDate to a Text field did the trick. I went back to the very 1st section of code you provided and started playing with it. This code seems to run much, much quicker. The biggest issue was the difference in OrderNums but I can work around that by creating another Current and...

The process you list out is what I am looking for and during my tests of this new code it appears to be working but I do have 2 issues/questions: If the CancelDate column is a Date field then does something special need to be used in order to evaluate that field properly? Currently if there...

For the output table I'd like to have two columns. One with OrderNum and the other with Changes. Changes justs needs to list out the columns that had a value change (including Null changes). I do not need to capture the value of the change, just the column name. I do not need to account for...

Thanks for your reply. The query pieces seem to work very well except wtih Nulls. The queries are not recognizing when a column changes from or to Null. Is there any way to account for changes to/from Null? I also played around with the code you provided for making the tblChanges. When I...

I am not sure if my question should be posted here or under queries but I thought I'd give this a shot. I'm new to the forum and by new means an expert with Access but I can follow directions and usually tweak other folks' stuff to get it to work for me. Anyway, I have two tables (Current and...