SQL Calculation involving NULL in Access
(1 messages)
Date: Wed, 22 Aug 2007 16:29:54 +0100
I am using an INSERT INTO .... SELECT .... type SQL command, which works
fine from a query within Access, but doesn't work when I try to execute is
through an OleDBCommand in my VB2005 project.
The problem is that the ...
|
visual studio.net 2003 and Access 2007 database
(1 messages)
Date: Wed, 22 Aug 2007 08:29:08 -0500
Hi
I am currently using Visual Studio.Net 2003 running on Windows Server 2000
operating system.
I have used Visual Studio.net 2003 connecting to Access 2002 databases in
the pass with great success.
Now, I have a need ...
|
Recordset close generates exception
(1 messages)
Date: Wed, 22 Aug 2007 00:54:11 -0700
Hi,
I want to create a new record within a Try Catch block using the
following code
Function Process() As Boolean
Dim rsAttendance As New clsMSRecordSet
Dim rs As ADODB.Recordset
rs = rsAttendance ...
|
Update datarow in typed dataset
(10 messages)
Date: Tue, 21 Aug 2007 13:56:33 -0400
Hello,
How can I update a datarow in a typed dataset? It seems i can't make it to
write the changes into the database. What am i doing wrong? Thanks in
advance.
Here's my code:
Private Sub save_changes(ByVal ...
|
Global Assembly Cache Installation Problem
(3 messages)
Date: Fri, 17 Aug 2007 10:58:15 -0400
I have a VB2005 program that is using DAO against Access 97 files. (Yes,
this is what I need to do...ADO.Net is over 20X slower and my incoming files
are Access '97. Would that I could change that!)
This runs great on ...
|
Copying tables in SLQEXPRESS
(2 messages)
Date: Thu, 16 Aug 2007 15:14:30 +0200
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database ...
|
RowSelect
(3 messages)
Date: Tue, 7 Aug 2007 13:28:14 -0500
I use Dataset and to select certain records in the Dataset I use the SELECT
method (m_dsSQL.Tables(0).Select("colB > 0") ).
I am looping until colB <= 0.
The problem is, after I fill the dataset and do SELECT, if inside ...
|
Database Access error i when deployingVB6 system convereted to VB2
(1 messages)
Date: Tue, 7 Aug 2007 07:34:05 -0700
I have converted a substantial VB6 application (conversion took 3 months) to
VB2005 and it works beautifully EXCEPT on SOME PCs to which it is deployed
I deploy by XCOPY ( I cannot use one click) from an XP system to other ...
|
Visual Studio 2008 - should we bother?
(2 messages)
Date: Wed, 1 Aug 2007 09:39:02 +0100
I like using VB2005, but I'm still unhappy about unstable it is. Basically,
there are loads of bugs that require work arounds.
VS2008 will be out within 6 months. I'd bet good money that will severely
reduce the amount ...
|
Love Taboo Forum Now Open to the Public! 5% Off
(1 messages)
Date: Mon, 30 Jul 2007 17:40:49 -0700
Hi Folks,
Is anyone sick of the junk bb's online? I found a new bb
that is amazing to say the least. They have all kinds of
adult topics that you can post to once you register. They
give you all kinds of posting options ...
|
|
Error: data truncated.
(2 messages)
Date: Mon, 30 Jul 2007 23:48:18 +0200
Hello,
When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).
String or binary data would be ...
|
Addnew in VB.NET ?
(21 messages)
Date: Mon, 30 Jul 2007 15:56:44 -0500
In VB6 to add a new record in a recorset, you can use the Addnew method,
then set each column's value, then call the Update method.
How can I do this in VB.NET ?
Thank you.
VB6:
Private m_rs As new ADODB.Recordset
m_rs ...
|
Inserting information into 2 tables
(1 messages)
Date: Sat, 28 Jul 2007 18:16:57 -0700
Can anyone tell me how to insert one set of data entered in a
microsoft access form with multiple fields, into two different tables
in the same access db??
thanks!
...
|
Visual Studio / Microsoft
(4 messages)
Date: Sat, 28 Jul 2007 18:11:57 -0600
For the first time in my long career as an application developer, I
really do hate my job!
I am used to tools like Borland Basic, Turbo C, Clipper and Foxpro to
develop applications in a short time that simply worked and ...
|
dataset Issues
(1 messages)
Date: Sat, 28 Jul 2007 13:41:36 -0600
This is all very confusing, but I'm trying.
I am using strongly typed datasets, that I simply drag on to the form.
I have a dataset created here:
Me.PODetailTableAdapter.Fill(Me.PODataSet.PODetail)
Its there, because ...
|
Using BindingManagerBase with a dataset with two relational datatables
(1 messages)
Date: Fri, 27 Jul 2007 13:32:19 GMT
Hi
I have made two Sqldataadapters. One has the table Film and the other
adapter has the table Category. I have generated a dataset wich contain
these tables and made a relationship between them. I have two textboxes. One ...
|
Pass date as parameter to Access DB
(3 messages)
Date: Wed, 25 Jul 2007 22:44:17 -0400
ASP .net - webforms
I changing things from sql string concatenation to parameters, for sql
injection reasons.
I keep getting a data type mismatch error.
I know the field / column is date/time and it worked with the ...
|
DataReader values and .ToString
(1 messages)
Date: Tue, 24 Jul 2007 17:03:31 +0200
Hello,
In order to avoid errors, I have all my DataReader-fields converted with a
..ToString.
This in case some record could have Null-fields and an error would be
thrown.
This works fine, except for "money" fields ...
|
Detach my database from SQL SERVER
(2 messages)
Date: Mon, 23 Jul 2007 18:02:43 +0200
Hello,
When I have closed my appliciation in VB.NET, and I try to detach my
database from SQL SERVER, I often get a message that the database cannot be
detatched, because it is still in use.
So I think there is some ...
|
BindingSource problem?
(1 messages)
Date: Sun, 22 Jul 2007 03:33:48 -0500
I'm making a small app for a few friends of mine. It's for membership
info. It uses multiple tabs. It connects to an access DB with 2
tables.
On one tab it has a datagridview control on it and it's datasource is
set to ...
|
