Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: manguilla
  • Content: Threads
  • Order by date
  1. manguilla

    SQL Server 2008 ERRORSTATE 28000

    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'...
  2. manguilla

    Excel 2007 lookup value in table with 2 data elements

    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)...
  3. manguilla

    Dir() will not move to the next file

    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...
  4. manguilla

    Open is not declared error

    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...
  5. manguilla

    Open is not declared error

    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...
  6. manguilla

    Formula to add totals on certain cells

    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...
  7. manguilla

    Invisible Form

    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
  8. manguilla

    Renaming and moving files

    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...
  9. manguilla

    How do send a text message from a website

    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
  10. manguilla

    Stored Procedure in Crystal Report

    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...
  11. manguilla

    Closing modem connection after checking email

    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...
  12. manguilla

    Could not find installable ISAM

    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...
  13. manguilla

    Compare dates from Access and Now()

    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...
  14. manguilla

    Sql Server Certificate Question

    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...
  15. manguilla

    Getting page cannot be displayed with ssl

    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...
  16. manguilla

    Exporting Data to Excel

    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...
  17. manguilla

    Check for Duplicate Data

    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...
  18. manguilla

    Delete Duplicate Data

    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...
  19. manguilla

    Store Value from combo box

    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...
  20. manguilla

    Compare Many Columns in 2 tables

    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...

Part and Inventory Search

Back
Top