I would also appreciate any suggestions to make the script better (or more
correct). The Function does return the correct period (tested by changing
system date), but it's giving a data mismatch if I am trying to use it in the
query as Between #SomeDate# and #SomeDate# Thanks in ...

I have a Database of 56000 Company Names, when a new record is to be added I
have to determine if the Company exists inthe current Dataset and then
manually decide if it is a new site for that company or updated information
or a genuine new entry.

I wrote a procedure attached on a bottom of a access form which is for
selecting some data and exporting them to excel and plotting a chart. The
procedure work alternatively...that it work for the first time, then an error
of 1004 of Method 'ActiveChart' of object '_Globel' ...

Hello...
I would like to find some sample code that would allow me to send an email
with the reciever having the ability to select Yes or No and send the email
to a defined reciepent.

Please excuse me as I am a beginner.  I have a form created from a query the
query can have up to 30 null fields (ie no fax number, no company name etc).  
When I merge to a word template from this form I would like to exclude the
fields that are null.  Currently when it is merged ...

good afternoon,
I have following problem.
I would like to number my tickets from 1 to n in order to get the sequenceNo
for each ticket.

I've been using a very simple .filesearch routine for several years with
Access 2000 in a Windows 2000 professional environment.
I'm attempting to convert to Access 2002 in a Windows XP Professional
environment.

Controltip text of different controls in a form doesn't appear any more when
the mouse rools over them.
I have used the controltip property (in properties) of each control  which
was ok so far but suddenly the text just doesn't apear any more.

i can't find any documentation for this parameter for the RunCommand statement:
docmd.Runcommand acCmdCopyDatabaseFile
Anyone know what it does?
thanks

I am want to store Word Documents in an Access Table OLE field, and be able
to open them directly in word.  So if I have a word document as in a
recordset set in a field named WordDoc, how could I retrieve the document from
Rst![WordDoc]

I have a Access table that I need to transpose the layout for reporting
purposes. I currently export the file to Excel, run a reverse pivot table
macro (Reorganize_Comments) which produces the result I want.  Is it possible
to do all this in Access without going to Excel.

I am putting the finishing touches on a project. I have received a lot of
help from everyone and do appreciate it very much. This question concerns
preventing duplicate bookings on equipment. The user has a large inventory of
equipment (about 100 pcs.), that he books for certain ...

I am running a stored procedure using a pass-through query.  This stored
procedure will update some summarized values in a table on SQL server and
will not return any recordset.  However, how do I know when it finishes
running and whether or not it runs successfully by using VBA ...

I hope you don't mind me lauching straight into a question. Thanks for a
great forum, I have picked up a few good tips here! :)
Anyhow, here is my question:-
I am loading information from an array of bytes and then immediately storing

I have a Microsoft Access 2002 ADP that goes against an MS SQL Server 2000
database.
Within this MS Access ADP I have a recordset (forward only, read only,
cachesize 1) that is the result of a SELECT. . .WHERE EXISTS query. This