Beginner with ComboBox
in [Getting Started]
|
From: Jeff Boyce on 23 Apr 2010 15:20 Depending on who you're trained by, you will probably get (only) intense focus on #2, and some focus on #1. I'll be curious (here) to hear about it afterwards... Good luck! Jeff "Mort" <Mort(a)discussions.microsoft.com> wrote in message news:427D4C99-0760-4D71-ACE7-E5C20B9CA55F(a)microsoft.com... > Thank you. I can attest to that fact and am proceding very cautiously. > > The first was rather simple, four tables and I was given enough time so > that > I could understand what was being written about on the 1NF,2NF, and 3NF. > Customers, Products, Orders, and Shipments tables (no partial shipments so > Primary Keys and Joins were not to hard to figure out). > This one is much more difficult - I am being approached to do it after my > initial success. I have registered for Access training at a Microsoft > certified training company for a three day instructor led class, but it > is 7 > weeks into the future. > > "Jeff Boyce" wrote: > >> Mort >> >> I've always heard that it is your SECOND application which is the most >> dangerous ... after you learn enough to finish the first ... >> >> Good luck! >> >> 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. >> >> "Mort" <Mort(a)discussions.microsoft.com> wrote in message >> news:D968D908-5FF3-49FD-BB8A-E675AA9DD40C(a)microsoft.com... >> >I am designing my second database, Access 2007. >> > I need a drop-down list on a form which enters data into the table >> > tblStats. >> > I want a combo box and will type in three values, >> > Complete;Incomplete;Pending. When one of these values is selected for >> > the >> > active record, that value should go to the field Status in the table >> > tblStats. >> > I can not figure out how to accomplish this. Please help >> > >> > Mortimer >> >> >> . >>
From: Mort on 23 Apr 2010 16:04 I will post back on this thread after the training is concluded, late June. "Jeff Boyce" wrote: > Depending on who you're trained by, you will probably get (only) intense > focus on #2, and some focus on #1. I'll be curious (here) to hear about it > afterwards... > > Good luck! > > Jeff > > "Mort" <Mort(a)discussions.microsoft.com> wrote in message > news:427D4C99-0760-4D71-ACE7-E5C20B9CA55F(a)microsoft.com... > > Thank you. I can attest to that fact and am proceding very cautiously. > > > > The first was rather simple, four tables and I was given enough time so > > that > > I could understand what was being written about on the 1NF,2NF, and 3NF. > > Customers, Products, Orders, and Shipments tables (no partial shipments so > > Primary Keys and Joins were not to hard to figure out). > > This one is much more difficult - I am being approached to do it after my > > initial success. I have registered for Access training at a Microsoft > > certified training company for a three day instructor led class, but it > > is 7 > > weeks into the future. > > > > "Jeff Boyce" wrote: > > > >> Mort > >> > >> I've always heard that it is your SECOND application which is the most > >> dangerous ... after you learn enough to finish the first ... > >> > >> Good luck! > >> > >> 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. > >> > >> "Mort" <Mort(a)discussions.microsoft.com> wrote in message > >> news:D968D908-5FF3-49FD-BB8A-E675AA9DD40C(a)microsoft.com... > >> >I am designing my second database, Access 2007. > >> > I need a drop-down list on a form which enters data into the table > >> > tblStats. > >> > I want a combo box and will type in three values, > >> > Complete;Incomplete;Pending. When one of these values is selected for > >> > the > >> > active record, that value should go to the field Status in the table > >> > tblStats. > >> > I can not figure out how to accomplish this. Please help > >> > > >> > Mortimer > >> > >> > >> . > >> > > > . >
From: Jeff Boyce on 23 Apr 2010 18:22 My apologies, I had also posted a response today that listed 4 learning curves most folks need to surmount to build Access apps that get used. My previous comment would have made more sense if I had listed the 4 curves! 1) relational database design - Access looks for data organized this way 2) Access tricks -- classes tend to focus here, not so much on #1 3) Graphical User Interface design -- if it isn't easy to understand and use, folks won't 4) Application development -- hey! would you try to build a house without knowing how the process goes?! Good luck! 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. "Mort" <Mort(a)discussions.microsoft.com> wrote in message news:AC9DD4A4-0F6B-4D5A-95B3-5D5A8A29AB28(a)microsoft.com... >I will post back on this thread after the training is concluded, late June. > > "Jeff Boyce" wrote: > >> Depending on who you're trained by, you will probably get (only) intense >> focus on #2, and some focus on #1. I'll be curious (here) to hear about >> it >> afterwards... >> >> Good luck! >> >> Jeff >> >> "Mort" <Mort(a)discussions.microsoft.com> wrote in message >> news:427D4C99-0760-4D71-ACE7-E5C20B9CA55F(a)microsoft.com... >> > Thank you. I can attest to that fact and am proceding very cautiously. >> > >> > The first was rather simple, four tables and I was given enough time so >> > that >> > I could understand what was being written about on the 1NF,2NF, and >> > 3NF. >> > Customers, Products, Orders, and Shipments tables (no partial shipments >> > so >> > Primary Keys and Joins were not to hard to figure out). >> > This one is much more difficult - I am being approached to do it after >> > my >> > initial success. I have registered for Access training at a Microsoft >> > certified training company for a three day instructor led class, but >> > it >> > is 7 >> > weeks into the future. >> > >> > "Jeff Boyce" wrote: >> > >> >> Mort >> >> >> >> I've always heard that it is your SECOND application which is the most >> >> dangerous ... after you learn enough to finish the first ... >> >> >> >> Good luck! >> >> >> >> 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. >> >> >> >> "Mort" <Mort(a)discussions.microsoft.com> wrote in message >> >> news:D968D908-5FF3-49FD-BB8A-E675AA9DD40C(a)microsoft.com... >> >> >I am designing my second database, Access 2007. >> >> > I need a drop-down list on a form which enters data into the table >> >> > tblStats. >> >> > I want a combo box and will type in three values, >> >> > Complete;Incomplete;Pending. When one of these values is selected >> >> > for >> >> > the >> >> > active record, that value should go to the field Status in the table >> >> > tblStats. >> >> > I can not figure out how to accomplish this. Please help >> >> > >> >> > Mortimer >> >> >> >> >> >> . >> >> >> >> >> . >>
First
|
Prev
|
Pages: 1 2 Prev: Linking forms field and table field . Next: subforms and relationships getting #Name? error |