I am looking for people to test out my Histogram program and offer
suggestions.  I am not selling this program.  It is mostly for
demonstrating an Access-to-pdf technique but I'm finding that having
the capability to create histograms from Access data is useful and a

I have a query with a numeric field called BALBOOK.  I have a form
(we'll call it Form1) that runs this query.  On this form is a text
box (we'll call it Text1).  When the query is run, I want is to use
all the records from a file where BALBOOK is equal to Text1.  However,

We have a COM object, which in turn use DDE to communicate with
another application of ours. Access to this COM object works fine
from C++, Visual Basic applications, VBS and VBA from MS Word.
But the the same VBA code that works in Word fails in MS Access.

I am linking an Access 97 front-end database to an ODBC data source
(Sage Line 50 Version 9). Running the link on a Windows 98 PC the
performance of the linked table is instant. Running under windows XP
Professional the response increases to around 20-30 seconds. I have

I have a form and in the OnOpen Event i have the following
DoCmd.OpenQuery "qryUpDatePayment"
This creates an error,,however i need to update the qry when i open the form
this is only occuring in Windows 98

I have a lot of respect for David Fenton and Allen Browne, but I don't
understand why people who know how to write code to completely replace
a front end do not write something that will automate the code that
implements managing unbound controls on forms given the superior

how to solve this problem. "activeX component can't create object" its
happened when i want to create a new form in ms access.

I am using a popup in the following scheme:
Form A----> Generates frmB With Multiple Fields ( a
popup)------->Command Button on frmB-------------> Generates frmC
(also a popup) to gather data to populate a field on frmB.

I am working with an Access table that contains dollar amounts in two
columns, one for January 2004 (CP_Payment_01 )  and the other for
February 2004 (CP_Payment_02). My original goal was to take this table
– and example of which is below - and sum the values in each by Vendor

I have the following tables joined on a one (Field4) to many (Field3)
relationship
                 Table1
 Field1  /    Field2   /     Field3

how to retrieve name of query created in the database using ado control
and  to create a query using ado control

I am having difficulties building queries for my database. I am
familiar working with Access, however have not had much experience
working with the queries aspect of it.
This is what I want to do:

I have a loop in a MS Access application of which I would like to
number the variables within the database as follows:
tbl
 rev1

The following select statement is givign me a 'data type mismatch' message
and I don't really know why.
strSQL = "SELECT CN"
strSQL = strSQL & " FROM tblDeaths"

I'm trying to write a query that concatenates multiple records into one
derived column.  Let's say I have an author (Joe Writer) who has written
three books (Book 1, Book2 and Book 3).  The author is in tblAuthors, his
books are in the tblBooks and they are joined by the AuthorID ...