VB Forum / Database Access / June 2005

I am looking into an issue with a stand alone VB6 application and would
really appreciate some help.  At some of our sites the application runs
with SQL Server 6.5 as the back end and all is  well.  Other sites,
however, have upgraded to SQL Server 2000 (and the stored procs has

I am trying to extract data from a data file that was part of a Win 3.1
application. The application seems unusable as it crashes on my Win XP.
This file appears to be a document and was bundled with what appears to be a
Visual Basic 3.0 application (Microsoft Jet 300 Dll's). The ...

I was wondering if someone could help me streamline my Select statement. It
works but the query is slow. The script connects to the Event Log and returns
2 event ID's from the date range (dtmStartDate - dtmEndDate). I then cycle
through each returned event and collect it's ...

I am working on a VB6/Access application and i am dealing with
illegal characters such as ' %
I've wrote two functions one to encode those illegal chars into ascii
values

I'm having a problem in my VB6 program in that it will "stall" or
"hang" (like it's in an endless loop) from time to time, seemingly at
random. I am highly suspicious that the problem is with some async
queries the program makes to an SQL Server (2000) database.

I have created a crosstab report in Crystal Reports XI, layout as
follows:
Weeks running vertically, zip codes running horizontally, and a count
of orders delivered cross-tabulated accordingly, i.e.

  Is there somebody who know anything of ADOMD or web site for beginners?.
I'm trying to connect to my server, analysis manager with ADOMD and I've
want information but the only thing that I have obtained are mistakes and
confusion.

I'm using Crystal Reports 8.5, Visual Basic 6.0 (SP6) and ADO (MDAC 2.7)
I have a problem when trying to set a recordset for report's datasource
more than once. There is a loop that goes through recordset's rows
and in that loop recordset is set to report's datasource (with ...

I'm using an image listview. I want to display some numeric figures, but
they're all left alligned. How can I allign some columns to the right in the
listview?
Thanks

Question is …
Instead the use of a temp storage to load the stream , I want to put it
right thru the form.
How can I do this ?

Burton-On-Trent company seeks highly motivated person to manage IT
systems. The candidate should ideally have or be working towards
Microsoft Certified Professional qualifications and be seeking to get
further Microsoft qualifications. The role is full-time and salary is

This is the third post of my problem (the two revious were in general ng) I
hope someone can solve my problem here.
I have an ADO connection with an Access 2000 .mdb file (One Index column and
20 columns conatining Text data) I need to present a find method similar to

teniendo una tabla de ventas, porque cuando yo hago:
select * from viewcomis2 where fecha between '27/05/2005' and
'30/05/2005'
me aparecen resultados:

I'm creating a VB6 application to import data from a temp Access database to
a production Access database. I have set up a Data Enviorment to communicate
with my production database since I the application centers around it.
During the import I create a temporary connection to ...

I have an application I build in Access.  I would like to migrate the
front-end to VB.  Is there a way to import my forms & reports so I don't have
to recreate them?  I will be new to VB so I am sorry if this is a dumb
question.