I am trying to create an order entry program from scratch.  I have built a
form and it does all the calculations.  Now I am trying to allow for changes
but still keeping the original data.  What is the best way to do this?  I
have tried opening another form and a subform but with ...

I am writing a routine to match name & address fields on an input file
with records already on the database.
I have approx. 20000 records on the existing database.
First I open my input file. Then I read the existing database records

I have a subform that displays records filtered by a combo box on the main
form.
A button on the main form uses the Recordsetclone of the sub form to copy
data to another table.

THE SETUP:
- we are running a query with fields from two related tables... tblParent
and tblChild...
- selecting records on a field in tblParent

I have several xls files that I export from Access (2000).  Can anyone
provide me the code (or a web site) that I can use to zip these files into
one file to be emailed?

Stay with me....
(Sheet A) I have a table with the fields customer name fax and email that is
blank
(Sheet B) In a seperate table I've made a list of customers names faxes and

I have an Access database I use to create a job quotation # and assign
a project name to.  I also use Excel to keep track of the hours worked
on each project.
What I'd like to do is create an employee time sheet in Excel and just

I have two Access 2000 format .mdb files which run fine on computers with
only Access 2003 installed (...I've tried two different computers), but when
I run the files using Access 2003 on a computer with both Access 2003 and
Access 2007 installed, (...again on two different ...

Does anybody have any examples for Dynamic Reports??
Meaning I have a report with Month/Year accross the top. ie.  1/2005,
2/2005, 3/2005, 4/2005.
If I change my date range the I would like the report to change its title to

How can I hide Formatting(Form/report) bar in a form, and unhide in a design
form
(for the same form)

Can the lack of record locking increase the chance of file corruption?

I've tried both loading from file and using a table with an attatchment
field but I can't get a custom ribbon to accept ico or png pictures as
Button images.  BMPs and JPGs only.  I get either an invalid image error or
no error and a blank button image.  These same files will ...

I have data in a table in the form of a week number but I want to change it
to a week date. That is, for example, I would like to change the week number
35 to the Saturday of that week, or 9/1. I know where I can get the year to
concatenate it so I get 9/1/2007, but I'm not clear ...

I am looking to import a select list of tables, forms, queries, reports and
macros from Access97 into Access2003.  Yes this can be done by selecting each
individual object, but I need to do this 5 or 6 more times before I do it for
the final production copy.

I have downloaded the book collection database but i would like to alter it a
little.
When i am entering the details of book on the second box down you can click
on the box and enter the books topic IE crime, romance, thriller and so onand