Can Anybody tell me where can i find an e book which helps me to learn
from the very basics. I m good at excel but Im new to VBA and
desperately need help as im lost and am not able to decide where to
start.Pls note that i need to learn from the very basic terms.I would

I am getting the message "Procedure declaration does not match description of
event or procedure."
It started when I wrote the following procedure for an Access 2002 database:
Private Sub Form_Open()

Good morning,
I have a text field A for 4-digit year (e.g. 2007).  I also have a date
field B.  I like to write a formula to add a date into the date field B using
the year from the text field A.  

I am executing  DBEngine.CompactDatabase on a database in a VBA module.  When
the compact finishes the compacted database is a few Mb smaller.  If I go
into that database a run a compact the compacted database shrinks by more
than half.  

I have a sub form on my form and on that there is a ComboBox, when the
ComboBox is activated the GotFocus is applied, I am trying to be able to have
the options to choose in my ComboxBox selectable.
Am not sure I have explained it very well, but here is my code, any

I am probs missing something small but cant see it for looking and been
staring at it for far too long, I'm getting an error message for one line of
code saying:
Error "2447"

I'm working on a project were I have tables for Companies, Addresses and
Contacts, as well as a bridge table that links all three.  I know it is
cumbersome, but the contacts can belong to multiple companies and have
multiple phones, faxes and addresses and the companies can have ...

How can I get this SQL to add to a table
Option Compare Database
Sub OpenDataBaseConnection()
Dim objConn As ADODB.Connection

What am I doing wrong Any help would be great
Getting Error -2147467259(800004005)
[Microsoft][ODBC Driver Manager] Data source not found name not found no
default driver specified

I am getting the message 'Error accessing file. Network connectionmay have
been lost'. First I am not on a network. This happens when I start some forms
or if the form displays the it happens when I click a command button.  I do
not know what is happing can someone give me some ...

I am planning to build a IT Lab booking system in Acccess.
I'm looking for a way to automatically email the member of staff at the
college who has booked the room, confirming the time and date of their
booking.

Im trying to trap error 2450 and it keeps giving me a Compile Error: Label
not defined  and highlighting the row (On Error GoTo ErrHandler) What am I
doing wrong? Thanks!
Private Sub Form_Timer()

An interesting problem, I thought some of the MVPs/Gurus/Masters may have
some experience and provide some help/guidance if possible please.
80,000+ records in a table, need to generate XY graphs of this data
automatically first and then paste the graphs in a DOC and PPT.  

Thanks for taking the time to read my question.
Currently I'm sending an e-mail message with this:
DoCmd.SendObject acSendNoObject, , acFormatRTF, Manager & ";" &
TheDefaultVendorEmail, TheDefaultCc, , TheEmailSubject, TheMessageText, -1

All of a sudden the code below fails to compile and complains that the
UNDO method is not found......This happens on two different PCs.
Ironically, the code works properly - but it just won't compile.
References are fine: no complaints re: missing references.