Replies

I’ve found it best to use a 3rd party control for multiple columns in combo boxes. There are a selection of controls from BeCubed software that are solid, alternatively you can check out the full source from vbAccelerator for Steve’s owner drawn combo box – I think it has multi-columns.

http://www.vbaccelerator.com/home/VB/Code/…Full_Source.asp%5B/url%5D

I still can’t believe this was overlooked in the VB6 combo box, it’s so easy to do in MSForms controls – how hard would it have been for Microsoft to duplicate this??!!

Check out the ‘Microsoft Tabbed Dialog Control’ (tabctl32.ocx) which is multi-page & decent to work with.

Check out this particular submission which seems to be fairly complete…should demonstrate all the different Wininet APIs and how to use them…

http://www.planet-source-code.com/vb/scrip…=21186&lngWId=1%5B/url%5D

Thanks Hans…

Check out http://www.planet-source-code.com[/url%5D which has some excellent examples of this type of code. Do a search on ‘wininet’ or something similar & you’re bound to find something…

As Charlotte says, Sourcesafe has some excellent facilities for comparing source. You can also pin released versions & all sorts of funky stuff – definitely recommend this, it’s made tracking releases so much easier.

Thanks people, the ConvertAccessProject would’ve been perfect but I’ll just have to stick with the command line for now.

Wendell – We’re quite a large company (1000+ employees) dealing with lots of sales information. We converted to the MS Office suite from Lotus & as soon as Access was available, people were using databases rather than Lotus 123 for all their data projects! It’s a bit of a mess to be honest….they take up so much disk space & we really need to review all of them. That’s a tedious job though & one I may have to delegate….!!!

We have an application that delivers databases in the form of icons displayed in Listview objects, users just double click the icons to launch the database. All of the shortcut behaviour is hidden in the application, so they can’t see what’s happening.

We’re changing every user’s password to a generic password that no-one else but admin will know, then I can just pick up the user name using API and pass that & the password in the shortcut ‘behind the scenes’. Have tested & works a treat, so thanks to all at WOPR…!

For the meantime, yes – & maybe in about 6 years time we’ll upgrade to Office XP…!! But good to know enums are supported in later versions…

Thanks people, some good points here. The user/ and pwd/ shortcuts sound like the way to go for me.

Thanks again.

Yes, this is what we do for our DBs – but when you call like…

“C:Program FilesMicrosoft OfficeOfficemsaccess.exe” DatabaseName /wrkgrp WorkgroupFile

…it will prompt the user to sign on? For the life of the Application object you can open other secured databases from within the application without having to sign on but the minute the application is terminated (& hence the DBEngine), you will be forced to sign on again?

I’m trying to get round users having to see the sign on screen at all.

Thanks

Becuase I’m using enumerations & events that simply aren’t available in VBA. I’m using low-level IBM Client Access code, you can’t do it in VBA (office 97)

Maybe I’ll change it into an EXE so it runs in it’s own process…..that should sort it out.

Thanks anyway.

The DLL is a generic ‘Transfer’ utility , I want standard Access VBA’ers to be able to use this DLL from within their Access databases. Only a couple of users have full VB.

Thanks

Check out http://www.vbaccelerator.com[/url%5D for some excellent code & articles on Non-client windows stuff. Steve has written a ‘Neo Caption’ component that skins windows and repaints all the NC areas of forms, some good code & examples to get your head round this complex area…

Thanks for the reply, tried this out with my DLL but couldn’t find the window – it just doesn’t seem to be displaying in Access! Very strange, as all the code is running fine & it’s doing what it’s supposed to, you just can’t see the progress meter.

Thanks anyway