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...
Hi people, I was hoping someone out there could help me with a really annoying problem. I have been using Access to connect to my vb applications all my life but last week I got to the stage where I had to change my database - the only real alternative I had was SQL.
So what done was move my...
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...
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.
Hi people
I was hoping someone out there could offer me some help please, basically I’m in the early stages of moving from Access to SQL, I got one of my colleagues to convert the database and he’s changed it to SQL 2000 and he’s given me the network path of where the converted database is...
Hi people I was hoping someone could offer me some help please as Im struggling a bit on some datafiltering (well it does what its suppose to do but not what I want it to)
What I want to do is if I choose lets say record 23 and then enter data in txtsearch I want to filter the data however I...
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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.