VB Forum / Database Access / October 2008

I am writing an MS Access application. Text in some controls on forms must be
typed in Cyrillic, in others - in English. How can I change keyboard language
from code upon entering certain control?

I have a VB6 code, Function to collect sProc as StoredProcedure Name and
sParam for Parameter.
With the following Query with a parameter in section ---> WHERE
(vwProductFamily.GroupCode IN ('CODE1', 'CODE2', 'CODE3'))

I need to run the following query in my application. It works fine when I
use the SQLSMS:
INSERT INTO [Company s_r_l_$Production Cycle] ([Prod_ Order No_], [Serial
No_], [Item No_], [Item Description])

Hi Olaf, ... or anyone who knows ...  :-)
Is it possible that dhSqlite or sqlite itself does not recognize Val or IIf
in a Select Statement?
It's probably an error in my code somewhere else but i get a error msg  "no

I'm developing 2 applications in Visual BASIC 6.0 using DAO 3.5. One of them
I have theses lines in a Module file:
Global vtempo As Integer
Global vESDB As String

I have an application written by a former co-worker that I'm
troubleshooting. On my development machine (VB6 SP6, SQL 2000 - 8.00.2050) I
run the application and all is well. On another machine running VB6 SP6, SQL
2005 - 9.00.1399.06 I get the following error:

I have absolutely no experience or knowledge of ODBC so could do with some
help and advice.
We have a linux server running some software that basically runs our
business.  We are going to be investing in some new software for our Accounts

I have a text file I cannot import into DBASE / Paradox at 1 attempt. I
usually chop the text file up into smaller segments, import it, and then
append all  the database tables into1 database table.Sometimes when it is
obvious the tables will  total more than 2gig then 1 or 2 ...

I am having an "Out of Memory" issue while stepping through thousands
of rows of data in an MS SQL Server 2000 table with 35,000 rows and
about 1.5GB total size. Physical memory on the system is 2GB and the
page file is set to grow up to 4GB. I am working with a contractor and

I want create function for have to ADODB.Recordset value input.
ex>-------
Public Function recordsetProcessingFunc(rs as ADODB.Recordset)
   Dim a as String

Is it possible to open an ADO connection and recordset and export into
various formats, in particular CSV.
Thanks in advance

I have been trying to debug parameters on a stored procedure in
classic ASP using VB6 and ADO and as part of this process reduced to
checking on a simple query, but continue to get an error though it
varies depending on the circumstances. I've got similar queries

Thank you for helping me to solve this mystery.
I have a select statement that works fine in MS Access, but fails in VB6,
with an error message that says "No value given for one or more required
parameters."

I use VB6 and MSSQL2000, also Sheridan 3.1 Utilities. I want to know how to
declare ADO connection and SP's or query to populate a DataGrid in most
efficiently way, now I do this manual in AddItem DataMode. Please help me.
Beforehand, thank you very much.

If exist method for getting status or error in VB 6.0
See codes
--
Dim Rs      As New ADODB.Recordset