hi,
I have now imported my app from 97 to 2007 and its now about 98% working, thanks for the previous information the guys on this forum gave me. Out of almost 100 forms doing different things the problems were small once I figured out what was happening. Mind you it did take hours and hours of hair pulling to figure out some of the simple issues. Now the whole program is working again apart for some basic but crucial elements.
I have 3 things not working.. The first is filters, the second is shortcut menu bars and toolbars, the third is getting rid of all the unwanted access menus (but I have not looked at this yet, I am guessing it will be simple)
For now I would like to fix the filters as they are a major component.
For example: I have a combo box where after the selection is made it runs the command form the AfterUpdate:
Docmd.Applyfilter, "[method]=forms![main]![combo32]
I have a series of these on this form, the form opens through query which presents records between certain dates, this works fine...
There are numerous combo boxes that run different filters, and some also can filter and print direct to a report.
The first time I select the filter it works fine. But the next time it fails.. If the filter returned 25 records the first time then each time I select it after that it returns one less and stays on the original filtered data..
This has driven me crazy for about 4 days, I have read and read about this on forums and typing into google to see what returns, I even got out 4 books from the library but they are no help, after reading on forums I have used all wonderful things such as:
Me.FilterOn=True
Me.FilterOn=False
Me.FilterOn=""
I have tried there above in different arrangements with my filters and I cannot get it to work.
Does anyone have any ideas..
I have now imported my app from 97 to 2007 and its now about 98% working, thanks for the previous information the guys on this forum gave me. Out of almost 100 forms doing different things the problems were small once I figured out what was happening. Mind you it did take hours and hours of hair pulling to figure out some of the simple issues. Now the whole program is working again apart for some basic but crucial elements.
I have 3 things not working.. The first is filters, the second is shortcut menu bars and toolbars, the third is getting rid of all the unwanted access menus (but I have not looked at this yet, I am guessing it will be simple)
For now I would like to fix the filters as they are a major component.
For example: I have a combo box where after the selection is made it runs the command form the AfterUpdate:
Docmd.Applyfilter, "[method]=forms![main]![combo32]
I have a series of these on this form, the form opens through query which presents records between certain dates, this works fine...
There are numerous combo boxes that run different filters, and some also can filter and print direct to a report.
The first time I select the filter it works fine. But the next time it fails.. If the filter returned 25 records the first time then each time I select it after that it returns one less and stays on the original filtered data..
This has driven me crazy for about 4 days, I have read and read about this on forums and typing into google to see what returns, I even got out 4 books from the library but they are no help, after reading on forums I have used all wonderful things such as:
Me.FilterOn=True
Me.FilterOn=False
Me.FilterOn=""
I have tried there above in different arrangements with my filters and I cannot get it to work.
Does anyone have any ideas..