Search results

  1. P

    Treeview with VBA (instead ActiveX)

    Well the provided sample works fine in Access 2007. In the help form it says: The subTreeView is a form but functions as a control, enabling you to simply drop it in as a subform in any form of your choosing. -> this doesn't work for me. I'd like to simplify the whole thing but the sample is...
  2. P

    Treeview with VBA (instead ActiveX)

    I found a very nice example of how to implement a Treeview with VBA, without ActiveX/mscomctl.ocx: http://www.jkp-ads.com/articles/treeview.asp Unfortunately I'm not capable to use this example for my access database. Has anybody ever tried this and can someone provide a simple implementation...
  3. P

    Migration to Visual Studio?!

    With "more stable" I meant that with my Access app there are always new errors resulting from incompatibilities between the app/Runtime, different MS Office versions and OS installed on the users's machines etc. In addition, Microsoft seems to focus more on VS so it's more like that new...
  4. P

    Migration to Visual Studio?!

    Hi there - with the release of Visual Studio Community Edition I'm thinking about migrating my Access App to Visual Studio VB.NET. I believe it would make the application more stable (less dependent from Access) - of course there are many other reasons. I'm interested to hear about experiences...
  5. P

    Question two versions on same machine

    Hi - so whould it be possible to force Windows to open an accde file with Access 2010 (Runtime) in case different Access versions are installed? Could you guys help? Thanks, Frank
  6. P

    determine if access runtime 2010 is installed

    @spikepl: Unfortunately I didn't find anything on a possible workaround.... @CJ_London: Inno is so much more flexible than the developer tools. And I don't think that the tools will force Windows to use the Runtime engine instead of switching a full version into Runtime mode. For me, the...
  7. P

    determine if access runtime 2010 is installed

    So in the meantime I found out that http://www.access-programmers.co.uk/forums/showthread.php?t=232883 So my question is: how can I force the system to use the Runtime engine??
  8. P

    determine if access runtime 2010 is installed

    accdr is nice. I used the .accde /runtime shortcut till now which works too, but the simpler the better. On my machine with Access 2010 full version and Runtime 2010 accdr opens in Runtime. On my partners machine with Access 2007 full version and Runtime 2010 the accdr file starts an Access...
  9. P

    determine if access runtime 2010 is installed

    I'm using Inno. Seems as if I have to give my goal to determine between Access full version and Access Runtime....
  10. P

    determine if access runtime 2010 is installed

    True, it's Office 14. Doesn't work either. It's exactly what I want: to determine if Runtime is installed, so that every user is running the app on the same conditions. And download / installation shall only be initiated if Runtime is not installed. Regards, Frank
  11. P

    determine if access runtime 2010 is installed

    Nothing! Well, I didn't post my problem here because I've a working solution elsewhere.... There are discussion on the topic - e.g. have I tried KEY_LOCAL_MACHINE,'SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access\InstallRoot but it's not working for detecting if AR 2010 is on the system or not.
  12. P

    determine if access runtime 2010 is installed

    Hi, I like to determine if a user has Access Runtime 2010 installed (because if not I want to start a download process and install it). Is there a unique registry key that I can check? Havn't found it despite extensive googling.... thx for help!! Frank
  13. P

    Determine exact string width (in pixels)

    Thx CJ, no, & is used in a company name. The same applies to -. I had come up with the same approach, but I thought there might be a good explanation and solution for this.... So now I am replacing same characters like & with similar characters like B before I determine the width...
  14. P

    Determine exact string width (in pixels)

    Just a short follow up question: function fTextWidth seams to ignore "&" which leads to unprecise results in case this character shows up. Can somebody help?
  15. P

    Determine exact string width (in pixels)

    Fantastic - I'm using the fTextWidth function and the results are quite precise. Thanks a lot!
  16. P

    Determine exact string width (in pixels)

    Hi there, I am working with the Access Treeview feature and I'd like to align the different elements in my nodes exactly below each other. Therefore I need exact distances (if string is longer then XY, cut short, if shorter, extend to XY). Of course I cannot work with len() and fill with...
  17. P

    Error: communicating with OLE server or ActiveX Control

    I had the same error and the only thing that helped was to change the system locale to the language used on the computer on which the app was compiled: http://windows.microsoft.com/en-us/windows/change-system-locale#1TC=windows-7 Now my question is whether it is possible to change the language...
  18. P

    Silent installation of Access Runtime 2007

    I thought a about a dialogue too but I'd like to keep it simple/professional. I've found this instruction for Acc 2010: http://fbinotto.blogspot.co.uk/2012/04/install-access-runtime-2010-silently.html Can anybody tell me if this would work for Acc 2007? Did anybody ever try this? Thx, Frank
  19. P

    Silent installation of Access Runtime 2007

    Hi there, I have integrated Access Runtime 2007 into my setup.exe (using Inno setup). Sometimes users are confused by the EULA agreement of the Runtime and do not install Access. Then my app won't work which is a bad start... So now I'm looking for a way to have a common EULA (for my app and...
  20. P

    Very strange Word behaviour...

    Solved! Thank you - I thought that the Word macro would not be executed at all but it was. Then I saw that I was not linking to the Access db correctly and the path to the temp txt file was not given at all for the Access db version (only when MySQL was used). Thanks! FRANK
Back
Top Bottom