Recent content by manguilla

Yes I am using a windows account that was put in by default. It's the same user that is listed under the SQL Server service. The user is listed below. If I remove NETWORK SERVICE what password does SQL Server use by default for this user in case I need to put it back? Thanks. NT...

Hello. I'm having an issue with the SQL Server Agent service not starting. I am getting the following messages listed below: [098] SQLServerAgent terminated (normally) [382] Long to server 'XXXXXXXXX' failed (DisableAgentXPs) [298] SQLServer Error: 18456, Login failed for user 'xxxxx'...

That got me on the right track. What I did is break up the amounts and %'s in different tables and I was able to use the HLOOKUP and VLOOKUP commands to get my results. Thanks again for all your help today.

Yes they have to be integers. I will try seperating the tables out and see if that will work for me. I Thanks again for your help. manguilla

Sorry here is more detail. I have stored values and ranges that deal with # people in the household and annual income. Based on those 2 criteria, I need to see where they fall on this table to I know the %(discount) that applies to them. So if there is 1 person in the household and the annual...

Please see the table listed below. I have trying to return a % value in the last row but I need to use 2 pieces of data to find the %. So for example, if my value is 1 and the amount is 10500, I need to return 100% to my previous worksheet. The previous worksheet has the values say in A1(1)...

I applied the FileNames = System.IO.Directory.GetFiles(StartDirectory) part to my code and it helped me loop through all the files in both directories. Thanks again. manguilla

Hello everyone. I am having a problem with the Dir command not moving through the current folder to the next file. I am looking for specific files that begin with a name and when I find them, they will be copied to another folder. After the first file is found and copied, it will not move to...

I tried to add the refernce and Microsoft.VisualBasic but I'm still getting the same error. Is there something else I need to add? Thanks again. manguilla

Hello again everyone. I am writing a .exe app in .NET 2003 and I am having a problem with an error. The error says, "'Open is not declared. File I/O functionality is available in the 'Microsoft.VisualBasic' namespace." I think that I need add a reference to the System.IO object but I cannot...

Oh I'm sorry. I though you could create a VB6 app in VS .NET 2003. I'll post it there. Thanks. Manguilla

I am writing this in VB6 but I am using Visual Studio .NET 2003. Thanks. Manguilla

Hello again everyone. I am writing a vb .exe app in .NET 2003 and I am having a problem with an error. The error says, "'Open is not declared. File I/O functionality is available in the 'Microsoft.VisualBasic' namespace." I think that I need add a reference to the System.IO object but I...

I tried the sumif function and it worked great. Thanks everyone for your quick response. Manguilla

Hello everyone. I need some help with a formula and I don't know if this is possible. I have a spreadsheet with an "Amount" column and an "Initials" column. I need to total the dollar amount in "Amount" column based on the person's Initials in the "Initials" column and put those results on a...