here is my dilema.  I have 2 tables see below: Table1 has unique
customer records.  Table2 can have multiple records for a customer.  It
is a one-many relationship.  I want to be able to check and see if the
CallDate field in Table2 is between Date1 and Date2 of Table1.

What's the trick to running a batch file from VBA? I'm trying to call
it using the Shell function but it's not working for me. If I
double-click the batch file or run it from the command line it works.
I've tried:

In an old A97 app I trap for error 2501 in a report's calling code just in
case there are no records to return (set cancel = True in the report's No
Data event).  This doesn't seem to work in my A2k3 version of the same app.
I know I'm missing something simple here but my brain's ...

In the part of the code shown below, is it possible for the constant
LngCustomer to get the fist number of the customers in the table
Customers
for example, if the first customerid = 4000, then to get LngCustId =

Dear guys,
I hope not to be intrusive. I just want to inform you, in case someone
cares, about a new forum, where Questions or Announcements on topics
relevant to this newsgroup can be freely posted:

I'm using ADODB to connect to an Access database from VB6.  I'm running
a query that's returning strange results- the following query returns
different results in VB & Access:
SELECT * FROM Robes WHERE strSize NOT LIKE '*+';

I have a question concerning to open the reports.
I know that DoCmd.OpenReport is a obsolete form of opening the reports, but
how to implement opening reports in VB using another VB code?
I mean also OpenForm, OpenQuery etc.

i have created a video rental database system. i have created a customer
form, and a film form.
i related all the tables, with;
tblCustomer has membershipID, which is primary and autonumber,

So I inherited this db that has multiple 'orders' tables.
Each order table is name for the year of the orders...
i.e. 2005 is 'Orders-2005', 2006 is "Orders-2006"
So, I am not allowed to change the tables (boss likes how her stuff

I have created a 'data access page'.
DataPages(0), the main object, represents a recordset that lists all
names of dossiers.
To these dossiers is a datapage appended (expanded band, second

Access 2000 fully updated
Three PCs manage data held on a server. They each have a front-end mdb
file linked to tables on the server and on each PC.
A problem has arisen over the following line of code.

If you right click on a .pdf file, on the "summary" tab there is a property
called "keywords". Is it possible to programmatically read the contents of
the keywords property using VBA?
I want to loop through a bunch of directories looking for pdfs that have

Hello i have a continuos form, and i have a command button to help
insert information on a control textbox. But when the text box is not
null, i dont want the command button to show (to the current record
only). What is the code i shall use in the Current Event of Form, in

I have a desperate short term need for a way to install Access 2003
runtime on client computers.  I have the proper license to do so but I
cannot seem to find the files to do it like we did with the old Access
2000 Runtime.   Also, I cannot use the MS Package & Deployment wizard

I have been trying to come up with a IIF function to do the following
in a QBE grid:
If a number is 10 digits or less, then add leading zeros to fill up 11
spaces.