Search results

Hi Guys, We have an app extensively used in our organisation. I am revamping it. I decided to move dozens of queries (ran one after the other in Marcos) to SQL Pass through Query using CTE. That worked fine. I reduced the numbers of queries (and so the maintenance) by a ten factor ! and now...

Thank you for your help I am using a query that is a kind of 'base' for multiple reports and forms in the app. I prefer doing this in this case rather than multiplying the number of queries. But it is something I thought of. You were right, there was a field (in the control source) that was...

Hi, Here is my problem: I have a report in which I need to dynamically update some labels and control sources. When I run the report, all labels are correct, all data are correct. But Access ask me for the value of the field I update the source. He is asking me : "Enter the parameter...

Guys, I have a problem I can't understand. You may have already experience this. We have in our company Access db that were designed in version lower than our current (access 2007). In some of those access db, users used some linked tables (through ODBC connection on MS SQL). We needed to...

thank you for your help I'll look at it deeper. Seems that it will help. Dirk

Hi Guys, I searched with my best friend Google on the entire web and could not find any correct answer to my question: why MS Access 2007 does not allow to get object dependencies for Linked Tables. Here is my pb: I have a db that have more or less 100 linked tables and more or less 200...