Recent content by GrexP

I guess I'm not explaining this properly. THE PROBLEM is that the data is not structured in a way that the query you wrote above would work. That is THE PROBLEM. There are no fields called "Active" and "Inactive". If it was structured that way then the query you wrote would work. In fact, that...

We use Access with SQL server quite a bit at work. SQL Server is the back-end, of course, and then we use Access as a front-end so that the mere mortals can run reports on their own. We also have some VB6 & VS2005 .Net front-ends for both Access and SQL Server. We create zillions of reports...

RainLover, Thanks for the feedback. Your first post does give me some ideas. The tblStockTake used in the example is structured differently, which is my problem. Mine is a poorly structured table. Restructuring the table is obviously what I need to do, unless someone more clever than I can come...

I have a many table with list of dates showing an active and inactive status of people. The table has 3 columns like this… Person ID Status StatusDate 14589 Active 06/01/2007 14589 Inactive 10/14/2007 14589 Active 09/22/2008 78569 Active 05/02/2006 78569 Inactive 07/04/2007 78569...

You've got it in the first message. Paste that code in a module window and press F5. It will create the table for you.

Due to federal regulations, and the fact that I would be fired on the spot, I'm not allowed to post patient's medical information on the web, or any where, for that matter. That was the reason I posted to the code in the first message that will build a table of sample data.

I'm not sure how your query will return the desired results in all cases if I don't know that the two labs in one day are the same or not. This happens in a small number of situations but that is really the crux of the problem. Getting something to work 90% of the time was never an issue. What I...

That would have been nice.Oh well, Anyway, the code worked fine. I can export 27 queried tables lickity-split.

Excellent! Thanks Bob. I didn't realize the TransferDatabase would do individual tables like that. I also wasn't familiar with "DROP TABLE". I was planning on "DELETE * FROM tblName". Can I assume that the "DROP TABLE" will help to keep the mdb file from bloating in size and cut down the need...

I need to set up an automated process to transfer data from about 25 tables from one database to another. This will happen on a weekly basis and I'm wondering what the best way to set this up is. Both are Access 03 db files. The main database has data for a dozen or so clinics and I need to get...

Parameters, yes, I think that is the key. If a routine in a module is expecting a parameter it will not run when you press F5. If it has no input parameter it will run. Thanks.

In a module sometimes pressing F5 runs the code and sometimes the macro window comes up. What determines the behavior? Access 2003.

Yea, it is something with the Eval(). It is like passing the function through another compiler or something and the stack order gets lost. If I call the function in traditional manner, in code, and comment out the Eval() call, the error handling works as you would expect. The calling procedures...

Good guess, but I check that. It is set to "Break on unhandled errors". I even shut down Access and restarted thinking maybe Access was "lost". Same behavior.

Right, that is how it is supposed to work, but its not. There is not one "On Error" line in the entire module, and all functions in the module are called by the event in the form. The event in the form has the error handling, yet the functions in the module break on error. The error is not being...