Recent content by kingduck

Hi tazUK thanks for your reply . I am still looking but still no luck. I am tring to restore a database on a new blank database that i created. I have done this from the SQL Enterprise Manager using an option called force restore over existing databse but i can't find semilar option through...

Thanks macleod1021 for the tip but when i searched google it returned 128,000 Hit. the first was about the C language. The restore worked fine, But when i tried to restore it to a newly created database it raised an error that the original database -That i created the backup from- file is in...

Thanks very much Denny I looked up the restore command it is all that i need. Thanks for your Help

I am running SQL server 2000 I have created a backup of a database through VB 6.0 How can i restore that backup to the database through code? Can i restore the backup to another database on the server, through code? Thanks in advance.

Thanks LB. It was a numeric text Thanks very much

Thanks LB for your reply The calculate combo does not have sum in it. it has maximum , minimum, count and other stuff but no sum. I am using crystal report for VS.NET 2002 Thanks

Hi All; How do i sum value in a group and reset the sum for a new group. So that each group has its total beneath it? Thanks in advance.

Hi All; I have a dataset with one table in it. after making updates to the table i am tring to save it using the DataAdapter. using the following command: damf.Update(MyDataset, "Table1") the following error keeps raising: update requires a valid UpdateCommand when passed DataRow...

Thanks Bob and kevin for your reply My command is; "Rar.exe" with the arguments " a -rr2048 -t -m5 -isnd -r -t " & FileName & "D:\My Documents\" where : FileName = "i:\Back" & trim(str(Date.Today.DayOfWeek)) & ".rar" I think that the long file name "My Documents" makes an error with rar it...

Thanks Bob that realy helped. But, how do i issue internal DOS commands to the command prompt from within VB.NET. Like, Varify on Thanks

Hi All; How can i execute an external command from a consol application? Thanks in advance

Hi All; This is my first Report. I have created a blank report and set the data source to a dataset but i do not how to add fields to the report. I am using this code Dim MyDataset As New DataSet() Dim cnAccess As New OleDbConnection() Dim SqlStr As String sqlstr = "Select * from Customer"...

Hi All; I am new to .NET. I have created a blank report and set the data source to a dataset but i do not how to add fields to the report. I am using this code Dim MyDataset As New DataSet() Dim cnAccess As New OleDbConnection() Dim SqlStr As String sqlstr = "Select * from Customer"...

Thank you very much cmn2. This is what i needed.

Hi All; I have a Textbox and a Datagrid on my form. How can i search the datagrid for the text in the textbox? and point to the Corresponding record. Thanks in advance