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

How to phrase If/Then clauses in the control source field



 
 
Thread Tools Display Modes
  #11  
Old August 13th, 2004, 08:43 AM
M.L. Sco Scofield
external usenet poster
 
Posts: n/a
Default How to phrase If/Then clauses in the control source field

anonymous,

1 - How about a name? Even if it's just a "newsgroup" name. It's hard to
tell all of the "anonymous"s apart.

2 - You didn't really say. Did you finally get it working?

3 - You weren't a "bother." Just an annoyance. :-)

To help us help you in the futu

1 - Try to use the right group. This was more of a code with a form problem.
The "microsoft.public.access.formscoding" group might have been a better
group than "tablesdesign."

2 - Be straight with your experience and what you need. It's OK to not know
things. It is not OK to hide it.

3 - Unless you've taken other database and programming classes, having just
started using Access a week ago, I suspect that you're not really ready to
be working with code.

4 - To be honest, this explains why you're breaking basic design rules with
your "combined" field in the first place.

5 - My recommendation on the book was based on a bad assumption. I
incorrectly assumed that because you were venturing into code, that you had
a *very* solid understanding of databases and Access. Based on only using
Access for a week, you should probably start with some more basic books.
Take a look at "Database Design for Mere Mortals" by Michael Hernandez and
"Microsoft Office Access 2003 Inside Out" by John Viescas. After you get a
solid Access foundation, then start looking into code.

Good luck anonymous.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


"anonymous" wrote in message
...
Hello Sco and Tina,
Thank you both for all your help! I'm
really sorry I didn't understand what you were saying the
first time around and ended up bothering the both of you
so much. I just began using Access last week, and I had't
learnt enough to utilize your advice. I apologize for all
the trouble and I will get "Beginning Access Book" you
recommended. Once again, I really appreciate all the help
you've given me and I'm sorry to have bothered you so
much!




  #12  
Old August 13th, 2004, 10:31 AM
tina
external usenet poster
 
Posts: n/a
Default How to phrase If/Then clauses in the control source field

no problem. come on back to the newsgroups whenever you have a question, and
just remember to try to give specific details about the circumstances -
you'll have a better chance of getting a useful answer the first time
around! there are a lot of really knowledgeable folks here, especially the
MVPs, who will be a great resource for you. good luck as you begin your
"learning Access" journey!


"anonymous" wrote in message
...
Hello Sco and Tina,
Thank you both for all your help! I'm
really sorry I didn't understand what you were saying the
first time around and ended up bothering the both of you
so much. I just began using Access last week, and I had't
learnt enough to utilize your advice. I apologize for all
the trouble and I will get "Beginning Access Book" you
recommended. Once again, I really appreciate all the help
you've given me and I'm sorry to have bothered you so
much!




  #13  
Old August 14th, 2004, 03:19 AM
James
external usenet poster
 
Posts: n/a
Default How to phrase If/Then clauses in the control source field

Hello,
Thanks for the help once again. The code worked
well, and I was able to adapt it a little for the modules
of the other fields. Thanks for all the help and advice!
-----Original Message-----
anonymous,

1 - How about a name? Even if it's just a "newsgroup"

name. It's hard to
tell all of the "anonymous"s apart.

2 - You didn't really say. Did you finally get it

working?

3 - You weren't a "bother." Just an annoyance. :-)

To help us help you in the futu

1 - Try to use the right group. This was more of a code

with a form problem.
The "microsoft.public.access.formscoding" group might

have been a better
group than "tablesdesign."

2 - Be straight with your experience and what you need.

It's OK to not know
things. It is not OK to hide it.

3 - Unless you've taken other database and programming

classes, having just
started using Access a week ago, I suspect that you're

not really ready to
be working with code.

4 - To be honest, this explains why you're breaking

basic design rules with
your "combined" field in the first place.

5 - My recommendation on the book was based on a bad

assumption. I
incorrectly assumed that because you were venturing into

code, that you had
a *very* solid understanding of databases and Access.

Based on only using
Access for a week, you should probably start with some

more basic books.
Take a look at "Database Design for Mere Mortals" by

Michael Hernandez and
"Microsoft Office Access 2003 Inside Out" by John

Viescas. After you get a
solid Access foundation, then start looking into code.

Good luck anonymous.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP,

MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion

picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


"anonymous" wrote

in message
...
Hello Sco and Tina,
Thank you both for all your help! I'm
really sorry I didn't understand what you were saying

the
first time around and ended up bothering the both of

you
so much. I just began using Access last week, and I

had't
learnt enough to utilize your advice. I apologize for

all
the trouble and I will get "Beginning Access Book" you
recommended. Once again, I really appreciate all the

help
you've given me and I'm sorry to have bothered you so
much!




.

  #14  
Old August 14th, 2004, 04:22 PM
M.L. Sco Scofield
external usenet poster
 
Posts: n/a
Default

You're welcome James.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


"James" wrote in message
...
Hello,
Thanks for the help once again. The code worked
well, and I was able to adapt it a little for the modules
of the other fields. Thanks for all the help and advice!
-----Original Message-----
anonymous,

1 - How about a name? Even if it's just a "newsgroup"

name. It's hard to
tell all of the "anonymous"s apart.

2 - You didn't really say. Did you finally get it

working?

3 - You weren't a "bother." Just an annoyance. :-)

To help us help you in the futu

1 - Try to use the right group. This was more of a code

with a form problem.
The "microsoft.public.access.formscoding" group might

have been a better
group than "tablesdesign."

2 - Be straight with your experience and what you need.

It's OK to not know
things. It is not OK to hide it.

3 - Unless you've taken other database and programming

classes, having just
started using Access a week ago, I suspect that you're

not really ready to
be working with code.

4 - To be honest, this explains why you're breaking

basic design rules with
your "combined" field in the first place.

5 - My recommendation on the book was based on a bad

assumption. I
incorrectly assumed that because you were venturing into

code, that you had
a *very* solid understanding of databases and Access.

Based on only using
Access for a week, you should probably start with some

more basic books.
Take a look at "Database Design for Mere Mortals" by

Michael Hernandez and
"Microsoft Office Access 2003 Inside Out" by John

Viescas. After you get a
solid Access foundation, then start looking into code.

Good luck anonymous.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP,

MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion

picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


"anonymous" wrote

in message
...
Hello Sco and Tina,
Thank you both for all your help! I'm
really sorry I didn't understand what you were saying

the
first time around and ended up bothering the both of

you
so much. I just began using Access last week, and I

had't
learnt enough to utilize your advice. I apologize for

all
the trouble and I will get "Beginning Access Book" you
recommended. Once again, I really appreciate all the

help
you've given me and I'm sorry to have bothered you so
much!




.



 




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
Control source RJF General Discussion 4 August 4th, 2004 04:32 PM
NUMBERING the pages Bob New Users 7 June 14th, 2004 12:20 AM
Supress blank lines in DOCPROPERTY field Mary Formatting Long Documents 10 May 25th, 2004 07:27 PM
Need help with Control Source usage please... New Users 1 May 20th, 2004 09:59 PM
Missing field in data source AGI Mailmerge 1 May 19th, 2004 10:05 AM


All times are GMT +1. The time now is 11:47 AM.


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