I added code to the switchboard so I could open queries, and that works
great. Got the info from
http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#query
My problem is that if I cancel the input query, I get the msg:  "There was

I've got a sub-form inside a form for which I want to change the recordset
from within VBA. (The sub-form has no recordset for itself and I wish to use
the same sub-form for several different queries, depending on which button is
pressed).

What am I doing wrong?  I'm trying to convert the bad text dates (00/00/0000,
99/99/9999, 88/88/8888) to 1/1/1900 and the remaining good text dates to real
dates:
Function RealDate(TextDate) As String

Hi, i wonder if you can help,
i need to rename duplicate IDs to include an incrementing letter to make
them unique. the ids are alphanumeric, in the format: #A000#####. eg.
7F00013245. There is always a letter second digit, and always three zeros

I have a table that has a text filed containing Values that are not unique to
each record.  I am performing a Select DistinctRow query to get the list of
unique values.  I then want to use the results of that query to use each
distinct value as an array item in order to make a ...

I have built a database to replace an old Job Clocking Card system in a
factory. When the user enters their job details and presses submit i would
like the Date and Time to be automatically placed into a table with fields i
have already defined and Data and Time.

how do i move an excel workbook from one folder to another?
thanks for your help

Access VBA code:
I have created a RTFcontrol box (ActiveX) ref.
(http://www.lebans.com/richtext.htm)  by Stephen Leban
It is working nicely. - but:

In Access 2003, I have a query named Q_Reminder which pulls all tickets
which are older than a week.  I also have a report based off this query named
R_Reminder.  I need to be able to write VBA code that will automatically send
an email to Outlook with the report as an attachment ...

I need to delete all the data in a update table, run several quries to load
the data into the update table and then append the data in the update table
to the final table. I have several queries which do this and one query that
runs then all in the correct sequence. Is there a ...

Having never done this before I need a lot of help. I need to control the
access level for multiple users. Most will have read\write rights to one or
two tables and read rights to all the other tables.
Any help would be great

I have the following code which checks for nulls and if the field(s) are
null, then it will turn the boarder of the box (which all the fields are
listed in) and the field label red.
When the field has been updated with a value, then the colours will change

Hi folks,
I really stuck here, hoping you all can help.
I'm using a combo box to locate and display a record on a form.  Code is as
follows:

I want create code that will call a function on the first day of each month.
Any help?

I want to open an MPD file and insert the following query,
   ssql(19) = "TRANSFORM First(MSP_TEXT_FIELDS.TEXT_VALUE) AS
FirstOfTEXT_VALUE " & _
              "SELECT MSP_TEXT_FIELDS.PROJ_ID, MSP_TEXT_FIELDS.TEXT_REF_UID