Search results for query: *

Thank you.

Thanks both of you, Riverguy have you tried that background worker? To be honest im a beginner when it comes to vb so im not sure how it works, but on my form I have various connections to my databases (as private subs) and I call this subs throughout the form so that is why it takes time to...

Hi people, I was hoping someone could help me out please. When my vb application tried to load data from the database it can take a few second depending on the amount of users using it at the same time, I was hoping someone could help me out please. When the data is being loaded I want some...

...log.[Company], log.[ChaCode], sum(iif(log.notenumber=1,1,0)) As NumberofProblemsLogged, SUM([tspent]/60) As SumofTimeSpent, SUM(([tspent]/60) * cc.cph )as SumofTotalCost From Log inner join [Cost] as cc on log.ChaCode = cc.[Costcode] where log.Dol BETWEEN ? AND ? And log.CompID = ? Group By...

Thanks George I understand, you see I have been using Access for a really long time and last week I decided to move from Access to SQL - the main reason being that my Access database was slowing down my vb application and I thought Sql would improve the performance but to be honest I know that I...

Thanks, not sure if it was the following what you was after: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Log] GO CREATE TABLE [dbo].[Log] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [LogNumber] [int]...

Update Im actually using Sql Server eneterprise manager, when I right click on Log it says the following: New Table Design Table Open Table >Return All Rows >Return Top >Query Full Text Index Table >Define Full Text Indexing On Table All Tasks >Managing Index >Managing Triggers >Managing...

Sorry it was null not blank but Im looking in to it, thanks guys

Hi people, I'm facing this problem where I need to save the date from the date time picker into my sql database. However the date format on the sql database is set as US format where I need it to be UK, the alternative I have found is to pass the date in as a parameter (so that the actual...

Thanks everyone, much appreciated especially gmmastros as the following worked a treat. Provider=sqloledb;Data Source=W23-dbserver;Initial Catalog=supporttest;Integrated Security=SSPI; Thanks again.

...Source=" & Application.StartupPath & "\CNS.mdb") Dim adapter As New OleDbDataAdapter("Select * from Log Order By LogNumber DESC, NoteNumber DESC; ", conn) Dim dt As New DataTable("Log") adapter.Fill(dt) dglog.DataSource() = dt dt.DefaultView.AllowNew =...

Dont worry peeps problem solved thansks

...DataTable).DefaultView End If If txtsearch.TextLength > 0 Then dvfilter.RowFilter = String.Format("LogNo LIKE '{0}*' ", _ txtsearch.Text) Else dvfilter.RowFilter = "" End If dglog.DataSource = dvfilter 'select...

It seems so long ago and I deleted all the softwares that I did use, I know what you mean but do you think any of these softwares would restore my laptop using the dvd?

I can't remember :( thats the problem

Im using XP. Sorry as I wanted to restore the files on my harddrive so I thought this would be it. Sorry again.

Hi everyone, I've never really posted on this side of the forum as I mainly stay on the programming side however I have come across a problem and was hoping some one with more knowledge could help me out please. I really need to restore my laptop to a position it is on a DVD (I know some may...

Sorry I'm using vs 2003 Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click Me.richtxt1.Text = Clipboard.GetText End Sub I think that might be the problem as my Vs is older than 2005 and 2008.

Hi, there is a problem on the following line: Clipboard.GetText It says 'Gettext' is not a member of system.windows.forms.clipboard. Thanks

Hi I've created a context menu and added a paste menu item. Hopwever im not sure what to do next. please help