Search results for query: *

Hi all, I am trying to reduce the size of the solid.db file, it is in a UNIX Solaris 8 environment, we have tryed a TRIM command but rather than reducing the size of the file, it expanded it by 2 GB. I am guessing that there is some kind of auditing or tracking on the database. Is there a...

Hi, Just wondering if I could plead for your help :p. I need to create a webpage that calculates the number of hours a project has been worked on from 08:00 to 18:00 every date. The function would be passed a start date and an end date and would need to calculate the number of hours that...

I just double checked and column I is the eighth column, the formatting is already in the column in the template as well, it was more deperation the additional formating code. But whilst it does change the format to date, it doesn't update the cell... which is annoying as it only updates the...

Hi, I am using the following code but it just copies the date out as a real number, not as a date. When I double click on the cell the number becomes a date... how do I make into a date automatically? AGE_COLUMN is a constant with the correct column number (8). dteInstallDate = "" &...

Thanks for your help, I changed the Format statements to reflect the date and time standard we use in our company (dd/mm/yyyy hh:mm:ss). (code included below). I have been calling the function as follows: If basWrkHrs(strCreateDate, Now) > txtLv1.Text Then booAddRecord = True txtLv1.txt = 6...

Hi, At our company we have to fix various problems with a pre-defined time frame based on the priority of the call or pay a substantial fine. For example we need to fix all Priority 1 calls within 6 hours. I have been asked to write a program which creates a webpage for our Intranet...

Hi, Sorry I forgot to mention, NULL is the cell name for an empty cell in my workbook. I have installed the Analysis Toolpak on there machines and it works fine. Thanks for all the help guys I was beginning to tear my hair out here! Tom. Webmaster of http://www.netepic.org The...

Hi, I have a created a spreadsheet which takes information from a SQL database and then checks the dates to how long it has taken my company to complete each call we take. On my machine the spreadsheet works fine, (I have Excel XP) however whenever I move it to another machine...

Hi, I have a created a spreadsheet which takes information from a SQL database and then checks the dates to how long it has taken my company to complete each call we take. On my machine the spreadsheet works fine, (I have Excel XP) however whenever I move it to another machine...

I need to link to the SQL server Remedy2 table T86. Anyone have any ideas how I can achieve this in Excel as I am stumped! Webmaster of http://www.netepic.org The EPICentre and owner of Minatures Online. (10% off all VOID goods!)

Hi, I run the following program and I get an error saying Run time error: 32026 Not supported On the MESSAGE_SEND line, any idea what I am doing wrong? Tom Sub Timer() SignOffMAPI SignOnMAPI ComposeSMSMessage SendSMSMessage SignOffMAPI End Sub Sub...

Hi, I found a solution, I unchecked the "Provide feedback with Animation" box and it seemed to slow it down to a manageable speed. Tom. Webmaster of http://www.netepic.org The EPICentre and owner of Minatures Online. (10% off all VOID goods!)

In Excel when I click on the small arrows on the top and the bottom of the scroll bar it scroll much faster on two of the machines in our office than on the rest of the machines in the office. All the machines are of the same spec and the speed is so blindingly fast that it is causing major...