Hi Groupies:
I borrowed this code from a 2003 database and am trying to get it to work in
2007. I don't do code very well so I need some help.
Private Sub cmdDuplicate_Click()

Im using Access 2003 and Lotus Notes to send email.
My Access is using a "split database".
I have created the following code to send an email when the email button on
the form is clicked:

Being rusty at access programming, I need help resolving a #Name? problem.
I developed a calculating form that is populated with several fields from an
entry form.
The information populates when the quote number is entered.

ACC2003
I have a list of source files (Path & Filenames) that I want to copy to a
destination folder (Path). How can I check for duplicates first?
-Brad

I have a form with two check boxes: NotesNeeded and NotesSent
I would like to be able to click a button and filter the form to show only
records where NotesNeeded is True and NotesSent is false.
My current code is:

I have a form that has the following code:
'some code here.....
If ec <> 0 Then
       'Code to question write record goes here

I have a popup form as my database start-up form (set to hide db window) with
the following settings:
recordselectors- no,nav buttons-no,auto resize-yes,autocenter-no,controlbox-
no,minmaxbuttons-no,closebutton-no,whatsthisbutton-no,popup-yes,modal-no.

Please forgive my double post, but I think I've been ignored b/c of the way I
submitted my first post (i.e. with an afterthought reply giving me 2 posts).  
Here is what I still need an answer to...
"jjones" wrote:

I have form with a subform. On my subform object I have an Event Procedure
on "After Update". The Event Procedure has this:  
Private Sub Form_AfterUpdate()
Me.Requery

On form load, how can I code VB to select the last item in a listbox?

I'm using the Browse Folder windows API to get the folder to save some files
in.  What I was hoping I would find is an interface similar to the
FileOpenSave, which would allow me to add folders to the structure right in
the API.

I have created different backgrounds that I use in a form and want to have
users choose which background to use when they use the database.  I have
sample code below which assigns colors to different controls depending on
which background is in use.  For example, if a user ...

This is driving me nuts...
I have a number of combo boxes on a form.  I would like the user to click a
button to determine if there are any combo boxes which need to be completed,
are completed.  For the on click event I have used...

I would like to be able to:
-- dynamically create controls (usually a text box) on a form in the Form
View (not the Design View) based on entries in a table (the contents of which
are managed by another form) in the the same Access database.  Each of the

Hello.  I have a main form that has a tab control on it.  The first tab has
the parent information on it.  The tab also has a subform on it that shows
the children.  My dilemma is when the form is opened the child information is
visible for first record.  What I would like is for ...