VB - Database Access

Thread preview

Thread	Last Post	Replies

Adding Fields when One Is Null	24 Oct 2005 19:58 GMT	9
I am currently a new user with Crystal Reports. I have two fields that I want to add together but one of the fields contain nothing. Therefor, my formula field does not work on that particular record. I have two fields {QtyOnHand}+{QtyOnOrder} and the total of this goes into a field
Where can i get VBSQL.VBX?	24 Oct 2005 15:53 GMT	2
I have an application originally written in VB 3.0. I need to work on it and tried to open it in VB 6 (I don't have VB 3 or 4). It complains about VBSQL.VBX, can somebody please help me find it? I do not have access to MSDN subscription.
Record error -2147217900(80040e14)' Systex error in Form Clause	24 Oct 2005 06:31 GMT	3
Hi all programmers I am having a problem with my recordset. I am designing a login form for my project just to verify the username and password.
sp_addlogin (proc) from vb.net --security	24 Oct 2005 02:35 GMT	1
From a vb.net form I created the chance to add an SQL Server user with role as administrator. To create it, username and password are retrieved from two text box and then the login is created with:
How to create an Access 2002 or 2003 mdb file with VB6?	23 Oct 2005 16:48 GMT	1
Is it possible to create an access mdb file with a 2002 or 2003 file format? I use DAo 3.6, but it creates an Access 97 file type? Thanks in advance, WayneM
HELP - CSV Driver and ADO reading field values	21 Oct 2005 23:32 GMT	5
I have opened a csv file via ADO in .asp. The problem is that every character seems to be outputted as a different field/value. See my code below. Dim dbTxtConn, rsDTAdata
Retrieve data from SQL and post to AccessDatabase	21 Oct 2005 21:09 GMT	1
Please review vb code Receiving Syntax error in INSERT INTO statement Can some please help me. thanks in advance.
datagrid	21 Oct 2005 14:37 GMT	9
not exactly a ado question but since i believe many of you will use a datagrid with ado i was wondering how to change the column headers in my data grid to a text that i input or simply the text that is the caption of the column in the database
Best Book(s) to Learn VB6 and Access97 Programming?	20 Oct 2005 23:31 GMT	4
I have an Access97 application I would like to be able to distribute, to people who may not have Access installed Through work (site license at a University) I was able to download a [Licensed and Legal !!!] copy of VB 6 Pro, but
datagrid	20 Oct 2005 21:18 GMT	1
how can i reference (By integer) which row is selected in a data grid in order to delete it Dim delrow As Integer delrow = DataGrid1.
Name adStateClosed not delcared	20 Oct 2005 20:25 GMT	1
Being a newbie, I was copying the following vb code: Private cn As New ADODB.Connection Private cmd As New ADODB.Command Private rs As New ADODB.Recordset
Help with Oracle SP / using LIKE statement...	20 Oct 2005 14:23 GMT	7
Relatively new to Oracle DB's (I am a SQLServer type), but trying to work out a StoredProc on an Oracel DB and hope to get some help with converting the SProc to include a LIKE statment with Wildcards... Could you take a look at the current sproc and advise as to how to
ado - sqloledb - login	20 Oct 2005 10:12 GMT	2
Hi, I get 'login failed for user sa' when trying the following sample code. could you advice me how to fix it ? I'm running this script on my PC, and the database is on another PC. THANKS !
Class not registered	20 Oct 2005 02:31 GMT	7
Hi We have created a program in VB 6.0 with a reference to DAO 3.6 because one of our customers had problem connecting to the database with a reference to DAO 2.5/3.51. He has Office 2003 installed on his computer.
Looking for the best method. (Your experiences using ODBC wanted)	19 Oct 2005 21:50 GMT	2
I'm looking suggestions, tips, stories, etc. in using ODBC to connect to Navision Attain 3.0. (Not the SQL version) I'm torn between which method to use. I could link the tables from Access but I'm a little weary of corruption.