A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Beginner query help please



 
 
Thread Tools Display Modes
  #11  
Old July 11th, 2006, 05:55 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

I was think more along the lines of using "automation" to open an Outlook
email for each record in the result and inserting values into the Subject
and Body. I'll let you do the copy and paste ;-)

--
Duane Hookom
MS Access MVP


"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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







  #12  
Old July 12th, 2006, 01:52 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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





  #13  
Old July 12th, 2006, 01:59 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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





  #14  
Old July 13th, 2006, 04:28 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

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

"Iona" wrote in message
ups.com...
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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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







  #15  
Old July 13th, 2006, 05:57 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

thanks Duane, have a look there, just very unsure as how to actually
contact said form to api.

aside from that do you have any idea regarding the insert as text (into
body of email) command? (as in post 12).. the email feature is
actually working really well!, i just want to refine it a little and
it'll be hunkydory!

cheers
iona



Duane Hookom wrote:
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

"Iona" wrote in message
ups.com...
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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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






  #16  
Old July 13th, 2006, 06:06 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

I haven't used the insert as text command. You might want to start a new
thread since you seem to have gone beyond my experience with this and I
don't have much time to "play" with it.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
thanks Duane, have a look there, just very unsure as how to actually
contact said form to api.

aside from that do you have any idea regarding the insert as text (into
body of email) command? (as in post 12).. the email feature is
actually working really well!, i just want to refine it a little and
it'll be hunkydory!

cheers
iona



Duane Hookom wrote:
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

"Iona" wrote in message
ups.com...
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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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








  #17  
Old July 13th, 2006, 06:19 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

Ok, thanks for all your help Duane, have just done this in .Outlook
forum. I'll keep you posted.

cheers
honor


Duane Hookom wrote:
I haven't used the insert as text command. You might want to start a new
thread since you seem to have gone beyond my experience with this and I
don't have much time to "play" with it.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
thanks Duane, have a look there, just very unsure as how to actually
contact said form to api.

aside from that do you have any idea regarding the insert as text (into
body of email) command? (as in post 12).. the email feature is
actually working really well!, i just want to refine it a little and
it'll be hunkydory!

cheers
iona



Duane Hookom wrote:
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

"Iona" wrote in message
ups.com...
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

"Iona" wrote in message
oups.com...
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

"Iona" wrote in message
ups.com...

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/O...p#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

"Iona" wrote in message
oups.com...
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

wrote in message
oups.com...
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







  #18  
Old July 14th, 2006, 02:27 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

Hi Duane, OMG, i've actually done it, so with it you can use the query
output to send mass email, and you can select an attachment or a file
to insert into the body of an email.

Sounds so simple, but argh, anyway it works, would you like a copy of
the code/etc, you can probably polish it somewhat i'm sure.

kind regards
iona

  #19  
Old July 14th, 2006, 04:00 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

Congrats! I would love to get a copy of the file. You can compact then zip
it and send to
duane AT hookom DOT net


--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
Hi Duane, OMG, i've actually done it, so with it you can use the query
output to send mass email, and you can select an attachment or a file
to insert into the body of an email.

Sounds so simple, but argh, anyway it works, would you like a copy of
the code/etc, you can probably polish it somewhat i'm sure.

kind regards
iona



  #20  
Old July 28th, 2006, 07:11 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

Hi Duane, before I send it to you I am encountering an error message
when I run a search....

'run time error: 3014
Object MyQuery already exists.

so the from MyQuery appears to be either not overwriting or deleting on
close....

any pointers?

ps do i send you the whole db or just the relevant forms/tables? God
sorry I am still so new to this.
chers
Iona


Duane Hookom wrote:
Congrats! I would love to get a copy of the file. You can compact then zip
it and send to
duane AT hookom DOT net


--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
Hi Duane, OMG, i've actually done it, so with it you can use the query
output to send mass email, and you can select an attachment or a file
to insert into the body of an email.

Sounds so simple, but argh, anyway it works, would you like a copy of
the code/etc, you can probably polish it somewhat i'm sure.

kind regards
iona


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL query showing diff between actual and budget Bon Running & Setting Up Queries 3 August 25th, 2005 12:07 PM
Nested in-line Query laura Running & Setting Up Queries 0 February 11th, 2005 01:17 AM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Big number gives error! Sara Mellen Running & Setting Up Queries 8 October 11th, 2004 02:48 AM
Too Few Parameters error Mail Merge Access Parameter Query Tony_VBACoder Mailmerge 3 September 14th, 2004 12:15 PM


All times are GMT +1. The time now is 08:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.