I am hopping some one can help me I have an application in Access 2000 which
has been running on XP and XP professional for a very long time every morning
this application creates a list of reminders it then creates an E-Mail for
each reminder and with a loop it sends all the ...

Hi
I cannot execute the vlookup function on my excel but on other peoples
machine it works fine

When I receive an e-mail with an attachment I get the message 'Set
Association' in the control panel.  I have searched and cannot find this.
Is it maybe because I have Vista and the attachment is in Word?

I was wondering how I make one field equal something in other feild on a
form i.e.
I want too enter in a town in one filed and the post code/ zip code is
automatically enter into the zip code field.

Unable to set the Format on a date..it appears in eXCEL as its date number.
Code snippet..
objXLSheet.Columns("I:I").NumberFormat = "Short Date"
TIA - Bob

I USE DLOOKUP ELSEWHERE IN THE DATABASE AND NO PROBLEM
Dim occ As String
occ = DLookup("Description", "Gal", "ID=" & Me.Name)
I USE THIS ON AN AFTER UPDATE POINT

I have a clear button and when I click it I have some vba code that I want
performed.
Example (does NOT work):
.... cmdOK_Click()

have opened a 2003 db in 2007...opens fine, but when adding records I am
getting an error as follows:
Microsoft Office Access
-2147352567 Method ‘Nz’ of object ‘_Application’ Failed

As long as the Letter typed exists...I have AutoExpand enabled.
Can that be coded?
TIA - Bob

I run projects for retail customers.  I have a form that allows me to see all
of the phases of the project at once.  I cannot figure out how to display the
entire record of the particular unit on which I am working.  Subforms haven't
worked as I need to choose from a master list ...

I have an exisiting Access Database (FE and BE). I am planning tomove to SQL
Server back end and I have imported the existing Access table structure into
SQL Server, rewrite Views and made some modification to forms. I will needs
some recommendation on the following:

I have a table [Admins] with a field AdminID and a table [Clubs] with
a key field ClibID. An Admin can manage one or more clubs. and there
can be more than one Admin for each club, Admins are either the
teacher in the school that has responsibility for the chess club, a

I need to generate a report from a form using a control button that only uses
the data currently displayed on the form.  I have the basics of form building
down, but I keep getting every record in my data table.  Thanks.
Ed3

I hope someone can shine a little light on this.....for some reason from time
to time, when I try to open a program (almost always an OFFICE app), the
Windows Installer routine will come up instead.  When I finally am able to
cancel the installer, and try to open the app again, ...

I've used the 'find as u type' utility
(http://allenbrowne.com/AppFindAsUType.html) many times successfully, but
I'm now running into something I can't solve. When I base the form on a
table or selection query, everything works fine. But when I base the form on