There are some nice functions at
http://www.mvps.org/access/api/index.html
for browsing for a file or folder and retrieving the network ID.
--
Duane Hookom
MS Access MVP
actually, you know what else might be nice, would be a little drop down
combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs
etc etc (for attachments and for files to insert), is this a nice
little prefab windows job? Or does it all need to be programmed in the
exhausting way (sorry could probably figure it out myself, but btwn
work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired.
hmm... just remembered that this would be a open file dialog box, is
this easy to pop into an access form?
cheers
Iona wrote:
Duane! All right, All right.... stop nagging me! I've done it, just
one
tiny snag..
I would like to utelise outlook 2003's insert as text facility,
primarily to be able to insert an html file into the email body,
however an stuck on actual code syntax..
I imagine it would be vaguely similar to this:
If (IsNull(Forms!frmMail!AttachmentPath)) Then
Else
Set objOutlookAttach =
.Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1)
End If
but with a .insertastext(Forms!blahblahblah) kinda command.
Anyhelp with syntax here would be very much appreciated.
kind regards
Iona wrote:
Hi Again Daune,
I've been poking around Outlook and your programmes query output,
I've noticed that if you (eg) select all the query output (in this
case
the Email field), Outlook 2003 will accept a simple copy and paste
into
the "To." text box, where it will automatically delimit all the
entries.
hint hint... nudge, nudge, could be simpler than you
thoughtttt........???
cheers
Duane Hookom wrote:
You can output the merge report to Word. Beyond that, I would take
a
while
to update the application. I would accept code from someone else
(hint,
hint).
--
Duane Hookom
MS Access MVP
God, i'm such a gumby somedays, ta.
As for Outlook, the database I am creating is specifically for
mass
mailouts (via word mailmerge), and mass emails, so they want to
search
their database for everyone who wants say a holiday rental at
xmas
and
email them all their e-brochure.
kind regards
Iona
Duane Hookom wrote:
I hadn't really thought about output to Outlook or email. Can
you
describe
what functionality this might provide? I would be interested in
adding
something if I could keep it fairly generic. Different email
clients
might
use different code.
BTW: You shouldn't use your real email address in postings to
public news
groups. You might be inviting tons of junk emails. You might
want
to
mudge
your email as something like: hmcgregor AT internode DOT net.
--
Duane Hookom
MS Access MVP
Wow, thankyou Duane, you just made my day. Have you thought
about
putting an outlook connection on it. Its a really excellent
solution.
Thanks again for you patience.
Duane Hookom wrote:
There is a query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
which
allows users to select fields and criteria. Results are
displayed in a
datasheet subform.
Controls in most query solutions would not be ignored. They
would be
Null.
You can create a criteria in a form like:
WHERE ([FieldA] = Forms!frmYourForm!chkA or
Forms!frmYourForm!chkA Is
Null)
I still think your table is probably un-normalized and could
better be
queried and maintained if you normalized.
--
Duane Hookom
MS Access MVP
Hi, thanks, methinks you may be right.. Its basically
just a
contact
table, but a long one. I tried putting things into
different
tables
and
came up with a heap of 1 to 1 relationships and my books
said
that
if
thats the case then it probably all belongs in one table.
The
query
is a standard parameter query done by the book. The
controls
on the
form are those that match the data type, checkbox for
yes/no, text
where appropriate etc. I suspect the prob may just be
that
there
are
so many fields. The run button I got of the windows.access
tutorial
site. Sorry I am very much in WSIWYG land and don't know
much
more.
So what i'm trying to do is have a form where the user can
just
click
or enter data in the fields (controls) that they want to
search by
without them having to go into access and try and conjure
up
queries.
So I want to display all the possible fields, let them
select
what
they
want, which feeds into a query and they get their data.
Is
it
possible
to set up a query from a form? (sort of on the fly) Or
does
the
query
need to be constructed first?
does this clarify what I'm raving on about? Does access
ignore
controls left blank when they are linked to a parameter
query?
again
thanks for any help here. cheers
Duane Hookom wrote:
I expect your table might not be normalized. We don't
really
know
much
about
your table, your query, your controls on your form, your
"run
button",...
--
Duane Hookom
MS Access MVP
Hi, thanks in advance, I am very new to access 2003. I
have a
very
simple table which is quite long, many of the fields
are
checkboxes.
I
have created a parameter query and a form to go with
it,
however
I
am
getting a "query too complex" type of message when I
hit
the run
button. What I intended to create is a form with all
the
table
fields
on it, so the user can just click/fill in what they
want
the
search
criteria to be and ignore the rest. Is this possible,
does
access
just
ignore what is left blank/unclicked on a form/parameter
query.
Or
is
the problem just that i have too many fields? I would
appreciate
any
help here pls. Cheers