Recent content by cariengon

I'm trying to create a query that contains several Iif statements. I have a total of 14 within the query. When I add one more - it gives me the "Too Complex" error. I only need to add one more and I have no clue as how to call a function from a query. Can anyone help? Here's my sql...

I think I have it, but I don't know if this is possible, or quite how to do it. I'm automating the import of 6 files and I want to have as little user intervention as possible. Right now I have the user having to find each file - the program steps them through it. But I was thinking that it...

This was exactly what I was looking for!! But I have a question for you to see if you may know how to solve it. Access 97 - TransferText import. I have the user prompted to find the files to import - works fine, but the user has to go through a step to import a total of 6 files. I'd rather...

Thanks for such a quick reply! This sounds like a good workaround. How do I attach the code to the button? In the Control Properties, there is only a selection called 'On Action' which gives me a list of the Macro's, not the Event Procedures. Does it make a difference that I'm programming...

My code is attempting to preview a report, then run a msgbox that asks the user if they want to print the report. In the code, the msgbox appears immediately after the report opens in preview mode. I have tried SelectObject and GetFocus, etc. but the Report cannot be manipulated until the Yes...