I have a column that contains last names.
Some of the last names contain generational data such as II, III, JR,
SR etc on the end.
Ex.  Miles Jr. or Johnson III.

Hi .. I inserted a text box and typed following command =Now() .... It
displayed the date and time but it isn't being updated automatically ...
what do i do so that the time changes or updates on screen on its own while
the form is open.

I can create a combo box to select a field value eg, Regions
The field value has a number of sub categories eg, Cities in the Region
How can I create another field that will allow me to select only the cities
associated with the selected region.

This may have been answered before, but I have not found where so please
forgive me if this has already been answered elsewhere.
I have a students table with all the "person" data, a class/course table
with the course name, Course Number and all course related information.

I am using access to create a database that works like a library card
catalogue. You can enter in a new record about a book or search the records
for a book you need. My enter new record form works great, but my search the
records form is having some issues.

I have almost finished a database but I think I only need a bit more help.
I have a combo box for employee names and I have used cascading combo boxes
to populate four other list boxes with unique employee information.
I kept wondering why this information wasn't being stored in ...

Access 2003 was installed on my PC.  Every time I now open my mdb file
created in 2000 I get a security warning that reads;
Opening C:\PT\New Process Tracker.mdb
This file may not be safe if it contains code that was intended to harm

I have noticed that I cannot enter the first record into a table through a
form I designed. I can however enter the first record through the table or
the query the is actually tied to the form.
Can you help me to identify what is it that I am not doing right?

i need help very urgent,i need to build group headers and group footers
that appears in a report to implement it on a form.(it can be compared
to 3d object and 1d object)
report is very good for grouping and to get very high resolution of

How can i open a Microsoft Word Document from a command button on a form in
microsoft Access?

I have an append query that adds a record to a Table. The table has a key
field that is incremental.
to my utter amazement when the query runs the new record does not
nessassarily append the new record to the end of the table. It fits the

Have posted before but cannot find response, not even using link in
'notifyMS@microsoft.com' email. Sorry.

I have 2 tables in SQL: property and purchaser. The relationship is: a
property has one purchaser and a purchaser can have more than one property.
As far as I can tell this is a normalised relationship. For example:
tblProperty

I have created a Form based on a Query that displays records in a Month of
30days old, 180days old etc. This "Followup" Form has two Subforms attached -
1. updateable subform to add followup dates to the Main Table; 2. Client
History subform (shows all records for each Client ...

    I'm trying to use 1 function for a lot of tables.
    I want to add a record into a table, but the name of the field in the
record is diffrent,         depending on the Table.
      rs.AddNew