Is there a diagnostic tool which I can use which will tell me what is
running in the background that I don't need when my PC boots up? I seem to
use a lot of RAM even when nothing is open.
Also, I leave my PC on all the time. At regular intervals during the day &

I have a database that I going to use for tracking expenses/income.  I've
used functions and other things I've learned here.  Anyway all went well,
everything works very nicely.  As I was building this database I kept it on
my desktop and when I was satisfied it was working ...

1) Create secure workgroup system database, remove user
ADMIN from the ADMINs group
2) Encrypt the source MDB front end database
3) Create 'n distribute MDE from the encrypted MDB

In an 'Update' query can you use user-defined functions in the 'Update
To' for the query?  Either no or I'm missing something.  See the
additional info below.
If I run a query as a select query it runs fine.  The select query is as

Hi there, this is my situation:
I have a query base on table.
But every week i get a new table and i dont want to have to go in my
query and maje the change. Is there a way i can have a pop up window

here is what i want to do:
i have a database that has records of properties i list to sell and
then eventually sell.  I have a Word document with pictures embedded
into it for each property.  What i want to do is be able to, within the

Hi there.  I am attempting to create a Word mail merge from which I
want to list several items for one particular category, i.e. a
1-to-Many relationship where a Service is the one, and Agencies is the
many.  I understand that I need to create a user-defined function that

Has anybody used something like DSOFile to read and write properties
of folders on an NTFS drive?  This will be for my own use, so things
like security don't really matter to the project at hand.
I can read some file and folder properties, but not all.

I have form that looks a lot like a search bar for the user to search
for records matching specified criteria (e.g. first names containing
"ben").  For robust results, an intermediary form displays all records
matching the criteria (hmm...sound like a popular web site I know).

Can I run vba code from a string?
Stuff like Field1.ControlSource = "Documents"
Its sort of similar to running an sql...but not.

hopeing someone can help me here...
I have a deductions table and form and want to be able to add many deductions
to the table by having only a few fields on the form
form fields: deduction ID, start date, end date and amount

I have a report for creating the switchboard labels for our phone system
receptionist switchboard.  The template has 12 records per column.
I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out.  The report is ...

I'm wondering if there is a way to make an access button appear pressed in?
I know there was a property or something similar in VB to make a button
appear pressed in.   What I'm looking for is not so much for programming,
but for graphics.  I have a complete set of buttons ...

I need to be able to remove <BR>'s that are placed in null fields
(Access 97) for blank records when doing html imports. Of course,
Access does not recognize the html tags and are invisible. Aside from
pressing the delete key twice in each null field to remove the <BR>'s,

  I have an email macro setup (maybe I should go another way, but that
was the quickest at the moment...) and what I would like to do is
automate the "to" addressee of the email it generates for sending.
  What I have is an email button that creates a report based on a