Speed up your system, repair registry base,  uninstall hidden windows
components and get rid of boring errors with powerful tips and tricks.
http://windowsxpsp2pro.blogspot.com

Dear group,
I am the new volunteer coordinator for a non-profit organization in
Tucson, AZ.  One of my main focuses is to develop our own volunteer
pool using either MS Access 2002 or Excel spreadsheets. I've used this

Is there an easy way to add the same code (a function) to all of my fields'
GotFocus without having to do it manually?
thanks,
john

I have a field on my form of which I'm setting the value programmatically. I
don't want the users to be able to setfocus to the field. I've set the
tabstop property to false. However, the user is still able to click in the
field and then it gets focus. How can I prevent the user ...

I am trying to insert the field value which is depended on formula
into the table. The given field me.field28 and me.nodlyd are working
but me.field34 is not working and the givne error message is
displayed.

I'm experiencing the following intermittent problem with Access 2003
(Access 2000 file format) under Vista. Sometimes when I close a
database by closing the database window I get the following unhelpful
generic message: "Microsoft Access has stopped working. A problem

Is there a workaround to the bug that loses the first record in a
continuous form after using the scroll wheel if the available records
don't fill the form?  I know that the "up arrow" section of the
scrollbar can be clicked to show the record again but this is hardly

Hi - I'm trying to figure out how to append a record to a table and
then open a form and display that record. My thought was to use the
autonum primary key field (recordnum) and display the highest value
(which would be the new record), but I'm not sure if that can be done.

I'm getting the infamous error, "Too few parameters. Expected 2", when
executing an update SQL statement in VBA. I assume it's a SQL syntax
issue, but I can't find the problem, and I used a VBA generator to
generate the SQL statement.

I have an mdb with a *projects* table.   I also have a *timecode*
table.
Projects and timecodes are related by a one-to-one relationship but I
do not want to simply add the timecode field to my projects table for

In a gradebook database, student grades must be computed from 2
scores: a Daily grade, and then scores from Assignments. Knowing about
nested forms, I am requesting direction on how to set up this
particular case of form and subforms. Currently, there are 5 tables:

Is there a way I could setup access security such that only a certain
group a given access form while another group can open all the access
forms in a database.
Can I put password security for this.

Dear reader,
I have a Snap Shot file located in a folder.
Now I like to view the Snap Shot file.
First I created a string with the full pathname and Snap Shot file.

First - I don't know VBA very well at all.
I have report that I want to email to multiple users that give them the
quantities of their Inventory parts only. So I need something that will loop
through each user and send them a report (as an attachment) with only their

Access 2003
After my app is finished I'd like to create an mde file. Therefore my db has
to be made in the 2002-2003 format. So I've created a new mdb (default in
2000 format), I converted this empty mdb to the 2002-2003 format. I've