Search results for query: *

Have you tried specifying a directory rather than a null string? I've had problems in the past with PDFs and specifying a path has fixed it. You could also check the result returned by ShellExecute as this normaly tells you why it's failed. These are the errors I usually check for. Const...

Just in case this will be useful for anyone else here's my final code. I've got a picture box on the form called RepPreview and you'll need to reference the dsofile.dll file which can be found at the link vidru provided above. 'This goes in the general declarations Private RPTProps As...

Spot on thanks Sindo

Hi vidru, Hmm looks like you might be right :( Thanks Sindo

Hi storm75m, I used to do exactly what you do now but moved over to Access/SQL 2000 about three years ago and we are now virtualy 100% VB/SQL 2000. Firstly yes there is a performance gain to be had by 'late' binding and pulling data directly from SQL, especially if you are using stored...

Hi 6kleg, I use the "Microsoft ADO extension for DDL and security" in a VB app to add/remove/rename fields and tables in code when I release a new version of our application. Do a search in google for ADOX and you should find some example code - I'd include mine but it'd be huge and I'd have...

Hi Carva, Heres the code I always use when opening external files from VB and it should also work in Access. It uses the windows API shellexecute which basicaly just tells windows to load the file with whatever program is associated with the extension (it's the same as typing something into...

Does anyone know how to show the 'Preview Picture' for a crystal report in a VB6 app ? I have a selection screen that allows the user to pick a report and I want to add this feature so they can find their reports quicker. Cheers Sindo

Microsoft have removed direct support for ISAM linked Foxpro tables from Access 2000-2002, we had a similar problem here when we upgraded. Microsoft will tell you that you now have to setup an ODBC Data Source and then link it that way. However we found this option can be very slow with the...

We have a split database as discussed above. We use MS SQL 2000 to store the data (currently 8Gb, several million records) and an Access 2002 front end, which is stored on the server (50 users). We wrote a VB program that checks an INI whenever it's run, which tells the program which Access...

Your best bet is to use the GetVolumeInformation API function to retrieve your hard disks serial number and then use that for copy protection. This will certainly be the easiest and quickest option. This is the link to the function http://216.26.161.91/vbapi/ref/g/getvolumeinformation.html...