Hi;
Im using ACC 2000 and when i use DoCmd.SendObject ,even if with no
arguments,this error occures:
Error 2287: Microsoft access can not open the mail session

I am looking for a program that will allow me to search the SQL code for a
list of user SQL queries and replace certain words or table references
without having to do this by hand. Does anyone know of such a program?
Gerry Goldberg

I have a database that keeps track of employee training.
The main form contains the employees bio information, the subform includes
their training( from a training table; they are both linked by Employee
number.)

Is there a way to set a form so that it automatically maximizes when it opens
so that the user does not have to do it?

I'm trying to save a record and then go to a new record when I hit a button
on my form.
I am getting the following error:
Run-time Error '2493'

thanks for all the previous helps
now I am trying to set recordsource for a subform from the main form.
I got error 2455, when I try:
Me.ChildForm.Form.RecordSource = strSQL

Good Afternoon,
Happy, Safe & Blessed New Year to Everyone!
We have an Access 2003 application with SQL 2000 server on the backend. I
recently added another table into our SQL database and linked it into

Hello Group
How would i got about creating a desktop short cut item to be created by
clicking a command button on a form?
This short cut item is to be placed in the "All Users" Desktop directory

Is there a way whereby a form can automatically adjust itself to the
appropriate screen resolution on the user's PC.
Actually, while developing a form on a higher screen resolution and
afterwards deploying it on a lower screen resolution, I found that I could

I am using datasheet view as a subform to add/update data.
1) Is there any Event when the selection changing from one line (recorde) to
another line?
2) and how to identify the current line in VB?

I'm a newbie on programing and I'm having a little dificulty on a database
I'm trying to develop on my work!
I have two forms, lets say frmA and frmB! Both are linked to two queries.
frmA is a list of names and id(index) where country = x. Then I have frmB

I have a form on which the user can enter information
that will be put into a letter.  When the user clicks on
the PRINT button, a letter is printed and a transmittal
form is printed.

I have a form that produces 4 reports.  Two of those I want to email
using Outlook.  I want them to go to a list of email recipients.  I can
do all this by hand but I want this to be in my code with the simple
push of a button for the user.  How do I code it to do so?

Hello, I am looking to generate a PO from an order form that has a subform
that contains the companyname of who we will be issuing the PO to. In most
cases we will not have a problem, but occasionally we will need  to order
from multiple vendors. How is it that, in code, I can ...

Hi;
I need an API to get some hardware informations such as Serial No. of Hard
disk ,MainBoard and so on.Can anyone please help me?
Thank you in advance for your help.