VB Forum / Database Access / November 2003

Hi all... I'm encountering the above error when I tried using the Rmdir
command.
It happens if there's files in the folder.
If the folder is empty, everything work fine.

I've had a treeview in an Access database form for many months/years and
today I'm getting a message that I don't have a license for it.  Why would
this just out of the blue disappear?  I'm running developer tools, so I know
I have the license.  I've reinstalled the developer tools ...

Hi.....have a small staff of 6 employees and VB installed, and wish to
calculate thier wages (and don't wish to go down the Sage/Quick Books
route).
Can anyone help with a simple bit of code to accept input of hours and rate

VB6E SP5,  Access 2002
Trying to write an SQL statement which selects based on the month of a date
in a date field.  Any help to correct my code appreciated:
'the  following two lines work

We have an SQL database with 8 tables. One of the tables
has 600,000 entries; each entry has 40 fields (most of
which are null).
Once a year we have to update one field in the table. It's

HELP!!!
I'm going round the twist with this...
I have a VB6 application which is using DAO to access a database
(Please - no lectures on ADO, I know what I'm doing with DAO!!)

Hey everyone.. I am trying to open a Fritz!Fax .dbf file with VisBasic6
it's basically a list of the latest faxes sent and where the copies are.
In .dbf format and I've read it's dBASE IV.
Whenever I run this code VisBasic crashes! Tells me it made an error

I have a VB6 program which makes extensive use of a Microsoft Access
database.  I am using ADO to access the database.
The user can select a command from a form such as
'StartNewAccountingPeriod'.  The program then makes many 'hits' to the

I have multiple rows in a record set and am having trouble getting them
all in the detail section.  I am getting the correct number of rows for
the set, but I am repeatedly getting the first row always. Can I do it
manually? If so how?  I am using labels in the detail section not ...

I am trying to access a mdb file with the adodb connection. I am able to
open it if the mdb is not password protected. If I password protect it It
gives me an error saying that can't find a workgroup file or it is open
exclusively by another user. the mdb file is not open when I try ...

   I have a database program that has a text box for the user to enter a
(or part ) of a catalogue number.
When the user enters this number, they then have to hit the enter key or the
command button before the database will locate the cat number.

Hi can anyone tell me where i could find an example of a well designed
access db suitable to do basic double-entry bookkeeping
just the database would be enough
a description why it is designed that way would be better still

I am loading a listview via ado with records from an access database.
My listview has checkboxes in it. I need to check certian rows and then
write
them to the database but into another table. This table will be for a

Lets say I create a recordset using DISTINCT (i.e., SELECT DISTINCT
Type,Cost FROM MyTable...).
I use this to populate a list, but later, I want to save a value to the
recordset that contains all of these Types (all will have the same Cost

I was not able to use the DataReport  to create a
complexes  report  I designed a form is access that the
user can select the type of  report  by date..amount…
I  was not able  to launch the report from access  my code