Thanks to the discussion in the "Sound button"-thread I can
play more than one piece of WAV-music under the same button. Magic !
As global functiondeclaration I use the recommanded script of
http://www.mvps.org/access/api/api0011.htm

I am using the following code in Access to create appointments and need to
have it automatically send the appointment to team members.  The email that
displays is empty of any attachments.  The appointment goes into my calendar.
At work we are on the Microsoft Exchange Server if ...

I'm importing an Excel Spreadsheet into an Access table using
"TransferSpreadsheet".  However, the Spreadsheet is 140 MB and it's on a
server halfway round the world.  The import can take 3 hours!  I only need 5
of the 70 or more cells - the rest gets dumped after the import.  Is ...

I would like the values in an Access field to flash or blink based on a
condition?  Examples in Vb would be helpful.  Thanks

hey guys
please bear with me - i have some basic q's about modules and procedures that
im sure would be best explained by someone on the forum
heres my situation: i need to include some VBA code to export info from an

Here is the beginning of some code I'm using:
  ' Set up DAO objects (uses existing "Contacts" table)
  Dim rst As DAO.Recordset
  Set rst = CurrentDb.OpenRecordset("Outlook Contacts")

Everything I am reading tells me I should minimize my use of domain aggregate
functions, so I am in the process of going through several apps to replace
these. In many cases, I can use a join in a query, but there are times when I
need to run the statement from VBA. I need a tip ...

I need help in getting the following pseudo code working.
Thanks in advance.
procedure btnFind_Click()
Ask for Last_Name & First_Name

Any idea why these two dcounts return different values?
Dcount("*", "tblWR", "Created >= #4/29/2006#")  (This returns the correct
count)
Dcount("*", "tblWR", "Created >= " & dtmRequestLimitDate) (This returns a

I have a table called "Outlook Contacts". I need to find and replace a few
characters in this table.  One of them is the plus sign '+'.  I need to do
this in my code, though.  I need to search for the sign + in the field called
"Full Name" and replace it with nothing (delete it). ...

I have two self-contained MS Access database projects (stand-alone mdb
files); one in Access 2000 and one in Access 2003.
What is the appropriate DAO object library I should set as a reference in
order to support my VBA code-behinds?

Good day to all!
I hope someone can help
I have a query, and from that query i have 2 reports: one is comprehensive,
and the other has a filter, that is supplied by a drop down in a form.  i

I am importing a text file that has dates in the format 15MAR06. I have the
following in my schema.ini file but the dates are not imported into the date
field in the table:
DateTimeFormat = "ddmmmyy"

I am trying to write a code to import a table from
another Access database, with a prompt for the user to browse
for the location of the database. My code to import the table works
fine on its own, if I include the path and filename:

How can I format text within a MSGBOX.  I want to BOLD a word inside the
message box so it stands out when the Message box is displayed.