We're having trouble creating an MDE file in a batch file called from a
scheduled task.
The following command file works when run by a logged in user, but in the
context of the task scheduler (Windows 2003 server) the MDE file never gets

I've had a number of instances now of "ghost" breakpoints.  This has
generally happened under the following context
1, I'll be debugging some code and will place a breakpoint in the code at a
suitable point.

  I am trying to launch a report from a module in my db using the below text.
DoCmd.OpenReport "rptM16Report", acViewPreview, "teamleaderemail = Bloggs,
Fred"
Unfortunately on the report because Bloggs, Fred contains a comma it would

I have two buttons on a form that generates reports - one that previews
(acViewPreview), after which the user can click on a menu bar button to bring
up the printer dialog (I had to replace the standard printer button on the
menu bar with the one that brings up the printer ...

I've figured out that the following code can be used to change the
default printer to a specific printer and then backagain using
strOldPrinter.
Sub changePrinter(strPrinterName As String)

 I have a query that shows EACH participant's records with dates of an
event.  How do I create a report that includes those records with the
EARLIEST date for EACH participant.
 I can use TopValue if I limit query to ONE participant's records, but I

I have a Access 2003 application with a SQL Server database that performs
intensive data processing for reports. Typically the application gets input
from the user and then launches the data processing and then opens the
report. I'm finding that if the user switches to another ...

I have an Access database that links job addresses to MapPoint. I create an
incident of MapPoint within an Access procedure.  When I finish with the
MapPoint app I close it; however, I still have MapPoint.exe running in the
Task Manager.  How can I purge the MapPoint.exe when I ...

I have the following code to deal with adding new values to a combo box:
Msg = "Do you want to add a new Currency?"
If MsgBox(Msg, vbQuestion + vbYesNo, "New Currency") = vbyes Then
   DoCmd.OpenForm "frm Currency"

I need help on creating  code for a  password, so that some users can edit
the data in the forms and if you do not have a password it will take you to
forms that are read only.  How do I do this?

I am new to Access.  I am rewriting someone elses program.  I have
muttledthrough mmost of what I need to change except during print forms some
prompt keep popping up that I cannot find any procedures for in the view
code.  Is there some way I can turn on a debugger mode so that ...

Long story short: My Access developer is letting me down. He doesn't
really know VB and he can't figure out how to do what I need.
Situation:
Access database that will be used locally on individual user's

I got a problem that calculates the totoal time from when a issue was entered
in a database and the time it was answered. For example, when the issue start
in Feb 02, 05 and is answered on Feb 10, 05, you'll get the correct number.
When the issue cross months, starting in June ...

I have the below code, and I am having a serious blonde moment.  I can't
remember how to convert it so that I can have it transfer stuff from a
specific range in Excel...currently the macro would have to have the info
being transferred to Access in the actual ( ) of the VALUES.  ...

This is what I'd like to do:
Have a button on my form that will import an excel file replacing the
data in my Access Table.
On my form I'd like to have a text box listing the file path of the