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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |