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'...
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)...
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...
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...
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...
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...
Hello again. I currently have 1 Form in my app and I need it to run in the background when I run the .exe. Any help will be appreciated. Thanks.
Manguilla
Hello everyone. I am trying to find out if I should use VB for this project. I need to go to a specific folder on the c: drive, rename all the files in a sequential order (ex: filname1date, filename2date, filename3date), move the files to another folder and that's it. I want to build a...
Hello everyone. I was wondering if there is a way to setup an asp page on a website to send someone a text message directly from the website. I have been looking around for some code and I cannot find any. Does anyone know how to do this? Thank you in advance.
Manguilla
Hello again. I am having a problem adding a stored procedure to a crystal report in Visual Studio .NET 2003. I currently have a report done and I need to add a new field that needs to populate from a stored procedure. I have been doing some research and I cannot find a good way to start this...
Hello again. I am having a problem with Outlook 2003. I have a dialup modem and I am connecting to an exchange server to check my email. It takes about an hour to download my email everyday. I want to be able to close my internet connection after my send/receive is complete. I know you can...
Hello again. I am having a problem with VB and a run time error. The error says "'Run-time error 3170': Could not find installable ISAM." I am trying to link an excel file and a access database and for some reason I cannot get rid of this error. I have XP SP2 and office 2003. I have...
Hello Everyone.
I have a quick question about comparing dates. For some reason I cannot figure this out and I know it should be real easy. Here is the situation that I need help on. I have a database in access and I need to compare the 'date' column with today's date and see if it's someones...
Hello all once again. I have a quick question about sql server and certificate authority. Here is the situation: I have a server with SQL Server 2000 installed and I have a certificate installed. This server is also used as a web server so IIS has "SSL" turned on and "requests certificates...
Hello again everyone---
I am having a problem with ssl and running pages from localhost. If I have ssl unchecked, then I can display the pageinfo.html file by typing in http://localhost/pageinfo.html . I would then put a check mark in the ssl option in IIS and then type in...
Hello All. I am having a problem figuring out how to export data to excel. I have a form with a drop down box that shows a person's name from an Address table. When they select a name, it will open a form and show their information (name, address, zip, phone) from the same Address Table. Is...
Hello All. I am having a problem sorting duplicate data within a table. I have a table called Employee that contains EmployeeID, EmployeeName, PhoneNumber. This table contains duplicate data. I now have a problem with 2 different users with the same EmployeeID 'abc'. I wondered if there is...
Hello all once again. I am having a problem with deleting duplicate data and keeping one of those records after the delete. I have a table (Emp ID, Employee Name, Address) that contains duplicate data. I want to insert that information into a new table without duplicate data. What I need to...
Hello All. I am trying to take a value from a combo box and store that value in an insert statement to insert data to a table. I have a combo box that shows a week ending date on a form. When the user selects the end date, I want to take that number from the combo box and store that as either...
Hello All. I have a problem comparing multiple columns between 2 tables. I have 2 Identical tables with 29 Columns. There is one row of data in the first table that I will be comparing to one row of data in the other table. I need to find a way to compare each column and find out if the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.