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
|
|||
|
|||
Is Access even the right idea?
I'm sure that with your vast expertise you could actually provide BMB some
help in trying to sort all this out then he/she could learn to solve the problem. Then the next time BMB is asked to solve a data problem he/she will have devloped the knowledge and experience needed, leading eventually to promotion and tenure and a life of luxury and fullfillment. A life, your offer, will deny him/her. I'm not sure you are aware of the terrible financial and psychological damage your offer to sell could cause BMB. I'm passionate about data. Microsoft Access is a great tool for the newbie to 'access' and display data. Therefore, I enjoy trying to share what little I have learned with others struggling to get a start with relational databases. I have also benefited greatly from some of the 'stupid questions' I have posted with this group and gotten valued advice. In short I think it better to "teach one to fish" rather than to "give one a fish". It is obvious that you want to sell fish, not teach fishing! I recommend you set up your 'fish monger shop' in an appropriate dark alleyway rather than in the middle of the school grounds. (: Ed Warren "PC Datasheet" wrote in message nk.net... If the complication is becoming too frustrating, please consider that I can build the database for you for a very reasonable fee. If you want help, contact me at my email address below. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! "BMB" wrote in message ... Thank you for the suggestions. They have helped. I think that I have all the tables constructed (maybe), but the assimilation part is proving more complicated than I had thought. As I establish relationships between the tables, I seem to get less functionality and information retention than before. The following is my table structure. Further assistance would be greatly appreciated. Table structure----- ConcentrationLookup ConcentrationID (key) - autonumber ConcentrationTitle - text CourseLookup CourseID (key) - autonumber CourseNumber - text CourseToConcentration ConcentrationID - autonumber CourseID - text EmailLookup EmailTypeID (key) - autonumber EmailType - text HomeSchoolLookup HomeSchoolID (key) - autonumber HomeSchool - text PhoneNumbers PhoneID (key) - autonumber StudentID - text PhoneTypeID - text PhoneNumber - text PhoneTypeLookup PhoneTypeID (key) - autonumber PhoneType - text ProgramData ProgramID (key) - text StudentID - text DateAdmitted - date/time DateUpdated - date/time ConcentrationID - text StatusID - text Comment - memo SemesterLookup SemesterID (key) - autonumber SemesterStartDate - date/time Semester - text StatusLookup StatusID (key) - text StatusType - text StudentDemographics StudentID (key) - text FirstName - text MiddleInitial - text LastName - text ProgramID - text ConcentrationTitle - text HomeSchool - text Address1 - text Address2 - text City - text State - text ZipCode - text PhoneType - number PhoneNumber - text EmailType - number EmailAddress - memo Advisor - text DateUpdated - date/time StudentEmail EmailID (key) - text StudentID - text EmailTypeID - text EmailAddress - memo CourseStatusLookup CourseStatusID - autonumber CourseStatus - text The following information may be necessary: ProgramID is a four-digit number that we assign to students as they apply for our program as a method of internal tracking; all courses are available each semester; there are 7 course requirements that are common to all 5 concentrations. I would like to create a tabbed form that contains one tab for basic student information and subsequent tabs that contain scheduling data for the requisite courses based upon the student's chosen concentration (i.e., one tab for each concentration, but only the appropriate tab accessible based on the "Concentration" selection on tab 1). If you're still even reading this, thanks. |
#12
|
|||
|
|||
Is Access even the right idea?
Thanks Warren.
It is nice to see that others understand the spirit of free support. John... Visio MVP "Ed Warren" wrote in message ... I'm sure that with your vast expertise you could actually provide BMB some help in trying to sort all this out then he/she could learn to solve the problem. Then the next time BMB is asked to solve a data problem he/she will have devloped the knowledge and experience needed, leading eventually to promotion and tenure and a life of luxury and fullfillment. A life, your offer, will deny him/her. I'm not sure you are aware of the terrible financial and psychological damage your offer to sell could cause BMB. I'm passionate about data. Microsoft Access is a great tool for the newbie to 'access' and display data. Therefore, I enjoy trying to share what little I have learned with others struggling to get a start with relational databases. I have also benefited greatly from some of the 'stupid questions' I have posted with this group and gotten valued advice. In short I think it better to "teach one to fish" rather than to "give one a fish". It is obvious that you want to sell fish, not teach fishing! I recommend you set up your 'fish monger shop' in an appropriate dark alleyway rather than in the middle of the school grounds. (: Ed Warren "PC Datasheet" wrote in message nk.net... If the complication is becoming too frustrating, please consider that I can build the database for you for a very reasonable fee. If you want help, contact me at my email address below. |
#13
|
|||
|
|||
Is Access even the right idea?
Ed,
If you go back over time you will see that I provided advice and support at a ratio of ten to one or more to responses where I asked the poster to contact me if he needed help. I judiciously chose where to post my offer to help to posters where it was highly unlikely that they would get the solution they needed from the newsgroup. Over the years over 1050 Access users from the newsgroups have contacted me asking for help and willing to pay a fee for it. Don't get me wrong, I always encourage them to seek help from the newsgroups telling them it is free. Arno R and his dimwit sidekick John Marshall want to steal away this option for help from anyone who comes to the newsgroup looking for help. Go back over time and see how many responses of help were posted by Arno R and his dimwit friend. The dimwit friend isn't even an Access MVP! Steve PC Datasheet "Ed Warren" wrote in message ... I'm sure that with your vast expertise you could actually provide BMB some help in trying to sort all this out then he/she could learn to solve the problem. Then the next time BMB is asked to solve a data problem he/she will have devloped the knowledge and experience needed, leading eventually to promotion and tenure and a life of luxury and fullfillment. A life, your offer, will deny him/her. I'm not sure you are aware of the terrible financial and psychological damage your offer to sell could cause BMB. I'm passionate about data. Microsoft Access is a great tool for the newbie to 'access' and display data. Therefore, I enjoy trying to share what little I have learned with others struggling to get a start with relational databases. I have also benefited greatly from some of the 'stupid questions' I have posted with this group and gotten valued advice. In short I think it better to "teach one to fish" rather than to "give one a fish". It is obvious that you want to sell fish, not teach fishing! I recommend you set up your 'fish monger shop' in an appropriate dark alleyway rather than in the middle of the school grounds. (: Ed Warren "PC Datasheet" wrote in message nk.net... If the complication is becoming too frustrating, please consider that I can build the database for you for a very reasonable fee. If you want help, contact me at my email address below. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! "BMB" wrote in message ... Thank you for the suggestions. They have helped. I think that I have all the tables constructed (maybe), but the assimilation part is proving more complicated than I had thought. As I establish relationships between the tables, I seem to get less functionality and information retention than before. The following is my table structure. Further assistance would be greatly appreciated. Table structure----- ConcentrationLookup ConcentrationID (key) - autonumber ConcentrationTitle - text CourseLookup CourseID (key) - autonumber CourseNumber - text CourseToConcentration ConcentrationID - autonumber CourseID - text EmailLookup EmailTypeID (key) - autonumber EmailType - text HomeSchoolLookup HomeSchoolID (key) - autonumber HomeSchool - text PhoneNumbers PhoneID (key) - autonumber StudentID - text PhoneTypeID - text PhoneNumber - text PhoneTypeLookup PhoneTypeID (key) - autonumber PhoneType - text ProgramData ProgramID (key) - text StudentID - text DateAdmitted - date/time DateUpdated - date/time ConcentrationID - text StatusID - text Comment - memo SemesterLookup SemesterID (key) - autonumber SemesterStartDate - date/time Semester - text StatusLookup StatusID (key) - text StatusType - text StudentDemographics StudentID (key) - text FirstName - text MiddleInitial - text LastName - text ProgramID - text ConcentrationTitle - text HomeSchool - text Address1 - text Address2 - text City - text State - text ZipCode - text PhoneType - number PhoneNumber - text EmailType - number EmailAddress - memo Advisor - text DateUpdated - date/time StudentEmail EmailID (key) - text StudentID - text EmailTypeID - text EmailAddress - memo CourseStatusLookup CourseStatusID - autonumber CourseStatus - text The following information may be necessary: ProgramID is a four-digit number that we assign to students as they apply for our program as a method of internal tracking; all courses are available each semester; there are 7 course requirements that are common to all 5 concentrations. I would like to create a tabbed form that contains one tab for basic student information and subsequent tabs that contain scheduling data for the requisite courses based upon the student's chosen concentration (i.e., one tab for each concentration, but only the appropriate tab accessible based on the "Concentration" selection on tab 1). If you're still even reading this, thanks. |
#14
|
|||
|
|||
Is Access even the right idea?
Oh I'm so hurt. Name calling from a failed plumber, just won't do it. So
I'll just add this to the long list of items you will never apoligize for. It has nothing to do with 10 to 1, 100 to 1, or a million to 1. You still post messages soliciting work. The issue is the 1 not the 10, 100 or million. These newsgroups were set up my Microsoft to allow free peer to peer help, solicitions was not one of the intended "options for help". So by posting a few answers, some of which you have plagerized, absolves you from following the spirit of the newsgroups? The number of responses I or Arno make to these newsgroups is immaterial to the issue. It's like saying that a pedestrian can not comment on a traffic accident because he was not driving. So when will your following of 1050, jump to your defence? John... Visio MVP "PC Datasheet" wrote in message nk.net... Ed, If you go back over time you will see that I provided advice and support at a ratio of ten to one or more to responses where I asked the poster to contact me if he needed help. I judiciously chose where to post my offer to help to posters where it was highly unlikely that they would get the solution they needed from the newsgroup. Over the years over 1050 Access users from the newsgroups have contacted me asking for help and willing to pay a fee for it. Don't get me wrong, I always encourage them to seek help from the newsgroups telling them it is free. Arno R and his dimwit sidekick John Marshall want to steal away this option for help from anyone who comes to the newsgroup looking for help. Go back over time and see how many responses of help were posted by Arno R and his dimwit friend. The dimwit friend isn't even an Access MVP! Steve PC Datasheet |
#15
|
|||
|
|||
Is Access even the right idea?
Your job hunting posts are annoying in and of themselves, no matter what
Arno and/or John Marshall think and/or say! As I said I'm a data freak, math major, and statistician, I took up your challenge. For the most recent posts under your name: Out of 41 posts: You were asking for help 12 You were providing Help 4 You were advertising and or defending advertising 25 -- 9.76% help Maybe in Washington DC this could be spun as a 10:1 Providing help record. -----by the way I will not respond to any further posts on this subject on this thread-------I'm going back to and find someone to actually help !! Ed Warren. "PC Datasheet" wrote in message nk.net... Ed, If you go back over time you will see that I provided advice and support at a ratio of ten to one or more to responses where I asked the poster to contact me if he needed help. I judiciously chose where to post my offer to help to posters where it was highly unlikely that they would get the solution they needed from the newsgroup. Over the years over 1050 Access users from the newsgroups have contacted me asking for help and willing to pay a fee for it. Don't get me wrong, I always encourage them to seek help from the newsgroups telling them it is free. Arno R and his dimwit sidekick John Marshall want to steal away this option for help from anyone who comes to the newsgroup looking for help. Go back over time and see how many responses of help were posted by Arno R and his dimwit friend. The dimwit friend isn't even an Access MVP! Steve PC Datasheet "Ed Warren" wrote in message ... I'm sure that with your vast expertise you could actually provide BMB some help in trying to sort all this out then he/she could learn to solve the problem. Then the next time BMB is asked to solve a data problem he/she will have devloped the knowledge and experience needed, leading eventually to promotion and tenure and a life of luxury and fullfillment. A life, your offer, will deny him/her. I'm not sure you are aware of the terrible financial and psychological damage your offer to sell could cause BMB. I'm passionate about data. Microsoft Access is a great tool for the newbie to 'access' and display data. Therefore, I enjoy trying to share what little I have learned with others struggling to get a start with relational databases. I have also benefited greatly from some of the 'stupid questions' I have posted with this group and gotten valued advice. In short I think it better to "teach one to fish" rather than to "give one a fish". It is obvious that you want to sell fish, not teach fishing! I recommend you set up your 'fish monger shop' in an appropriate dark alleyway rather than in the middle of the school grounds. (: Ed Warren "PC Datasheet" wrote in message nk.net... If the complication is becoming too frustrating, please consider that I can build the database for you for a very reasonable fee. If you want help, contact me at my email address below. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! "BMB" wrote in message ... Thank you for the suggestions. They have helped. I think that I have all the tables constructed (maybe), but the assimilation part is proving more complicated than I had thought. As I establish relationships between the tables, I seem to get less functionality and information retention than before. The following is my table structure. Further assistance would be greatly appreciated. Table structure----- ConcentrationLookup ConcentrationID (key) - autonumber ConcentrationTitle - text CourseLookup CourseID (key) - autonumber CourseNumber - text CourseToConcentration ConcentrationID - autonumber CourseID - text EmailLookup EmailTypeID (key) - autonumber EmailType - text HomeSchoolLookup HomeSchoolID (key) - autonumber HomeSchool - text PhoneNumbers PhoneID (key) - autonumber StudentID - text PhoneTypeID - text PhoneNumber - text PhoneTypeLookup PhoneTypeID (key) - autonumber PhoneType - text ProgramData ProgramID (key) - text StudentID - text DateAdmitted - date/time DateUpdated - date/time ConcentrationID - text StatusID - text Comment - memo SemesterLookup SemesterID (key) - autonumber SemesterStartDate - date/time Semester - text StatusLookup StatusID (key) - text StatusType - text StudentDemographics StudentID (key) - text FirstName - text MiddleInitial - text LastName - text ProgramID - text ConcentrationTitle - text HomeSchool - text Address1 - text Address2 - text City - text State - text ZipCode - text PhoneType - number PhoneNumber - text EmailType - number EmailAddress - memo Advisor - text DateUpdated - date/time StudentEmail EmailID (key) - text StudentID - text EmailTypeID - text EmailAddress - memo CourseStatusLookup CourseStatusID - autonumber CourseStatus - text The following information may be necessary: ProgramID is a four-digit number that we assign to students as they apply for our program as a method of internal tracking; all courses are available each semester; there are 7 course requirements that are common to all 5 concentrations. I would like to create a tabbed form that contains one tab for basic student information and subsequent tabs that contain scheduling data for the requisite courses based upon the student's chosen concentration (i.e., one tab for each concentration, but only the appropriate tab accessible based on the "Concentration" selection on tab 1). If you're still even reading this, thanks. |
#16
|
|||
|
|||
Is Access even the right idea?
No Access is not right for you. From what I read you are going to use a lot
of data. Access can only do 10,000 transactions at a time. So if you have multiple users updating and deleting and whatever, Access will crash if 10,000 users access. Oracle can handle the whole world's population if they decide to access it at the same time. Value -- Access - $100 Oracle - $100,000 for your school Oracle is totally web, so no need for software on your computer. And that means ease. I'm against ACCESS because I've seen it in action with large organization like yours, and "Pane Freezing" is common. Microsoft is aware of this, and that's why Mr. Ellison from Oracle is #2 next to Bill Gates "tina" wrote: well, i'd say Access is the place to house, organize, update, and analyze the data - but it doesn't sound like a trivial undertaking. how comfortable are you with the Access software? and how familiar are you with the concepts of data modeling/normalization/table relationships? if your answer to the second question is "not very" or "not at all", then i recommend you start there. this is definitely not a project that you want to throw together willy-nilly, especially since you want to use the data to project future business needs. to learn relational data modeling methodology and the principles of normalization, an excellent text is Database Design for Mere Mortals by Michael Hernandez. there are also a number of links to helpful material at http://home.bendbroadband.com/conrad...resources.html beginning with the Database Design 101 and Starting Out links. hth "BMB" wrote in message ... I have recently had a large amount of data dumped on me and was asked to organize it. If the data were finite, it wouldn't be a problem; but it is subject to weekly updates with new records being added. This might take some explaining. . . I work in a university program office and am trying to figure out the best way to keep up with which students are in which degree concentrations, each of which has its own set of requisite courses. For example, there are 5 different degree concentrations with the program; one has only 6 required courses, one has 16. I have projected dates that students anticipate taking the courses that are required for them (e.g., "Spring, 2007"). Keeping up with the basic data (name, address, phone, program, etc.) is fairly simple. I have it set up in Access and Excel. But what I want is some kind of smart form that will know which classes are required of which students based on their concentrations and can create detailed reports showing how many students are projected to take each class during upcoming semesters. Does this make sense to anyone? I'm looking at it and still not sure what to do. Any help with deciding which application (and how) to use would be most appreciated. |
#17
|
|||
|
|||
Is Access even the right idea?
What universe are you living in? The poor soul is currently managing the
data with excel, and does weekly updates. That is a far far cry from needing 10,000 concurrent transactions. Matter of fact I would be surprised it their entire database was over a few 100 records in length. They need a bucket, not a freight train ; Ed Warren "Ian" wrote in message ... No Access is not right for you. From what I read you are going to use a lot of data. Access can only do 10,000 transactions at a time. So if you have multiple users updating and deleting and whatever, Access will crash if 10,000 users access. Oracle can handle the whole world's population if they decide to access it at the same time. Value -- Access - $100 Oracle - $100,000 for your school Oracle is totally web, so no need for software on your computer. And that means ease. I'm against ACCESS because I've seen it in action with large organization like yours, and "Pane Freezing" is common. Microsoft is aware of this, and that's why Mr. Ellison from Oracle is #2 next to Bill Gates "tina" wrote: well, i'd say Access is the place to house, organize, update, and analyze the data - but it doesn't sound like a trivial undertaking. how comfortable are you with the Access software? and how familiar are you with the concepts of data modeling/normalization/table relationships? if your answer to the second question is "not very" or "not at all", then i recommend you start there. this is definitely not a project that you want to throw together willy-nilly, especially since you want to use the data to project future business needs. to learn relational data modeling methodology and the principles of normalization, an excellent text is Database Design for Mere Mortals by Michael Hernandez. there are also a number of links to helpful material at http://home.bendbroadband.com/conrad...resources.html beginning with the Database Design 101 and Starting Out links. hth "BMB" wrote in message ... I have recently had a large amount of data dumped on me and was asked to organize it. If the data were finite, it wouldn't be a problem; but it is subject to weekly updates with new records being added. This might take some explaining. . . I work in a university program office and am trying to figure out the best way to keep up with which students are in which degree concentrations, each of which has its own set of requisite courses. For example, there are 5 different degree concentrations with the program; one has only 6 required courses, one has 16. I have projected dates that students anticipate taking the courses that are required for them (e.g., "Spring, 2007"). Keeping up with the basic data (name, address, phone, program, etc.) is fairly simple. I have it set up in Access and Excel. But what I want is some kind of smart form that will know which classes are required of which students based on their concentrations and can create detailed reports showing how many students are projected to take each class during upcoming semesters. Does this make sense to anyone? I'm looking at it and still not sure what to do. Any help with deciding which application (and how) to use would be most appreciated. |
#18
|
|||
|
|||
Is Access even the right idea?
Good Morning, Gentlemen,
OK, so I'm still plugging away at this database, and while I'm a big fan of the 1st Amendment, could you please find somewhere else to argue? Not that I don't thoroughly enjoy the disappointment of logging on after receiving an e-mail that someone has posted a reply and finding out that it's from some schmuck who has nothing better to do that plug his own business. . . Steve, if I wanted to (or even could. . .) pay someone for this, wouldn't it make more sense for me to explore that option up-front instead of wasting my time trying to learn how to do this for myself? I haven't written to you eagerly expressing my rapacious desire for your oh-so-unselfish services, so please find someone else's post to fill with nonsensical garbage. That will be all. "PC Datasheet" wrote: Ed, If you go back over time you will see that I provided advice and support at a ratio of ten to one or more to responses where I asked the poster to contact me if he needed help. I judiciously chose where to post my offer to help to posters where it was highly unlikely that they would get the solution they needed from the newsgroup. Over the years over 1050 Access users from the newsgroups have contacted me asking for help and willing to pay a fee for it. Don't get me wrong, I always encourage them to seek help from the newsgroups telling them it is free. Arno R and his dimwit sidekick John Marshall want to steal away this option for help from anyone who comes to the newsgroup looking for help. Go back over time and see how many responses of help were posted by Arno R and his dimwit friend. The dimwit friend isn't even an Access MVP! Steve PC Datasheet "Ed Warren" wrote in message ... I'm sure that with your vast expertise you could actually provide BMB some help in trying to sort all this out then he/she could learn to solve the problem. Then the next time BMB is asked to solve a data problem he/she will have devloped the knowledge and experience needed, leading eventually to promotion and tenure and a life of luxury and fullfillment. A life, your offer, will deny him/her. I'm not sure you are aware of the terrible financial and psychological damage your offer to sell could cause BMB. I'm passionate about data. Microsoft Access is a great tool for the newbie to 'access' and display data. Therefore, I enjoy trying to share what little I have learned with others struggling to get a start with relational databases. I have also benefited greatly from some of the 'stupid questions' I have posted with this group and gotten valued advice. In short I think it better to "teach one to fish" rather than to "give one a fish". It is obvious that you want to sell fish, not teach fishing! I recommend you set up your 'fish monger shop' in an appropriate dark alleyway rather than in the middle of the school grounds. (: Ed Warren "PC Datasheet" wrote in message nk.net... If the complication is becoming too frustrating, please consider that I can build the database for you for a very reasonable fee. If you want help, contact me at my email address below. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! "BMB" wrote in message ... Thank you for the suggestions. They have helped. I think that I have all the tables constructed (maybe), but the assimilation part is proving more complicated than I had thought. As I establish relationships between the tables, I seem to get less functionality and information retention than before. The following is my table structure. Further assistance would be greatly appreciated. Table structure----- ConcentrationLookup ConcentrationID (key) - autonumber ConcentrationTitle - text CourseLookup CourseID (key) - autonumber CourseNumber - text CourseToConcentration ConcentrationID - autonumber CourseID - text EmailLookup EmailTypeID (key) - autonumber EmailType - text HomeSchoolLookup HomeSchoolID (key) - autonumber HomeSchool - text PhoneNumbers PhoneID (key) - autonumber StudentID - text PhoneTypeID - text PhoneNumber - text PhoneTypeLookup PhoneTypeID (key) - autonumber PhoneType - text ProgramData ProgramID (key) - text StudentID - text DateAdmitted - date/time DateUpdated - date/time ConcentrationID - text StatusID - text Comment - memo SemesterLookup SemesterID (key) - autonumber SemesterStartDate - date/time Semester - text StatusLookup StatusID (key) - text StatusType - text StudentDemographics StudentID (key) - text FirstName - text MiddleInitial - text LastName - text ProgramID - text ConcentrationTitle - text HomeSchool - text Address1 - text Address2 - text City - text State - text ZipCode - text PhoneType - number PhoneNumber - text EmailType - number EmailAddress - memo Advisor - text DateUpdated - date/time StudentEmail EmailID (key) - text StudentID - text EmailTypeID - text EmailAddress - memo CourseStatusLookup CourseStatusID - autonumber CourseStatus - text The following information may be necessary: ProgramID is a four-digit number that we assign to students as they apply for our program as a method of internal tracking; all courses are available each semester; there are 7 course requirements that are common to all 5 concentrations. I would like to create a tabbed form that contains one tab for basic student information and subsequent tabs that contain scheduling data for the requisite courses based upon the student's chosen concentration (i.e., one tab for each concentration, but only the appropriate tab accessible based on the "Concentration" selection on tab 1). If you're still even reading this, thanks. |
#19
|
|||
|
|||
Is Access even the right idea?
First of all, I'd like to thank everyone who has helped with this project so
far. You have all been a great help (except for Steve, anyway). Here's my next question - which, of course, proves how much of a novice I am with Access: when creating a form, is there a way that the answer in one field (chosen from a drop-down list) can lock other tabbed pages and require that the user input data on others? For example, if I answer the question concerning student concentration, can the form itself mandate that the pertinent data required by that concentration be input while simultaneously disallowing input of other data for different concentrations (perhaps by locking out the tabbed pages on which that data would be input if relevant)? After reading up on database issues on sites that have been recommended here, I've tried playing with the Master and Child fields, but nothing that I've tried works. If I need to provide more information, just let me know. Again, thank you all for the help. |
#20
|
|||
|
|||
Is Access even the right idea?
Yes
You will need to: a. Spend some amount of time defining exactly the behaviors you want to implement in your software. b. Write Visual Basic Code to implement your vision. You will start with one of the events in your combobox, most likely on_exit then in English "When I exit the combobox, if it is set to concentration number 1 then I want show tabs 1,5,7 and not allow the user to exit until all of these are filled in." Ed Warren. "BMB" wrote in message news First of all, I'd like to thank everyone who has helped with this project so far. You have all been a great help (except for Steve, anyway). Here's my next question - which, of course, proves how much of a novice I am with Access: when creating a form, is there a way that the answer in one field (chosen from a drop-down list) can lock other tabbed pages and require that the user input data on others? For example, if I answer the question concerning student concentration, can the form itself mandate that the pertinent data required by that concentration be input while simultaneously disallowing input of other data for different concentrations (perhaps by locking out the tabbed pages on which that data would be input if relevant)? After reading up on database issues on sites that have been recommended here, I've tried playing with the Master and Child fields, but nothing that I've tried works. If I need to provide more information, just let me know. Again, thank you all for the help. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Hiding Access | Mark A. Sam | Using Forms | 4 | December 1st, 2004 09:09 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
MICROSOFT INVESTING HEAVILY IN ACCESS | Mike Painter | General Discussion | 39 | October 15th, 2004 03:56 PM |