Recent content by hafod

Many thanks Combo. Now OK Hafod

Thanks for reply. Agree with your post (Have written DB Add Ins as well). My error - Should have stated my application Add In issue relates to Excel97 - sorry so an XLA file type.

Hi, Over a year ago I wrote an Add In for Access 97. I password protected the ASdd-In which I recorded. However, I can recall how to unlock the Add - In for editing. In the VBA Editor I double-click on the Add In which responds correctly with 'Project Unviewable'. Ithought this action...

Hi Hugh, Excellent! manythanks for your posts - now have a working solution. Mike

Hi Regarding Hugh's solution Perhaps a little premature with my last post. Solution launches all executables in the default list displayed in the 'List1' box. The default path for the displayed files is 'C\program files\MicrosoftVisualStudio\VB98' where several executable files reside and can...

Hi Hugh/Dilettante, Thanks for your last post Hugh. There was a typo - corrected by pasing your code. Incidentally, my post was unclear - I am using three 'boxes' to customise a file management interface. Thanks again. Thanks also dilettante. Will also try your approach to develop my VB codind...

Hi Hugh, Thanks very much for your post. I have entered your suggested code (I am not really conversant with Win 32 API). VB reports an error 'Expected: Lib" and highlights 'Shell32.dll' in the 'Private declare ....' line of code. I have included this line in the Generaal - Declarations part of...

Hi I am using the Common Dialog Controls: FileListBox, DriveListBox and DirListBox (es) to select and launch applications. Whilst the process of displaying all folder files in the FileListBox is straight forward I am having difficulty getting application files (Access .mdb) to launch when...

Hi Many thanks for your post. I am using VB6 under Windows XP (and will be for some time - Wait for a 'mature' Vista release!). I take your point on ADO as a means of using Data Forms and will need to invest more time in this direction. I know Crystal Reports was shipped as a third party...

Hi I have completed an application using VB6 and DAO rather than ADO recordsets. There are various requirements to display the retrieved data on a Form (as in the Access Report Generator) for subsequent viewing and printing. I am having problems getting the report - named 'drSubscriptionsLog'...

Many thanks again Mike ;-}

Hi Many thanks indeed for your last post - problem resolved ad your solution works fine. I added a command button to the destination form - Form3 to confirm I could do basic recordset programming tasks on the common data set - and yes, I can (simple code for this 'test' button on Form3 below...

Hi Many thanks for your response SBerthold. (Im glad you correctly interpreted my post!) I have tried your DAO code. A DBGrid on the 'calling' form works well against a sample database in 'c\temp' sub dir. However there is an offending line of code - syntax probably on the destination, which...

Hi, I hope I phrased this post correctly, possibly not! Currently I have a dBGrid object which is data bound to a DAO recordset on the same form. The recordset datMembers' is linked to 'tblMembers' in the back end MSAccess98 database using a 'Dynaset' type recordset. All works fine! However...

Many thanks dilettante, gmmastros and dglienna for your very helpful contributions on this topic. I can now proceed to further develop my dB VB6 database application, pending of course the next problem. But, the challenge is to resolve these problem oneself first before seeking the help of...