http://www.microsoft.com/office/preview/programs/access/demo.mspx
It's early morning and surfing the web I found the new Access 2007 video.
Because it is from marketing it looks great.
I'm still of a mixed mind.

Hello, I have a situation where I'm trying to determine the number of
payment periods remaining with a constant payment and interest rate. It
looks like the NPER funtion should do the trick except I can't seem to get
it to work....so I've gone back to basics and that doesn't work ...

I have a table with 1700000 records. I have a field that is a text field and
I want to make it a numeric field. Since it has numbers entered.
I can't change the file type from text to number since I get the message
that there is not enough disk space to proceed to the change. I ...

I need to check for the existence of a field name in a Table before some
processing code - can this be done ?
Thanks

Is there a difference in the results when using either of these ?
Thanks

I noticed that changes made to fields are only commited to the Tables when
you move off the current record - Cam I commit the changes in VB code ?
Also I have a combo Box that lists records in another Table - when I add a
new record to this Table the combo Box does not get updated ...

I just recently split my database and I made a copy of the front and back end
and gave them a different name.
If I add queries, reports, tables etc. how do I replace the active front and
back end.

I have made 1 to many relationship.. but I still don't get the use of that. I
don't know how to make use of it.
I made a customers table which include a field "customerID" as a primary key
and other info fields about the customer like address, state...etc

This database is for teachers in remote locations to share Math lesson plans.
Many plans will reference another website only; others will have quite a bit
of text to be included with each plan. These plans need to be in a specific
format. Our goal is to start with five teachers, ...

I am making a userform that allows users to enter data about car
dealerships. I have a combobox (cboDealer) that displays a dynamic list
(DealerList) of dealerships. I also have a combobox (cboSig) that
allows the user to enter the name of the person who authorized a

I would like to be able to have the date set by default, as the
current date, when the table is created. I'm kinda new to SQL and am taking a
course in it. Here is my current SQL code:
create table

How kan I have my database run a Stored query "qryUdateMembers"
each time the database program is opened? (It is checkin a date for each
record
and if it is less tha the date to day, I do some updating stuff...).

The user makes a selection from two list boxes then hits the Run Query
command button to show the results of the selection made.  The selection is
showed via an unbound box linked to a query.  I want to be able to print the
selections made.  I created a Print command button via ...

I want to create a unique reference number for documents relating to
different projects.I need the refernce numbers tocombine letters and numbers
and for the numbers to be sequential for each group of letters.  For example
AMV1, AMV2 etc or MOB1, MOB2.  Is this possible and is it ...

For the second time in as many days, my file has gone corrupt.  The first
time, I had No Locks.  From a backup copy, I rebuilt my DB and changed all
forms and queries to Edited Record Lock.  Today, after the file went corrupt
a second time, I changed to ALL RECORD Lock.