I am trying to create a database that will allow me to put all the names of
the people in my command on the left side of the page.  Then all the
qualifications that we can get across the top.  I would like to be able to
track each qualification column ie.  If my boss wants to ...

I need some help with this code that I need to use.
I hope it is easy enough to be understood.
The problem is I want to use a variable strTemp for the acViewPreview on
the DoCmd line below.  I think it is the Dim that is causing a type

Hy,
       I have Windows XP environment and office 2003 and 2007 is installed.
Last week I had a Access 2003 class and the instructor was doing vba coding
and she would get a object language error. I found out that access 07 uses

Hi ng
I would like to create a checkbox in Excel which runs a Macro in Excel. I
would like to do this from Access VBA (automatic) - I know how to create the
checkbox - but I have no clue what so ever - how to create the Macro.

How to put good words into a resume for a banking Representative?

I am still wondering how to update my subform more consistently. Not to
mention when I delete a record it shows the row as "deleted". I have to close
and open to update the subform. Again, I use Me.sfrmABC.Requery to update. If
I use the DoCmd.RunSQL strSQL and then Me.sfrmABC ...

I have a table with general information in it such as Subject,
Reference Rumber, Comments.  I would like to have another table with
Company Reference and Responsibility. So when I create a new record
including Subject and Reference Number, I could look up values from

i have a text field that has an alpha-numeric field (the first three digits
are letters followed by either 6 to 8 numbers) example AUX12345678 and i need
to remove the letters and just extract the numbers.  
how do i do this?

Simple question (I hope):
I placed a Calendar control on a report (to make it look spiffy).  Now I
would like to print the report with the Calendar heading based on a value the
user inputs.

I have numeric values in 10 separate fields in one table. I want to calculate
standard deviation (stdevp) for the values.  How do I wite the expression?
Bob

I have a form that allows a user to select multiple criteria to search for
records in a table.  I am trying to make the form as flexible as possible  
and allow the user to use as many or as few criteria as they want.  The
selections on the form are then fed as criteria to a query ...

Recently upgraded to Access 2007, and due to having two monitors I would like
to have the navigation pane on the right side instead of the left -how can I
do that?
Cheers,

I'm trying to delete a record in an access database table and get the
following error: The search key was not found in any record. Error 3709. This
error occurs when an ISAM seek is being executed and there are no matching
values in the index.

How can I substitute a Yes/No value with a jpeg image of a checkmark or X
respectively?  Thanks!

I built a Database application that used Access as its DB backend for a
library. Initially, the application was meant to support only routine tasks
of the library staff, and was not available to the public. However, it has
been so successful that the library has decided to allow ...