Recent content by omodarah

Hi Insane_ai, Thanks for your response, however I found the solution via the MSDN. I needed to have a toggle switch to turn off or on the properties as required. I defined a function to change the properties and presto it work Here is the link to the MSDN article...

Hi All, I have a Database created in 2003 and locked down using a custom menu, bypasskey and startup options. Everything looks good until I save it as Access 2007 which is the new target OS for the applications. Firstly my user defined menu is gone and I now have gaping holes in my security...

The problem was that I was basing my Chart on a Query as opposed to the Table. The query always recalculates on open. Problem solved.

Dear all, I have what I hope is a simple problem, but one if I dont solve will become a nightmare to manage. I have an application that need to provide set Pivot Chart views for Management to look at and I just found yesterday that I cannot save a Pivot chart in Access 2003 or 2007. When I...

Thanks for the clarification. Best wishes and I am sure you will be hearing from me in the not too distant future :D

Thanks for the clear explanation. That was one of the first places I went to look. What I didnt know as you explain is that if the version of the ActiveX Data Object is higher than the Data Access Object it would take precedence. Well we certainly live and learn. I guess I will pay more...

Banana, You are the Top Banana, the King of all Banana's. Dim rst As DAO.Recordset Worked a dream. Thanks a lot. You just saved me hours of searching...

Hi Banana, I just copied the Table, renamed it and tried and I still get the same error. The Table is not linked and I am able to open it directly. I have other forms referencing the table with no issue, but this is the only one that uses the particular failing code. How can I double check...

Thanks Banana 18_SvrTns is the name of my Transaction Table. In hindsight I should probably not have started it with a number. Unfortunately all my tables begin with numbers. This means I have to make major changes to rename everything from Queries, to Forms to modules. Are you certain this is...

Dear all, I have a wierd problem. I developed an App in 2003 and converted to 2007. when I try to open a form, I get a Type Mismatch error. I debugged and found it was on the following statement; Set rst = db.OpenRecordset("18_SvrTns") "18_SvrTns" is my server transaction table. can you...