Search results for query: *

Hi, Thanks for your response. The DataArrival event is not firing at all in the server program. Nothing at all is being transferred. I have added code to the Error events of both the Client and Server winsock controls but nothing is being fired there either. As a test I used the VB help...

Hi All I am having an issue with a Winsock control where I have 2 pcs on the same network. I establish a connection from the first pc to the second pc with the following code: tcpClient.RemoteHost = "CNNNNNN" tcpClient.RemotePort = 11542 tcpClient.Connect I then check the value of the...

I had a similar problem to yours and the best way I found to get around the problem was to strip out all of the non-essential components out of the setup program. Here is a link to the thread I started for it. thread222-978818 cmahon

lgarner, Thanks for your help with this - I took out the $ sign before the include but it didn't work. I then tried using $INCLUDE and then the full path and it now works. Thanks for your help cmahon

Try putting a line of code in : debug.print Form.ActiveControl.Name and that will show you which control has focus

Hi All Firstly I'm not even sure if it is possible to do this but I'm nearly sure I saw it discussed before in Books. We have a zone file that currently contains all of our A recrods, CNAME Records and our Dynamic DNS records. This zone file is currently called company.int What I would...

Grab it with a debug.print means to put a line of code in straight after building the statemenet and then do a debug.print. So you would have: SQLString = "SELECT * FROM " & chr(32) & "DEVIATION SURVEYS" & chr(32) debug.print SQLString

Hi, I would have thought that having a space in a table name like that would be invalid - I would generally have called the table deviation_surveys instead. Can you query the table from any interface? Does it work in SQL Plus or Oracle? Would it be possible to create a view of the table...

I generally use Form.Load and then Form.Show when displaying forms. Many of my programs require loading another form from a double click on a row so it make sense for me to : Load Form1 'Set some values on Form1 Form1.Show vbModal It stops the screen from flickering and ,as JAG14 mentioned...

Hi Hugh You were right about the registering of the ActiveX components - I feel very silly for not having thought of that. It's working fine now when installed on new machines. Thanks for all your help. cmahon

Thanks for your response. I only have to reboot once, every time I login into the machine from then on is fine. The problem only occurs after I have copied the updated ActiveX exes and the .xla onto the client machines. I might try putting some code in to force a reboot after the program has...

Hi, I have a question regarding the distribution and installation of an Excel AddIn. We have a Document Management System in place for Word documents which is basically controlled by a macro and a few ActiveX exes that are included in the macro as references - this works fine for us at the...

Hi, Once you are finished sending and/or receiving data just put a line of code in saying sckserver.close and this will close the connection.

Hi, I had a similar problem in a few programs over the past few months, the problem has come up when we switched from 17" TFT monitors to 15" flat-panel monitors. As far as I could tell the only way of fixing the issue was to resize the forms to fit a standard 800x600 screen and rebuild the...

I think I've solved this now, it seems it's not as simple as intercepting the events, you need to re-assign the buttons to your macros.

Hi, I am having a bit of trouble with intercepting the FileOpen event in Excel using VBA. We have a Document Management System in place for Word Documents whereby a user logs into the system and can open and save documents into a central location, without having to use the File System. I am...

This has now been resolved.

Hi, We are currently configuring a SUSE Linux box to act as a DNS & DHCP server in our company. We can get the server to correctly assign an IP to clients and we have succesfully set up a records list of printer & server names and their relevant static IP Addresses. What we want to do now...

Thanks for your replies, I think it did have something to do with the version of MDAC. I did some research on the Microsoft website and I can basically remove all the components from the Bootstrap files area (except for VB6STKIT.DLL) and run a program called vbrun60.exe which installs the...

Hi All I'm sorry if this topic has been covered before but I'm really stuck at the moment and I can't quite figure out how to create an install program. I originally used the Package and Deployment wizard as included with VB and after succesfull installs on Win 98 machines I then tried to...