VB Forum / Database Access / October 2004

   Maybe I'm not in the good group for this, but being people designing
databases, I figured you'd probably know the answer to my question.
I have to design a invoicing software and I want to have the good terms in
french and in english.

I'm using ado within a vba routine.
I have a recordset that I want to filter.
I can get it to display all that meet the criteria:
  RecSet.Filter = "(field1 = '" & ListBox1.Value & "')"  ' filters rset to

I'm trying to pull some records from a table based on two criteria as follows.
   SQLText = "Select EmployeeID, Date, Status " & _
             "From TimeTable " & _
             "Where EmployeeID = '" & UD.EmployeeID & "' " & _

Is there a standard method to check the results of a VB query?
For example
Set RS = DB.OpenRecordSet(SqlQuery)
I've tried

I need to connect me to a MDB that is located on a remote machine. My
application is on a locale machine. I use a DataEnvironment with Microsoft
Jet 4.0 OLE DB Provider. Naturally in this way my application don't work
because not is possible to find the database Archive.mdb on a ...

I HAVE CREATED APP WITH VB 6 AND ACCESS 2K USING ADO 2.1 AND JET 4.0 FOR
SECURED DATABASE.
I HAVE USED INNOSETUP, INSTALLSHIELD TYPE OF INSTALLATION TO INSTALL MY APP
ON ALL WIN OS. M FAIL ALL WAY .

Dear Experts,
I am facing one problem on my client loactions Please
advise me .
At our client we have SQL 2000 and client application is

Dear Friends,
Could u pls tell me difference between ADO 2.6 and ADO 2.8.
What are the advantages of using ADO 2.8 over ADO 2.6.
Is ADO 2.8 fixes some problem of ADO  2.6

Dear Group,
How would I bind a OptionButton in a Frame to a Recordset
Object. For other controls I use a loop to set the
Datamember and Datasource.

I'm building an ActiveX EXE to manage database connections. Basically it
opens and closes connections and allows programs to share them. It has this
function to get a recordset as shown below...
Public Function LoadRecordset(ByVal sConnectionKey As String, ByVal sSource

VB5 front end for an Access 97 database.
The app displays a date from one table on a form, which can be modified by
the user.  The date is then entered in a new or modified record in another
table.  However in the second table the year is being stored as '2020'

I am going to build a VB6 DB application for a small project for my
wife's business and have some questions. First I need to know which
technologies that I own will do the trick and which will be the easiest
to implement. I have VB6 SP6 and Access 2000 as my best tools and also

I need to import a Flat File with no delimiters.  The fields in the file are
binery and only the first field is read in. Because the file came from a DEC
PDP 11/44 I have no way of knowing the record length.
Any ideas would be greatly appreciated.

I created a SP with SQL that processes the number of records in a table for a
particular State, The Query works correctly. This is it:
Create Procedure CountRecords15 @SearchStr varchar(10)
AS

Hi
Im trying to change a tables User and group permissions using vb.
Im building a exe that updates the DB by adding a new table. Only one
of the exisitng three users can open the table. The other two users