Im attempting to automate and Outlook Email send from within an Access
application.  This is the code I'm using.
   Dim objOutlook As Outlook.Application
   Dim objOutlookMsg As Outlook.MailItem

Is it possible to suppress the MS-Access window?
At startup I would like to display a report in preview mode, without showing
the Access window.

I can get a list of those currently in the database, but is there a way of
then kicking them out of it so I can work on it.  I can only find references
to user groups etc.

I have the following SQL statement that is supposed to replace a path in a
table. I have been trying to get it for some time now and thought it about
time to post it. It appears that the vbTextCompare portion of the strPos is
causing the problem. (Maybe something else also, I ...

I am trying to run this code from a subroutine in vba... The filepath is a
constant string "strfpath".  Currently I am getting a "missing operator"
error (where is it!!! the missing operator!!).  Much appreciated if someone
could point me in the right direction.  Thanks

The least complex table in the db Backend is suddenly not "viewable" in
Combobox results of multiple Frontends & forms.
The recordsource queries are always visible in all FE form properties.
"Visible" property is YES throughout every Properties (2 wekks pouring over

I think my last thread got lost while waiting for a response so this is a
resubmission per the netiquette suggestions on mvps.org.
So... I'm working on a system that will track objects in a database.  These
objects are numbered (unfortunately) as A, B, C, D, ... AA, BB, CC, DD, .. ...

Currently, in my database, I'm able to use a command button to send a report
in SNP format. I'm trying to find some help convert this code (posted below)
so that it generates a report & attaches it to an email in PDF format -
again, not SNP. I'm hope a few simple changes will do ...

I am trying to remove some line feed characters. I believe they are Chr(182)
(the paragraph sign)
My vba code sees the character but does not replace it with a  blank, which
is what I need to do.

is there a way I can  loop through all the controls in all the subforms in an
Access form?  I want to call  a function in each control, so I have something
like:
   Dim frmLoop As Form

is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07 and
1/1/08 to 31/12/08 on next year and so on,,

Can anyone advise how I can generate an email from access? I want the user
to be able to click a button which will open an email template in outlook and
populate with data from specified tables and columns.
Thanks

i want to sum if data in table in access database. means same item must be
calculate sum.
sum if like sum if in excel. how to write code?
any body can help me?

Group,
I am currently using a bit of code that I found on google... I would like to
alter it a bit to go away quietly if the backend exists in the current
directory.  I am not too VBA literate, so any help would be much appreciated.

Hi.  I am using VBA to create a file by writing records to it using Open ....
For Output as #1
Everything writes to file fine but a blank line appears at the end.  Is
there any way of stopping this as the file will be rejected by another system