I am using a continuous form for display purposes.
Above this form, a single record is displayed so that when the user
presses my NewButton they can enter a NewRecord which gets added to
the continuous form that displays below.

i need to do a project in ms access of at least 6-7 tables for the
university, on whatever subject (cd compilation, pics album etc). as i
dont want to lose much time i was wondering if anybody could pass me
his/her database already done! and send me by mail. the project can be

I have the following 3 tables setup:(Thanks Marsh!)
Students Table
   StudentID      (1 to many)
   Last

Is it possible to run Access 97 on Windows Vista? I have installed
Access 97 and Access 2000, when I run Access 2000, then try to open
Access 97 it says it cant find the windows registry entries?
Re-Installing Access 97 seems to fix it until I open Access 2000 again.

Like a lot of database developers, I often choose Jet for the back-
end. I'm starting to worry about what will happen when Jet is
deprecated. Ostensibly, Jet users like me must switch to SQL Server
(or MSDE / SQL Express), but there's something I just don't

I have created two tables to track my students' lessons.  
Each student is responsible for most, but not all. of the lessons.
I've tried a junction table but I can't figure out an easy way to
assign one or multiple lessons to a student.

I have a form with various fields with a double click event to bring
up a filter via a query.  Is it possible to goto another field and
apply another filter only to the records that were found after the
first filter.

G'day from Australia,
I'm hoping some bright spark may be able to help me with this one. I'm
sure that it can be done, I've just hit a wall with it. So I'm opening
it up.

Hi, If I make an MDE file, and distribute it, how can I do a version
update where I need to modify only the forms and reports and not the
tables? So if the users already have data in their tables, this data
should not be affected. Thank you very much!

Dear reader,
I am familiar with the possibility to change the Caption of a field in a
form.
But is there also a possibility to change the Caption of a field in the

I have this simple query:
SELECT [Fld1] & [Fld2] AS NewField
FROM Members;
Now, in this query, I would like to add a hard return between Fld1 and Fld2.

Indexed.Yes (Duplicates OK).
In my code for remote control i wanted to remove the property  Indexed
of a field, but i receive the date type conversion error.How can i
change these properties by code ?

Hi, On the form, I added a command button and used it to save the
current record. I added some error checking before
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Error # is: 2046

I am currently writing an application in Access 2003.  For the reports,
I have to use columns a lot.  To get the report to look the way I want,
I have to use the Across then Down options, because of access
limitations with columns.  I was wondering if Access 2007 columns are

Can anyone point me to an existing utility or code template to write a
utility?  I want a command line utility, passing in the MDB filename,
producing a file (text or whatever) of tablenames and fieldnames.