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!

Register Log in
  • Congratulations derfloh 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: 123ASP
  • Order by date
  1. 123ASP

    Keep format intact after Datagrid Export to Excel

    Hi , I have created datagrid and added a link to export the content of the datagrid to excel. All format was lost when I export the data. Is there a way to keep the same format in the datagrid in the exported excel. Please click on the link to have a visual snap shot of the problem...
  2. 123ASP

    Sql Server Agent ( How to execute DTS after executing store procedure

    Thanks, Al
  3. 123ASP

    Can I Execute DTS from within Store procedure?

    hi, I have one store procedure and one Dts package. The store procedure process data and I would like to be able to once the store procedure is completed, to run the DTS Package, How can I do that, thanks for your help. Al
  4. 123ASP

    Sql Server Agent ( How to execute DTS after executing store procedure

    Hi, I have created 3 store procedure and one DTS. I would like to schedule those code and run them in sequential order. Those are the code: sp_A sp_B DTS_moveData sp_C Once sp_A is completed sucessfully, I want sp_B to run then once sp_B is completed sucessfully, I want DTS_moveData to run[...
  5. 123ASP

    DTS Problem Unziping Files

    Hi, I am interested to learn command line zip and unzip . Where do I get the program where it help me run the zip / unzip command line. thanks Al
  6. 123ASP

    Use command line to zip and Unzip

    Hi, this is a code when I execute it from sql server query window , it runs. Does anyone knows how I can reverse the function so instead of zipping the files I need to unzip them into a new folder..... thanks for your help and support Al declare @varcmd varchar(255), @CurrentDate...
  7. 123ASP

    DMZ and PC security

    hi I have fast internet provider, Cox roadrunner + PC at home + a wirless router. I want to be able to set up my PC to do the following: 1. Allow Public to access my web page in my PC 2. Allow some people to access my ftp server in my PC 3. Allow one or two people to use remote Desktop...
  8. 123ASP

    Error During update datagrid

    Actually, I was in a car accident and was hurt. Did not have the time to fix the issue. If you already have the answer,I would appreciate to share it with me. thanks Al
  9. 123ASP

    deploy asp.net

    hi, I have created a simple 3 pages application. Input form and 2 datagrid. back end is access database. I need to deploy the application to a host company. since I am doing this for the first time, Is there any consideration that I need to account for before I send the 3 aspx pages. What...
  10. 123ASP

    Applying security on a link

    hi I have created a link as follow: http://168.125.1.1/xzy/report/projectCost.pdf in a web page in which a user can access the link after he/she provide user name and password. after the user is approved to enter the site, he/she can click on the above link to view the content of the pdf...
  11. 123ASP

    Sql server sp3

    I have window xp. What do you mean by upgrade that? Al
  12. 123ASP

    Sql server sp3

    hi I have downloaded Sql server sp3 from http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en and installed the following in my server sql2kasp3.exe 44617 KB sql2kdesksp3.exe 70815 KB sql2ksp3.exe I ran sql2ksp3.exe and then...
  13. 123ASP

    Printing checks from asp.nete

    A Big Smile you put on my face. You are the man,genius . Thanks for your help and support. By the way, What I can do to be genius like you ? (: Al
  14. 123ASP

    Printing checks from asp.nete

    Great, I used crystal Report and created a form, ran a couple of print test and I have aligned the data along with the check.... Perfect, One last problem though, How to write the amount in words. When I use quicken, as soon as I type the amount, it automatically type the amount in words and...
  15. 123ASP

    form validation

    hi, Is there a way to create a function that is smart enough to do all kind of form validation . Basically, I can pass form elements one at a time , then the function can validate for the following: check if field is either integer ,string or date Once the datatype is determined, it validates...
  16. 123ASP

    Printing checks from asp.nete

    Hi, You are right, I am not using accounting system and I do have a table in MS sql server called investor_transaction where I log all transactions. So, when I process the Profit distribution form I get the following saved in the investor_transaction table id | investor | TransactionType |...
  17. 123ASP

    Printing checks from asp.nete

    I am managing investment account for a company where investors get paid via profit distribution. Here is the process. Project xzy has a profit distribution of $850,000 so what I did, I created a form where you provide Project Name and the profit from such project. Then once you click on...
  18. 123ASP

    Printing checks from asp.nete

    Yes, Al
  19. 123ASP

    Printing checks from asp.nete

    Yes, I have crystal report, would you guide me to be able to print checks. thanks Al
  20. 123ASP

    Error During update datagrid

    hi, I have a datagrid that contain a date field. if the field has a adate before I update the row, it make the update, but if a edit a record that has no date in the column field, I get the following error, any idea how to fix it. thanks Al Cast from type 'DBNull' to type 'Date' is not valid...

Part and Inventory Search

Back
Top