QBF

[Guest]

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
..

 

[Guest]

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

 

[Tom Wickerath]

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
_________________________________


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
..

 

[Guest]

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
(e-mail address removed)

Thanks

-----Original Message-----
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

 

[Guest]

I am having a problem with the code and accepting of the
input as well as how to reference it in the query. I have
conflicting information...

-----Original Message-----
Are you have problems with the form or getting the query

to accept the inputs from the form?

 

[Tom Wickerath]

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

___________________________________

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

-----Original Message-----
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

 

[paul bickert]

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
(e-mail address removed)

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