I'm trying to figure out how to link the database app to the form screen with a public module method, but without an object. I want the database query method to be seperate and in its own form code window.
-
Re: I need help...
Tue, September 7, 2004 - 12:28 PMIf you're more specific, I might be able to help you. -
-
Re: I need help...
Tue, September 7, 2004 - 12:33 PMWell, I want to get the form app for the database to use a public method from a module to link to the form. The query method doesn't have to be in the same code window, and it would be better if it wasn't. That way I could put the SQL package in the upload buffer. -
-
Re: I need help...
Wed, September 8, 2004 - 6:22 PMI recomend setting a reference to the ADO object model in a sub form then accessing it through dynamic instantiation. Once you do that, your query method should be a piece of cake. Be careful if your using windows authentication though, it can block many of your proceedure calls thus yeilding inconsistent data results. Good luck, let me know how it turns out. -
-
Re: I need help...
Thu, September 9, 2004 - 6:56 AMIt worked like a charm. Thanks.
-
-
-
