Search results for query: *

Ronny, Take the brackets () away from word._Application as it does not have a constructor. This line just sets oWord as type Application. Because there is no constructor, when putting brackets on the end, .net thinks you are declaring an array. So it should look like this Dim oWord As...

Thanks Bryan, That works great. Thanks for the help. If I ever have anymore troubles I contact you. Thanks Again Simon FAZTECH :-P

Bryan, I am developing some similiar code and the same problem. But when I try to declare WordApp as New Word._Application is tells me that "New cannot be used on an interface". My problem is that I need to close the instance of the document and application. Document.close does not...

In Notes UserId there is a setting to not request password for Notes-based applications. Then try this code and see how you go. (it will only work when Notes open, otherwise it ask for password) - its a start anyway Dim ms As Domino.NotesSession, md As Domino.NotesDatabase, mm As...

Hi, I require some assistance with sub reports in Access. I am using Access XP and am currently designing reporting facilities for a large database (which is based on a survey). Anyway, I have written code so that if there is no data for a report a label is made visible saying "No...

Hi I have just finished developing an application for a backpacking hostel and i am having some trouble with VB's Package and Deployment Wizard. The problem I am having is that it seems to pack it alright but it is in the deploying that there is trouble. I am using COM Objects and it all gets...

Thanks Michael Reid, over the last couple of days I have been looking it up and you are right on the bullet. I have written a function (below) that works quite well. I just placed it in a module and call it on all textbox and combobox got focus events. Thanks for your help ///Placed this in...

Does anyone know of a function that will detect the change of focus of a control on a form and then set the backcolour of the control. I know about lost and got focus but this is for a large application with about 30 forms and that means for ever control i must write two function. Anyone know...

I am creating an application using tab controls and I have just been redesigning the colour scheme of the app. It was all going well until I came to changing the backcolour of the tab control (SSTab Control). I does not allow you to change the background colour. I only changes the area behind...

Yeah thats the funny thing I dont even open it. I only ever open the database when I query or write to the database. So the database is actually closed. I have afunction in my DLL that opens and closes the database, So before I call a database function in the dll I call the openDB function...

Hi, I am developing a vb6 application with an Access 2000 backend(ADO). I am using com objects and have a function that will backup the database and save it with the date appended to it name in a sepeerate folder (i.e db01022001.mdb). I am using a file scripting object and just the copy file...

Hi, I am having some troubles with dates and sql. I am building a system that requires me to select a range or records between specified dates. As I am in Australia the dates that I use are in Australian format (dd/mm/yyyy). Well the problem is I know that Access Sql uses American format so...

Thanks guys. Dilettante I did what you said and it started to work but I have not quit finished yet so I will have to stay on project compatability. Chip H i am using Com so I will stay on Project Combatibility and when I am ready to Pack it up I will switch to binary compatibility(as...

Hi, I am currently creating an advanced booking system for a backpacking hostel. I am using VB6 with an Access back end. I am using dll's but I am having troubles creating the executable for the project and also creating the dll themseleves. When I try to create a .dll from the class or try to...

Thanks chance1234 I will have a go and if I run into any troubles I will give you a yell. I am trying to use the custom document properties at the moment but it doesnt look like it will work. Also looking at the possibilities of a .ini class module file to save and retrieve the data. Thanks...

Hi, I have designed a word template that builds a travel program booklet. The user can select the type of pages and the number of each and then the program will build each of the pages then create a contents page. The problem I am having is that when a page is created its name is stored in an...

Thanks Justin that worked great. Deetee2000, I made the help file with a program I downloaded from the net called Microsoft Help Workshop. First make a word file in format .rtf, with all you help documentation and then just follow the instructions outlined in Help Workshop. It is really easy...

I am trying to open a help file (.hlp) that i created in word. I have a form with a button ('show help') that I want to open my help file when clicked. I have not set a help context id I just want to open it. Does anyone know how to do this? Thanks Faztech ;-)

Opppps Sorry Topdawg put to many zeros in the random try between 100000 and 1000 Sorry Faztech :-D

Opppps Sorry Topdawg put to many zeros in the random try between 10000 and 1000 Sorry Faztech :-D