Search results for query: *

Does anyone know how to check the status of a cursor? I can't find help on this anywhere. This is updating a table. When I do a count on the table I only get 96 people and I should get 134. My assumption is there are a bunch of people missing a record altogether so I want to see who they...

Hi, I want to put a file on a user's desktop, but I can't seem to find how to access that environment element. Seem to recall seeing a post in this group about it, but can't find it. Any help would be appreciated. Thanks, Tim Tim Rutherford www.Manna-Consulting.com

Currently, I am putting data into an adodb.recordset. I am using a field which needs to be decimal, but everytime I use it, the right side of the decimal is '00'. e.g. 15.35 comes in as 15.00. I have spent hours trying to find an example for this. I know I need to set NumericScale somehow...

Hi, I have a column which contains totals. I want to use SUMIF and add columns which have the word 'Total' but do not also contain the word 'Revenue'. Simple data layout is as follows; Col A Col B Revenue 1 50 Row 1 Revenue 2 175 Total Revenue...

Hi, When I try adding a sort to my adodb, I am getting an error, 'Wrong number of arguments or invalid property assignment'. I have checked all over for examples and can't seem to resolve this. The error occurs with the sort. Will someone point out what I am doing incorrectly? Thanks, Tim...

Hi, I am inserting a line with the following code, but I still get an error message even though I have .displayalerts = False. Any ideas or suggestions. Thanks, Tim Private Sub WorkSheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) Application.DisplayAlerts = False...

Hi, I am creating a spreadsheet using vbScript. The script creates a WorkBook_BeforePrint event and works fine. However, I don't want the VBA window to open when the user runs the script. Any ideas on how to suppress the VBA Window from opening? Const vbext_ct_StdModule = 1 Dim...

Howdy! Is it possible to supress headers (e.g. LeftHeader) on the first page of a printout? The client I am doing this for is using Excel 97. Suggestions and comments would be appreciated. Thanks, Tim

Is it possible to dump my email from my laptop into my home computer? If so, how? Both versions of Outlook are set up with the same settings and accounts. Thanks, Tim

I am trying to put a flat file on a user's desktop. Currently, I am just dumping it in 'C:\'. The application I am using only has vbScript available. Is there a way to put it on the desktop? Thanks, Tim

I am a newbie so I don't know if this is my problem or if I am just missing a setting. My program presents a question with a <cfloop> for the answers. The first page presents correctly. <!-- Display the Question --> 1) What color is the sky? <!-- Now display the answers. --> <pre><input...

Hi, I am trying to create a file name with an extention of YYYMMDD_HHMM. e.g. Employee.20020916_1336 Currently, when we run a global send the error messages are trapped in a file called employee.msg, which is fine unless we find we goofed on an employee and just process that one record...

Is there a function or does someone have one written which searches for a substring within a string and replaces it with another? e.g. MyString = &quot;MyLastName, Tim&quot;, MySearchString = &quot;,&quot; MyReplaceStr = &quot; &quot; The result being &quot;MyLastName Tim&quot;