I have the following code in a asp file on my server 2003 IIS server.
The code works fine, it open the databse and runs the macro.  However,
if I change the staff list macro so it uses the SendTo function, the
code will not send an e-mail.  I can log onto the server and run the

I am attempting to distribute a 2007 Access db with mainly VBA code but 2
Macros. The Macros are Autoexe which starts a function and a macro to handle
the ribbon. The db has been developed on a machine running Office 2007 under
VISTA.

I used one form as a GUI template for another but changed the record source,
deleted all of the unnecessary controls and code behind and added fields
based on the other table.
Then I tried to create a combo box to lookup a record, which normally gives

Hi Team,
I have a databse which connected wiht netwrk. i can't log it because of the
server. how can i disconnect it to take the date from the database?
Regards,

How can I set up my button so that when a user updates the "OriginalDate" OR
"CompleteDate" something will pop up saying "You need to click the Turn Time
Button" of something to the fashion.
Thanks!!

I would like to call a macro in Access 2000 via a asp file.  I access
the DB via ADO.  I realise that I would need to place the database on
the server, but that's not a problem as its a intranet site.

I am trying to create a query that drills down and creates a parts list.
We have a database that has their parts in one table (tblParts). There is
another table that has the parts materials (tblPartMtl).
The way it works is that we have a top level part. That part has other parts

I'm trying to put text in an unbound text box in a form as follows:
Me!txtPriority.Text = "Rush"
This is taking place during the On Activate event procedure for a report.  
Initially, I got an error message saying the control had to have the focus.  

When I receive an email message with Greek from a PC on my Mac (Entourage)
and I forward or reply to this email the recipient receives a message with
question marks. This happens only with Greek.
Your advise as to how I can resolve this problem will be much appreciated.

I need to send a query string to an asp page, and although I've created a
function to replace certain characters (%, & ,+ etc), I was wondering if
there was a built in VB function like UrlEncode to do the job properly from
within Access.

I'm attempting to take a table which shows pending orders by SKU and have the
data appear in a subform for a Form.  The problem is the original table has a
single line for each order # which means I may have an SKU repeating several
times depending on the # of pending orders for ...

Can anyone help me...how to prevent redundancy of records in append query?
When I run my append query more than once, it adds all the old records as
well.
Thanks.

i was wondering if anyone can help me please.. i have a problem
basically i have created a table in microsoft access.. 3 of my feilds are
named:
sub total

I have VB application that uses and Access 2002 database as the
backend. I have a couple of clients who have had me log on their
system because of errors when logging in to my application. Upon
investigating, I discovered that both of these clients had a database

I have an access front-end/backend app ie backend is not directly opened by
the users. How can I set the backend db to automatically compact & repair?
Many Thanks
Regards