Recent content by David Sinclair

Wanting to control a Third Party Application from Access 2003 on a Vista Based machine. Once it has the focus the 3rd Party Appliaction can be controlled through "Hot Keys". My objective is within the VB code that I use to control my Access Applicantion I need to be able to shift the focus to...

Thanks for the info on your experience with Windows Media Plyer. Now having a look at VLC Media Player to see if I may be able to communicate with that. http://www.videolan.org If you want to have a look.

Your suggestion of using SendKey commands is valid but the issue is that not all DVD’s have the main movie as Title 1 this can change. What Access has to do is tell the player to first select the folder, then the title and finally the Chapter. Programs like PowerDVD must record this...

Wanting to know if any one has code examples to have Windows Media Centre or maybe Cyberlink PowerDVD, load and play a predetermined DVD Tile & Chapter. Wanting to list in a table various scenes or chapters from DVDs that are stored on a HDD and have Access play these. Currently have Access...

Thanks for the examples given, This has given me someting to work on. I have been using DAO to get out the field names for the indexs and was endeavouring to have code printout the Multi-Field name along with the sort order for that index. Wanted to make something that looked like the Access...

What I am wanting to do is compare the index's between databases on two different computers after doing a design change on the master. Looking for code that will display the index's fields name, including when there is an index that is of a multi-field type. I presume one needs to loop through...

Have the situation where a database backend is on a number of sites and if changes have to be made to the design structure of the backend database I would like to run a VB generated report to check that all indexes are correct. While this is not an issue with single field indexes, I have issues...

Access 2003 does have the ability to change printer settings in code. Its all very simple, its just that everyone else is using Access 2000. Thanks for looking into this.

There is quit a lot of correspondence about fixes relating to margin problems. Currently I don’t have an issue with margins, it using different paper sizes that I am trying to resolve. I have heard that it can be done using API calls at the time a report is loaded but have not yet come across...

Have done as suggested; currently have SP3 on both the development machine and on a second computer. Have turned off the Auto Correction facility under options, created an MDE file, copied it to the second machine and on opening the report the report opens as the default paper size A4. What I...

One of the problems with Access 2000 is that when you build a mbe database and distribute it to others custom paper setting revert back to the default for that machine. Does any one have any experience of setting paper size in code for an mde database?

Would someone provide advice on how to have Windows Explorer open in a particular folder. The code below works as long as the folder name does not have characters in the folder name, e.g. commas. Sub OpenExplorer() Dim strFolderName As String strFolderName = "C:\Demo, Level1"...

FMS Have a Solution Have a look at purchasing this products. Have used it for about 5 years with good results. http://fmsinc.com/products/memo/index.html

Have a procedure that copies files to from Folder#1 to Folder#2, (Using Access 2003, Windows XP) then after the files have been copied then deletes Folder#1. The problem is that am unable to delete all the subfolders as one of these end’s up with the error, access-denied. Use the Kill...