Search results for query: *

Hi I am trying to get some code working as described on the Microsoft KB 285822 in order to identify recent Access 2003 users. ( Source: http://support.microsoft.com/?kbid=285822 ) I want to identify which users have been recently connected to the database, even if they are now disconnected...

Thank you to Zen37 and dk87 for your posts. There are multiple network cards so I have tried unchecking the bindings. This also looked promising as a solution as the connection order was incorrect with the "Local Area Connection" to be used being listed last. Unfortunately it has made no...

I have a problem with one PC on a network that is always showing a delay with certain commands. This was first seen with the loading of IE and outlook, as a delay of about 25 seconds occurred between clicking the icon and the application appearing. Further investigation has shown that this...

I have a problem getting a report to return the correct results in Crystal Reports 8.5 when using DISTINCT. I have set up the report to access the required tables and the SELECT...FROM... statement is correct. For example: SELECT DISTINCT A.1, B.2 FROM A LEFT OUTER JOIN B ON A.1 = B.1...

I have an ExecuteSQL task which calls a stored procedure then follow a success or fail path depending on the outcome. I need the stored procedure to make a few simple checks against data, and if the data is bad/missing, exit and raise an error. The DTS ExecuteSQL Task should then follow the...

The closest option available under the MSChart control seems to be VtChChartType2dBar. Either can this be made to display horizontally or how would I access the stacked bar options you mention above? Thanks

Please could somebody tell me if (and how) it is possible to produce a horizontal bar chart using VB6 - I have tried the MSChart control but can only get a vertical bar chart. My aim is to show the groups on the y axis (e.g. months) and the values extending horizontally on the x axis (e.g...

Thanks, but 'cn.ConnectionTimeout = 0' appears to prevent a timeout and will cause the connection attempt to wait for longer. What I need is for the attempted connection to error as soon as possible when the server is unavailable (or the address is incorrect). Is this possible? Thanks

I am trying to make & test an ADO connection to SQLServer7. The routine works fine if the details in the connection string are correct, or if either the uid/pwd is wrong. However if the server does not exist, the connection waits for approx 1 minute before returning the error...

The problem is still not solved... I have tried reading/writing cookies using the 'use CGI; $query = new CGI;' method and it works fine if no form data is parsed. If I include a call to parse form data (using a parsform script from matt's script archive) either before or after...

I have a problem with a script which I want to read a previously set cookie when a form is submitted. The aim is to check the value of the cookie, then process the form depending on the result. The read cookie routine (example from script below) seems to work only when there is no form parse...

I need to create & show a Gantt chart within a VB application. I have done this before in Excel (with a modified bar chart) but can't get anywhere close with VB chart controls - I can't even get a chart to display horizontally. Any help/pointers greatly appreciated. Thanks!

Thanks very much, I got it working in a couple of minutes! Simple when you know how...

A beginners query... I want to set up a generic function (see below) to set each column width on a Flexgrid in VB6. At the moment it should pass the form name, control name and up to 10 values (width), then set each column to the appropriate value. Please can someone help with how to...