I want to open the MS ACCESS databse in binary format and extract
1- MS ACCESS version
2- Number of tables in it
3- Number of columns in each table

I use Access 2000 to store and report on data extracted from an RMS (Point
of Sale and Back Office).  To improve the reports I produce I want to
incorporate a General Ledger Budget Table (primarily Sales & COGS).  The
budget data I have been given is in an Excel Spreadsheet and ...

I have been using DateValues from Excel in one of the fields of my Access db
to be able to sort accurately on its matching date.  I'm sure the Expression
Builder would be able to handle this problem, but none of my books go into
detail as to how to use it. Has anyone solved this ...

The Access Templates that are posted are so boring looking. They need to be a
little more creative in design. I have take database design courses. And I
have tutored students on the subject. I know that most Databases are buisness
related but if they are used for personal use ...

have a form with a subform. The main form is designed for a quotation work
sheet. The subform has fields with qty, item, desc, item cost, and extended
cost. The item field is a drop down box that pulls from a product table.
We want to clean this up and make it even easier. Say ...

im trying to create ainventory list for multiple locations
all have the same basic products just different amounts
no calculations needed
just a list

From two tables I run a query which gives me, for example:
RecNo Name Add1 Type
1        Joe    A        Plumber
1        Joe    A        Plumber

I have been using access for sometime but never had the need to setup a
relationship before and I appear not to be getting it right.
I have a Pocket PC with Access on it and I need to design a special
database. I am a Police Officer and I would like to design a Field

I want the current date to be the default value on the date field of my form,
is this possible, how do i achieve this?
The other question is, how can I enter data in one table and  have the same
data  automatically entered into another table. The first table(STOCK) has

As a beginner I designed a database that uses bound forms and tables for
different parts of a production process. I used a table for good product and
another table for spoils. I will not go into detail about the process
involved, however, with time the database has become more ...

Just curious...  If I change the layout of a linked table (widening columns
so that entire contents of fields are shown), is there any effect on the
table or am I only affecting the 'definition' of the link?
Thanks & Ciao,

I am trying to create a default value, DateDiff() expression on my table from
an Start Date field and and End Date field.  How do I go about doing this
successfully.  I have tried: DateDiff("d", [Start Date], [End Date])  I keep
getting a message that 'Start Date" is not ...

Access 2003:
Ok.  I give up.
How do I print the object dependencies?
A Print just gives me the form I selected.

I want to know, How can I separate the DB from the progran I wrote - meaning:
to Update the program without changing the data which are already exist in
the DB.

I have taken over somebody's project creating an Access Database. As new
forms are opened, the previous ones stay open also. How do I close them
automatically when a new one is opened (like the sign in form)?