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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Skip pattern based on text box value



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 06:45 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default Skip pattern based on text box value

Hi, I have a text control. People will be typing either words or
numbers into it. If they type 99 I want to skip down several
questions. Here's the condition for my macro:

[Forms]![frmFB213]![FB215]=99

The action is 'Go to control' and the control name points to question
FB229. I've put my macro in the AfterUpdate section, but nothing is
happening. I'm suspecting this is because the answer is free-text. All
my skip patterns based on combo boxes are working well. I've tried
putting single and double quotes around the 99, I've tried using the
"Like" feature with 99 in and not in quotes. Can anyone tell me what
I'm missing? Thanks so much!

  #2  
Old June 2nd, 2010, 09:57 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Skip pattern based on text box value

What is the data type of the field underlying that control on the form?

Are you saying that you have one control per question? If so, what happens
when you add/remove a question? Doesn't that require you to modify all your
forms, queries, etc.?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" wrote in message
...
Hi, I have a text control. People will be typing either words or
numbers into it. If they type 99 I want to skip down several
questions. Here's the condition for my macro:

[Forms]![frmFB213]![FB215]=99

The action is 'Go to control' and the control name points to question
FB229. I've put my macro in the AfterUpdate section, but nothing is
happening. I'm suspecting this is because the answer is free-text. All
my skip patterns based on combo boxes are working well. I've tried
putting single and double quotes around the 99, I've tried using the
"Like" feature with 99 in and not in quotes. Can anyone tell me what
I'm missing? Thanks so much!



  #3  
Old June 3rd, 2010, 10:49 AM
sandypeter111 sandypeter111 is offline
Member
 
First recorded activity by OfficeFrustration: Nov 2008
Posts: 17
Default

Quote:
Originally Posted by Jeff Boyce View Post
What is the data type of the field underlying that control on the form?

Are you saying that you have one control per question? If so, what happens
when you add/remove a question? Doesn't that require you to modify all your
forms, queries, etc.?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" wrote in message
...
Hi, I have a text control. People will be typing either words or
numbers into it. If they type 99 I want to skip down several
questions. Here's the condition for my macro:

[Forms]![frmFB213]![FB215]=99

The action is 'Go to control' and the control name points to question
FB229. I've put my macro in the AfterUpdate section, but nothing is
happening. I'm suspecting this is because the answer is free-text. All
my skip patterns based on combo boxes are working well. I've tried
putting single and double quotes around the 99, I've tried using the
"Like" feature with 99 in and not in quotes. Can anyone tell me what
I'm missing? Thanks so much!
The aim is to fix problems and all concerns as to who makes the hardware or software. Expect more. IT support Los Angeles and small business consulting offers premier small business computer consulting and managed IT services paired with easy access to computer sales and order management via online computer stores and help centers.

=====================
Project Management Software
__________________
Web Based Project Management Software | Computer Support Los Angeles | Project Management Software

" The more hands you shake, the more money you will make."
  #4  
Old June 3rd, 2010, 01:10 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default Skip pattern based on text box value

Hi Jeff,

The data type under the control is Text. This project is for data
entry for a large questionnaire. So each question on the questionnaire
has a control on the form for an answer. If I need to add questions it
doesn't screw up the numbers because they are already assigned on the
paper questionnaire. If I need space for another answer because the
respondent checked two boxes instead of just one, the question becomes
210a, 210b, etc. Is that what you're asking? Thanks!



  #5  
Old June 3rd, 2010, 05:13 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Skip pattern based on text box value

Not sure how this responds to the original poster's request...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"sandypeter111" wrote in
message .. .

Jeff Boyce;3741109 Wrote:
What is the data type of the field underlying that control on the form?

Are you saying that you have one control per question? If so, what
happens
when you add/remove a question? Doesn't that require you to modify all
your
forms, queries, etc.?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" wrote in message
...-
Hi, I have a text control. People will be typing either words or
numbers into it. If they type 99 I want to skip down several
questions. Here's the condition for my macro:

[Forms]![frmFB213]![FB215]=99

The action is 'Go to control' and the control name points to question
FB229. I've put my macro in the AfterUpdate section, but nothing is
happening. I'm suspecting this is because the answer is free-text. All
my skip patterns based on combo boxes are working well. I've tried
putting single and double quotes around the 99, I've tried using the
"Like" feature with 99 in and not in quotes. Can anyone tell me what
I'm missing? Thanks so much!
-


The aim is to fix problems and all concerns as to who makes the hardware
or software. Expect more. IT support Los Angeles and small business
consulting offers premier small business computer consulting and managed
IT services paired with easy access to computer sales and order
management via online computer stores and help centers.

=====================
*'Project Management Software' (
http://www.project-drive.net/)*




--
sandypeter111



  #6  
Old June 3rd, 2010, 05:15 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Skip pattern based on text box value

Nope, I was trying to imagine modifying the form every time I needed a new
question.

Consider looking into the more normalized survey/questionnaire design
offered by Duane H.:

http://www.rogersaccesslibrary.com/f...osts.asp?TID=3


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" wrote in message
...
Hi Jeff,

The data type under the control is Text. This project is for data
entry for a large questionnaire. So each question on the questionnaire
has a control on the form for an answer. If I need to add questions it
doesn't screw up the numbers because they are already assigned on the
paper questionnaire. If I need space for another answer because the
respondent checked two boxes instead of just one, the question becomes
210a, 210b, etc. Is that what you're asking? Thanks!





  #7  
Old June 3rd, 2010, 07:12 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default Skip pattern based on text box value

The design of my database aside, all I want to know is whether Access
can recognize a particular free-text response and act accordingly. Do
I need quotes, should I use the "Like" feature, etc?

  #8  
Old June 3rd, 2010, 07:12 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default Skip pattern based on text box value

The design of my database aside, all I want to know is whether Access
can recognize a particular free-text response and act accordingly. Do
I need quotes, should I use the "Like" feature, etc?

  #9  
Old June 3rd, 2010, 07:20 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Skip pattern based on text box value

The design of your database isn't an "aside".

"How" depends on "what" ... and the "what" is the design of your database.
It all starts with the data!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" wrote in message
...
The design of my database aside, all I want to know is whether Access
can recognize a particular free-text response and act accordingly. Do
I need quotes, should I use the "Like" feature, etc?



 




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


All times are GMT +1. The time now is 06:41 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.