I know that it is better to split than share.  I plan to split, I swear.  
However, in the meantime, is there a reason why I could easily share when I
was running Access 2003 with XP and now that I'm running Access 2007 in Vista
Home Premium I cannot seem to share?  I can share ...

i had a button on a form. when clicked, the button runs code that
retrieve the values of unbound textboxes on the form and saved the
values in a table. the application runs fine on all pc except one. on
this one pc, when the button on the form is clicked, it gives this

In the code given below, strDatabase is set to "C:\Documents and
Settings\stephen\Desktop
\Pocketbooks\Frontend\21Nov2007\Management Pocketbooks FE.mdb"
The program keeps crashing at the line marked ** in my code (below)

in MS Excel there is a worksheet function to roundup values say from 12.32
to 13 ie =roundup(A1,2)
Is it possible to do something similar in the design query of Access

I need to create a database to document employees performance.  I need to
list the employee, their department and then their job functions that they
are responsible for. Each employee in the unit share the same job functions.  
I need to list about 15 different criteria for each ...

I am using the following code to open a database:
Set db = OpenDatabase(strDatabase)
Trouble is, the database I want to open here has a different filepath
to the one I am using. How do I get it to open a database in a

I have downloaded IE7.  Upon doing so, my mail merge documents would no
longer work.  A message comes up to select the document for merging and when
doing so it doesn't open only recircles to the message to select the document
for merging.  I had to removed IE 7 and go back to ...

I need help! I want to use access 2007 and my database was build in access
2000. It have a lot of forms, macros, vba... Will I have problems or can open
my database in 2007 and continue my work?
Thanks

I was wondering if anyone can tell me if there's a way to have the
time populate a locked field in a form, and have it store to the table
that I am working on.. I am trying to record when records are
accessed, and save it to the table entry.

I can't find an old post I was looking for, so I have to re-ask a question
regarding developing a database.
How much time would you suggest be spent developing proper specification
prior to developing the database.

What should be in the Container called 'Scripts'.
Stapes

I have a database with a back end file on a server and a front end file on
each of 8 desktops. On 7 of the desktops everything works fine, but on one
of them the application will close and compact and just before Access itself
closes we get an error message that says can't find ...

I am tracking seminars staff attend. I need to track when certain training
expires (First Aide Training needs to be done every 3 years). Some training
is good for 1 year and others are good for 3 years.
These are my fields:

I have created a report by using a query to link to a MYOB database using
ODBC drivers.
The query uses 3 tables to get various information and i display this
information on a label. It is easy for me to do this because I display each

I have a form based on a query, and I have sets its proprties of
Adding Data and Deleting Data to No. So when the query's result is
zero, I get the empty box. Now I want to set up a macro that displays
a MsgBox. I don't know what should I write in condition. And secondly