QBF

message from anonymous on 28 May 2004

Can any one help!!

I am using Access to run quesries. My queries have a
least 5 prompts. I thought that using a form would be
much better but I am having trouble. I want the form to
have at least four boxes. Two will be drop dowm types
where I can choose a name, and a code. Two are for star
and end dates, and the other two are for: 1) is for a
Country code and 2) Yes or No. I have found some
documentation and I am not having any luck in getting
this to work. Can you either point me in the direction of
some good step throughs or can you provide.

Much thanks and appreciation!!
sharon

Tom Wickerath replied to anonymous on 29 May 2004

Hi Sharon,

This is relatively simple to do if you are using combo boxes, text boxes, etc., where the user is
limited to a single input for each control. On the other hand, if you want to allow a
multi-select listbox, where the user can make more than one selection (the selections within the
list box are "ORed" together), then the required VBA code gets a bit trickier.

If you send me a private e-mail message, so that I'll know your e-mail address, I can send you
some samples.

Tom

AOS168--AT--Comcast--Dot--Net
_________________________________

<anonymous@discussions.microsoft.com> wrote in message
news:1497601c444ec$3fbb0bd0$a501280a@phx.gbl...

Can any one help!!

I am using Access to run quesries. My queries have a
least 5 prompts. I thought that using a form would be
much better but I am having trouble. I want the form to
have at least four boxes. Two will be drop dowm types
where I can choose a name, and a code. Two are for star
and end dates, and the other two are for: 1) is for a
Country code and 2) Yes or No. I have found some
documentation and I am not having any luck in getting
this to work. Can you either point me in the direction of
some good step throughs or can you provide.

Much thanks and appreciation!!
sharon

anonymous replied to Tom Wickerath on 1 Jun 2004

I am having a problem setting the whole thing up. I have
a form and I have all of the prompts set up but the VBA
code is not doing anything and then I get a runtime error
on the OK button. I am not sure that the directions I
haqve are clear or thorough enough. email is
slyons@cephalon.com

Thanks
boxes, text boxes, etc., where the user is
other hand, if you want to allow a
one selection (the selections within the
code gets a bit trickier.
know your e-mail address, I can send you

Tom Wickerath replied to anonymous on 1 Jun 2004

Sharon,

I'm sorry....I didn't mean that you should show your e-mail address to the world. Unfortunately,
there are spammers out there who just love to harvest e-mail addresses using automated software.
That's why obfuscating your e-mail address in a newsgroup posting, such as the example below, is
the right thing to do.

I will send a separate e-mail message directly to you.

Tom

___________________________________

<anonymous@discussions.microsoft.com> wrote in message
news:1650c01c447d9$c83b95c0$a401280a@phx.gbl...
I am having a problem setting the whole thing up. I have
a form and I have all of the prompts set up but the VBA
code is not doing anything and then I get a runtime error
on the OK button. I am not sure that the directions I
haqve are clear or thorough enough. email is
slyonsATcephalonDOTcom

___________________________________

Thanks
boxes, text boxes, etc., where the user is
other hand, if you want to allow a
one selection (the selections within the
code gets a bit trickier.
know your e-mail address, I can send you

=?Utf-8?B?VGFzaGE=?= replied to anonymous on 28 May 2004

Are you have problems with the form or getting the query to accept the inputs from the form?

anonymous replied to =?Utf-8?B?VGFzaGE=?= on 1 Jun 2004

I am having a problem with the code and accepting of the
to accept the inputs from the form?

Archived message: QBF (MS Access Error Message)