I would suggest that you use ADO to do the logic bit before populating the flexgrid.
Alternatively you could do some code in Access to filter your records and then get the resulting recordset.
Access doesn't support PL/SQl or Transact SQL Stuff.
Don't know if this is still of any interest to you, but I had a similar problem which I only managed to resolve by running the latest Hot fix for CR9. I'm now on version 9.2.3.666 which seems to have sorted the problem
Sorted!
When the user had the machine upgrade the default email software had been left as Outlook Express and not Outlook, this was then causing the problem with MAPI.
I've tried this using GetSetting. Getsetting simply returned the default, when I look in the registry under the path, the data value says 'MS Exchange Settings'. Show this show the current user? or does the registry not allow me to see the details.
I have a program which checks for emails using Outlook using MSMAPI32.ocx.
The program has been working fine until a recent upgrade on a colleagues machine to service pack 3 for office. The program on this machine now causes run time error 32003 at the mapiSession.signon line of code!
Any...
did this problem get solved as I have the same issue. Think it's to do with the fact the the person who's machine it doesn't work on has Service Pack 3 for office on, while the others all have service pack 1.
I Want the background of my toolbar images to change in line with the desktop colour settings.
I have a toolbar linked to an imagelist.
I have inserted a gif with a transparent background into the imagelist list, however the image always appears on the toolbar with a white background or...
I have a Crystal 9 report viewer on a form in my VB 6 app. I amend the SQL for my report before opening the form with the viewer on.
When I open the form, the report displays, however I have to click on the Refresh button within the viewer to Refresh the data. I have tried calling the refresh...
I wish to add a Crystal 9 report to my app. I have added the Crystal components and added a designer to my app. When I right click on the report inside my application I have the option to Save as Crystal Reports file. However if I then go into the saved file in Crystal itself and make changes...
I can put a flag in the change event to tell me that the text box has been modded. Unfortunately the change event is triggered every time that I do a movenext.
I would need to set a flag every time I do a movenext, to tell me not to change the MDI menu, then if the change event is triggered...
Thanks. I've already tried the ADO WillChangeField event. However this again doesn't trigger until focus has moved from the text box. I presume the rsADO_FieldChangeComplete event fires after the willchangefield.
I have a MDI database application. Text Boxes on a child form are linked to an ADO recordset. I want to update the MDI menu to highlight 'Save Changes' when I change data in one of the linked text boxes.
In most instances I can use the validate event to detect changes. However, as this event...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.