I need to convert an enrollment date to the month of enrollment.  I have
tried several things with no success.

I am in the process of developing some access databases.  I have split
the database (The tables into a back end database and the code/forms
into a front end).  I liked the idea of being able to modifying my
forms anytime and then when complete, being able to copy the front end

I am in the process of developing some access databases.  I have split
the database (The tables into a back end database and the code/forms
into a front end).  I liked the idea of being able to modifying my
forms anytime and then when complete, being able to copy the front end

I would like a suggestion on the best way to design a membership database in
regards to single and family memberships.  
I am taking over this database from some one else.  currently members are  
listed by the main person who is interested in the organization, and a space

how do i create a poper text field, i have tried entering PROPER(text) in the
format properties but this doesn't work

i'm trying to format a field to display and save as proper text, i've tried
putting the syntax (as help suggests) -  PROPER(text) in the format box but
it doesn't work.  any ideas please

I need help to prevent duplicating records in two combining fields. Below is
an example of my data base and what I'm trying to do.
Field 1            Field 2
  A                    1

I have received a Music score database which contains, among others, a
table that has three separate fields: ComposersID, ArrangementID,
LyricsID.
These three fields point to three separate tables: Composers,

How do I force a Field Title (in this case, it is the Caption) to show as 2
or 3 lines instead of just one LONG line?  The data is only 2 or 3 digits
long and the necessary caption is very long.  Thanks for your help.
Vera in Las Vegas

I created a db in Oracle and then linked the tables in Access 2000.  I'm
having a problem with the triggers that I created in Oracle.  Only one of my
triggers works in Access eventhough they are enabled and valid in Oracle.  
The triggers that aren't working are included in some ...

Downloaded an access database template, but cannot open it.  Any help?

I have database splitter errors (subscript out of range and invalid procedure
call) and have found similar problems in the newsgroup, tried the solutions
but failed. So I want to split the database manually so that I can bypass the
problems. Am I recommended to do so? I am going ...

I have a table with a unique record for each member of our church.  Right
now, we use a completely separate Excel sheet with a column for each Sunday
to track attendance.  I would like to use access (so that the members list
updates automatically when we gain/lose someone).  ...

How do you set a switchboard to maximize on startup?  I can open the db
w/switchboard, but need it to completely maximize.

In my datefield name Date_actual I want to put the default value with ( )
now. When I put ( ) now in the field I cannot save the database and get this
error message: unkown function name intable-level validation expression?
My table has only 5 fields