I have an Access db currently in 2002 that could be upgraded to 2007 if
necessary. I have about 12 people who need to read, edit and create new
records in. Plus I need to be able to make design changes. My problem is that
those people are all individual with stand alone computers ...

I need to be able to use VBA and in A2007, the choice seems to be  Enable or
Disable.  If the security means you can't use VBA, how is it feasible to
have security?  I tried to select, Disable Macros with Notification and list
my local drives as Trusted Sites, but Access doesn't ...

Hi I have table that has (among others) three date-time fields: Arrive,
Complete, Leave.  I would like to create a query field that counts, for each
arrival, how many pt's are completed but waiting to leave.   I did this w/ a
sum product line in Excel but haven't been able to ...

I want my database to be accessed by other people.
Since creating my database I have not accessed anything that has told me my
database is locked to other users, how do I now rectify this and have it
accessible to other users?

I have created an option box with two radio buttons - 'Complete' & ' Not
Complete, and a text box with for a date (short date format).  When the user
clicks 'Complete', the date box is enabled and a date is entered.  When they
click 'Not Complete', the date box is disbled, but ...

I installed the Office 2007 Trial to try our Access and it seems that
everytime I open it, a confguration process occurs, which is slow.  How can
I get around it.
Thank you and God Bless,

I have a simple address table, with first name, last name, addresses, etc. I
would like to add a catagory field for each member's interests. A member
could have multiple interests. Say I have Catagory 1 - Book Club, catagory
2 - bridge group, catagory 3 Christmas card list.  How ...

I tried to open an .mdb file (a copy for testing) in Access 2007 and it told
me it had to remove the code and it did.  I know this is a security feature,
but how can I turn it off?
Thank you and God Bless,

I have a dropdown (combo box) where the Row Source is a sql statement.
After it has loaded, I would like to add a row with the contents "All".   Is
this possible?  If so, what is the syntax?  My code already has a requery on
that combo box for other reasons, so placement of the ...

i have a form that contains some fields that are bound to a table and
the others i grab a recordset.
for some reason the fields that are bound by the recordset get cleared
out.

I am making a simple football schedule database which includes:
Team
-TeamId (primary key)
-TeamName

Using microsoft office 2003 I am able to make a datasheet but cannot print it.
When I paste it  into Microsoft word I get only the text and that is
garbled. I cannot get the grid lines of the chart to print. I am trying to
make a yearly ..monthly budget report and print it out.

I have an On Load Event Procedure for a single form to turn the Mouse wheel
off as follows:
Private Sub Form_Load()
'Turn the Mouse Wheel Off

I have a problem with the Bookmark procedure on a form ("Appt") with a
calendar control.
The date field is a combobox[cboStartDate] which opens to todays date or on
click

My recently created database is experiencing (yet another) problem. At the
moment the file/database is saved in My Docs, which obviously isn't very
helpful if I wish to delegate to another member of staff to input. I tried
this morning saving it to our server but it will not le ...