I have connected a datagrid to a recordset having multiple fields.
on entering value in One of the column of the datagrid and pressing enter
it gives a message (not error) automatically
...

First tell abt
using what u have printed wav data to text file..???

I m using VB6 and MS Access.
In MS Access table I have already set the decimal digit to 2 and it is showing only 2 digits after decimal in MS Access Table
but when I put the data in
MSH Flex...

How to select a particular row in MS Hierarchical Flexgrid control during coding.
I m not getting the desired property.

I am working in a multiuser VB 6 Project with MS Access as database.
I want to store details in LOG file.

for this we will have to write to the log file in all the events (into which we have...

here is a sample code for it

Private Sub Savephoto()
On Error GoTo savePhoto_Error

Dim rsIMG As New ADODB.Recordset
Dim bytBLOB() As Byte
Dim intNum As Integer
...

I have made a report in Crystal Report, fetching records by SQL Query from ODBC Datasource.
The query is taking too much time and error is comming after 50 seconds that
timeout expired.
What...

I m working on a VB project with MS SQL SERVER 2000 as backend database and Crystal Report 8 for Reports.
The problem is :

When showing a report, after some moments error comes as

Microsoft...

I m working on a multiuser VB project using MS Access as Backend Database.
I wanted to know that through VB coding, how to know that any other user is
currently accessing the MS Access DATABASE .

form is an object. To study more about it, plz refer VB book of Wrox & Orelly Publication.

One reason for not opening may be the lack of required resources such as some Active X Controls or DLLs. Or may have conflicting version of resources. Can u upload the application or the code, so...

Just Try the same program on another system. n watch what happened.
dont forget to reply.

I m working on Multiuser VB Project with MS Access as Database.
I just want to check (from codding) how many users are currently accessing
the backend database .
Is there any way ???

Is there any way or API to detect the Screen Resolution in VB 6.

I am using a connection object from code and a DataEnvironment in a VB application

Set CON = New ADODB.Connection
CON.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data...

How many tables we can create in a single MS Access database ?

I m going for a multiuser project .
I dont know how many tables I will have to make.

Actually in an application (VB 6 & CRYSTAL REPORT 8) I got a problem with RTF Export option. The settings (Tab settings, Paragraph settings etc.) got changed in RTF file.
One more thing is that,...

instead of sPath = App.Path & "/../MasterDB"
use sPath = "\\SERVER\...\MasterDB.MDB"

using the bold lines below in the code we can handle simultaneous access

Private Sub Command1_Click()
CNN.BeginTrans
If Not VALIDATE() Then Exit Sub
Call GENERATE_EMP_ID
...

I am using MS Access database by a vb6 program for multiuser environment.
In the program I have written code for autogenerating employee_id which is primary key in the table.
When entering records...

Actually u should try urself to make it.

specify what library management do u want?
book library or video library management?

Clearfy urself
Do u want to know how to query database using SQL or
do u want to connect SQL Server.

Thanks.

but here also

Dim wrkJet As Workspace
Dim dbProgram As Database
Dim wOrders As Recordset
Set wrkJet = CreateWorkspace("", "Admin", "", dbUseJet)
Set dbProgram =...

I am using an Access Database through Visual Basic 6.
Is there any other way to access the database excluding the following code.

Set CNN = New ADODB.Connection
str = "\\SYS8\DATAX\EMP.MDB"...