VB Forum / Database Access / December 2003

Hi all..
Need some help here.. cun really figure out how to write my SQL statement...
I have 2 tables here..
ORDI and ORDM

I want to connect to a remode database which is in MS access. I have the
LAN connectivity but no directory / file sharing for the mdb file I want
to connect to.
Tried MS remote but didn't work all that great.

Thank you in advance for any and all assistance.
I have a VB 6 application, with a cmdCopy button, I would like to open a
file, C:\program files\program directory\program file.txt and copy to the end
of that text file information data on the clipboard.

Hi all.. How do I add in contents from my textboxes into a msflexgrid?
I currently have 5 different textboxes and I'm supposed to fill in all the 5
columns in the flexgrid with the values in the boxes.
However, I want the grid to automatically increase the row by 1 whenever the

I have been having some MDAC related problems with a
VB6/ADO/Access running on new WinXP pro machines with MDAC
2.7 SP1 (the MDAC version that ships with XP pro).  For
example, on my Win2000 machine with VB6 SP5 and MDAC 2.7,

I have created a system that works with Access/SQL-Server and now I want to
access Oracle. I thought it was as simple as downloading the Oracle ODBC
drivers and install them and simply add the connection to find the DB on AIX
but it says:

I have a windows 2000 server running IIS with Remote Data services.  I have
just purchased a new server and I am configuring it to replace the old but
the Visual Basic 6.0 app comes up with runtime error 8447, Internet Server
Error.  I have MSDAC 2.7 installed and everything looks ...

Datenverbindung auf MSFHGrid mit den Befehlen COMPUTE, APPEND

Can someone show me how to create a MySQL database using
visual basic syntax in a project? I know how to create a
MySQL database from the Windows C prompt. And I know how
to use the syntax Shell "c:\mysql\bin\mysql" to run MySQL

I forgot the password of my Access database which I
created few years back. Due to this problem I'm unable to
open it. Is there any way to open the database?
regards

I need to set a dynamic path for the sourceDB.. tried doing this, but gives
me FoxError1...
tmpBcode is a variable, which is provided by the user.
I'm usingVB6 and visual foxpro tables.... Can someone tell me how should I

I have a 4 tab SSTAB control. I want to move the focus to the last tab
when the
user clicks on a command button... How do i move the focus to the last
tab?

I am working with ADO 2.6 and VB 6.0 to retrieve a recordset from the
database (SQL 2000). The recordset is then disconnected and used as
the data source for a DataGrid. My application allows to the user to
edit the data in the grid, sort it (by clicking on the column head)

When I try to run this code,
Dim ashconn As New ADODB.Connection
Private Sub Form_Load()
   ashconn.ConnectionString

Using Visual InterDev6 (not .NET), how can one persist an ADO recordset in
IE6 memory (ie. not saved to a local file) so that it can be accessed from
another document, either running simultaneously or later in the 'session'?
I would like the recordset to achieve 'session scope' on ...