View Single Post
  #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!