Search results for query: *

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

Thanks, Al

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

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

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

...the following sp --execute p_BCP_out_cursor select @varcmd =null select @varcmd = 'C:\Batch_code\zip -j C:\OUT\'+@CurrentZipFilename+' C:\OUT\*.*' exec master..xp_cmdshell @varcmd Print '***************move the zip file to C:\OUT_TRANSIT\ *********' select @varcmd = null /*this...

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

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

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

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

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

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

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

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

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

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

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

Yes, Al

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

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