In a report of mine I have two fields [ProjectedUnits] & [ProposalAmount]
First I am trying to get the sum of [ProjectedUnits] In the footer I used a
text box,
and I put =Sum([ProjectedUnits]) and it came up error on the report?  Not

I am new to Macros for Access, is there a good book someone can recommend
that is not too techy.....if it involves VBA forget it.....but thanks in
advance for recommendations.....
I am trying to build a small menu for some non-computer literate desk clerks

I am new to Access 2007.
I have a Foxpro 2.6 background.
I have imported an Excel spreadsheet into an Access table.
I need to manupulate the column data ie. telephone number for 9996667777  to

Hi,
What I want to do is click a value from a combo box or list box and open a
form or report with that record for editing or printing purposes.
I am using a form I created that acts as a cover sheet that has buttons that

Trying to output 3 queries and create just 1 excel .xls or .csv file with 3
tabs. Is this possible please? If so how do I do it?
Cheers
Sue

Alright I have a issue with one of my Macros.  What I am trying to do is dbl
click a field in a form (datasheet view) and open another form with the same
record.
I created the macro to open the secondary form and in the where condition I

I have a multi-page form [looks like tabs].
FieldA shows on Page1 and Page2 of the form
When I check FieldB, I want FieldA to be hidden
1) on the current Page1

I have a macro in an Access database that I would like to call in a macro I'm
creating for excel.  How do I do that?  And is it possible to do without
opening Access?

I maintain a massive MS Access Database for the project I'm working on. Here
is the situation. I have a table that lists contact information for people
who work on the project (including email addresses). I also have a table that
keeps track of the same people and what email ...