Search results for query: *

Thanks John, I'll give it a try. Regarding the acknowledgement of helpful answers, there have been a number of times that I have clicked the "Thank ...... for this valuable post!" but it never seems to have worked at the time - I thought that perhaps it took a while to update. Just tried...

In the project that I am working on I have used the following code... Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Documents.Open ([path to document]) objWord.Visible = True which is working well. This launches Word and displays the document. I have been...

Thanks Patrick, Carl - the app I'm developing is in VB6 so, if you're interested I'll log the progress here. Unfortunately the site using Citrix is in a different state (of Australia) so I'll be relying on the good communication skills of their IT person to try to work through any problems...

Just wondering if anyone has had any experience running a MySQL application in a Citrix environment - I'm in the process of developing an application with MySQL as the backend and one of my potential customers has a Citrix setup and is looking for reassurance that the application will run OK...

Using VB6 my application allows the user to browse to a Word document and click on a .doc file. The path is saved and displayed as a label on a form which, if clicked, will open Word XP and display the document. There are however a couple of problems with this:- 1) It allways says the doc...

Thanks for your reply. The most likely hand-held scenario will be a situation in which users plug into the main database and download some data onto their device - then whilst they're offsite they may (for instance) record how long they spent with particular clients and what they were doing...

I'm exploring the possibility of tackling a project using VB6 and MySQL. Have never used MySQL before but from what I've read it seems that it should be OK with VB6. Down the track there is a possibility that users will require the ability to enter data via a hand-held device. Is VB6 +...

Thank you. That worked.

I need to remove a node from a treeview. When I run the code with this line... Set nodX2 = tvNodes(2).Nodes.Remove(tvNodes(1).SelectedItem.Key) ...the program stops with the word "Remove" highlighted and an error message saying "Expected function or variable." Any...

Is it possible to enable a panel (or frame) on a form to "fade" in/out? Have discovered how to do this with a form but would like to know if (and how) it can be done with other controls. Doug. "A nose by any other name still smells the same."

Hi Tom, It worked - brilliant - thanks for sharing that. I'm using VB6 with an Access 2000 backend - all the documentation/help files said that * is the wildcard, would never have thought to try % instead - not in a million years! Thanks again, Doug.

I am trying to open a recordset - ADO - that selects records on the basis of the first letter of a field eg. I want to find all the clients whose surname begins with "B". My SQL string works fine if I have ...LIKE 'Brown' - I can see a client whose surname is Brown. However...

I have a program that accesses an Access2000 database. Using ADO (VB6) it works fine with connection string - open recordset, I then load a popup menu from that recordset - no problems. One part of the program uses a data control [ADO Data Control 6 (SP4)(OLEDB)] which is the DataSource for a...

Does anyone know what are the constraints regarding using a program, (VB frontend, Access backend) developed for use on PC's/networks, on a PDA. In other words what am I likely to need to do to the program to make it PDA compatible? I've never used a PDA (or tried to get the program running on...

Hi Zor, just a suggestion as I've never actually attempted what you're doing, but you could try setting the forecolour of the column (or cell) that has the tick to white (or whatever the backcolour is) - then it won't be seen. Hope this helps. Doug.

Thanks for all your responses/advice - unfortunately since posting the initial question I've had to focus on a different project and have had to put the ".csv to .mdb project" on the back burner temporarily - so I have'nt had a chance implement any of the suggestions - probably in a...

Thanks, for that - the only thing is I need to code it in VB as the users will not be interfacing with the database directly (and some may not even have Access installed), they will only see the data via the VB front end. Each time they open the program it needs to compare the .csv file...

I'm working with an accounting program that can export data to .csv files (or tab delimited files ie .txt). I need to import that data into an Access database so that I can then work with the data via a VB front end. Would appreciate any suggestion re the best way to tackle this and whether...

In VB6 I have used flexgrid and modified the Column width in the code (the project needed the columns to be much narrower than the default). When I try to do the same in VB.net I am not able to as it is "read only" in code - however it is possible to set a property that will allow a...

A couple of days ago I installed VB.net on my computer. Today, when I go into a project developed in VB6 (which I don't want to upgrade to VB.net) I get a:- "Run-time error 438: Object does not support this property or method" message when it hits a line of code using the Val()...