I have a report that when I view it gives me a blank page after a page
with data.  For example in the footer, it says I have 2 pages (page 1
of 2), yet when I use the arrow key there are actually 4.  The first

I'm generally unfamiliar with Access form design, but have programmed
Cold Fusion applications for a couple of years.
I'd like to build a data entry form in Access that allows the
following.

Merry Christmas to all...I just needed some help to link a database in
Access through VB. I read through some of the old articles and did
understand everything about DAO,ADO and RDO...But then this application
which I am making in VB is going to be installed on atleast 150 odd

Hello Everyone, I have problem with the combo box which needs to show
two columns together:
- Id (Int)
- Article (Varchar)

Allen Browne proposed a sample database, People in households and
companies, for modelling human relationships. Can someone help me with
the correct method for preventing a party to be a parent or a child of
itself ?

I have a macro that needs to have a progress meter displayed since it
is long running. I moved the Macro's instructions to a table and pulled
those records into a recordset that is looped through.
PROBLEM -- The form, with a progress meter and labels to inform the

My client was using Office 97 where I've created a few databases in Access
97 for him. He downloaded a trail version of a database which included the
Access 2000 runtime. When he installed this database it overwrote the Access
97 exe and now I can't do any more development on his ...

I generate invoices for my customers evry month. I want to keep a form which
will allow the user to select the Month and Year through a combo and thus
generate reports based on the month selected.  Also, please let me know how
I can keep a copy of  invoices which I generate for ...

Is there a way to synchronise/replicate an access db with sql server 2000
db, short of writing the code oneself?
Thanks
Regards

I am trying to call the excel function linest from VB using automation.
the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunction.LinEst(y, x),1)

a query is working at first,,then when i add an aliase to a table, it
doesnt work..this is using the SQL view for querying in MS Access 2002
(XP)........
for example

Thanks for the previous replies.....
What I need is to generate invoices for customers whom we rent out
equipment.
I will be choosing the date and year say for December 2005 print the

Can anyone help me??
I am trying to pass a Select Query variable to a table using Dlookup
and return the value to same select query but to another field.
Ex.

I have an Access 2003 application that is split into two .mdb files for
the interfaces and data.  This app is distributed on a CD to be used on
computers that have no internet access.  When someone needs an updated
dataset the backend .mdb is refreshed from a load of Oracle tables ...

I'd like to automate delivery of new Report objects to my users (note:
NOT published reports -- the report *objects* themselves.) I could
fairly easily write code to capture the appropriate properties of the
report and write it to a file, and then code on the other side to read