Search results

Thank you for that helpful link. I examined your database and everything was explained very clearly. At this point I am already referencing everything I need and it all works just fine. My question was more of an opinion of a specific situation I was wondering about. I'm not exactly having any...

Good morning, I'm using one main form that contains any number of subforms. Each subform will have more subforms within it. So it's a three layer cake. Parent, Sub, Subsub. My question is about functions that run on the subsub forms. Should the functions be local to the subsub forms? Should...

If I create an Index on the MySql server is it still effective for an Access Query? The table analyzer tells me to create indexes on certain fields which I have done to the server. Do I still have to create the indexes locally for the ODBC Linked tables? I was just wondering. Any suggestions...

On the fly has been my common practice. Sadly I also used .EOF loops through recordsets for updating when a simple query would have worked 10x faster. But as the days go by I am learning. :)

I've been developing an application for almost 2 years now. It's come along very nicely. I recently needed to filter a report based on external data in another table, and the solution was to use a query. It solved my problem and also enlightened me to how powerful queries can be. My general...

Ok thank you. Fantasic site BTW. It has a tutorial section on lookups and queries. That is probably exactly what I need to do. :) Thanks a bunch. Dan

I'm curious if this situation is possible. What I have right now are two tables: Mechanics, Mechanic_Slips. The Mechanic table has various fields that describe each Mechanic. The Mechanic_Slips table has all recorded activity by each Mechanic. What I want to do is print a report based on the...