Dance Classes
in [Tables]
|
Prev: doctors office database
Next: ORGANIZATIONAL CHART
From: Nomy on 5 Mar 2010 16:05 Bruce, You've been so kind with your interest, I wanted to let you know what I've done so far since you said you would check the threads for this post. I took your advice and created one table (tblPayments) to hold all payments and/or purchases. I added a field called NonFamName so I can enter a non family purchase name if I need to. I also created two different pmt forms based on the pmt table. One stand alone continuous form as you suggested and one with a subform to post class pmts. This seems to work good with no problems yet. All my forms are very simple at this time. The payment table fields are as in previous posts except I added a yes/no field called MkDep as a criteria selection field to append to the deposit detail table. I created another form to list the pmts that are marked "yes" in the in the MkDep yes/no field. This form lists only pmts that have not yet been deposited. The fields in the deposit table are depositID and DepDate. I created an append query to append the pmts to the dep detail after I entered a new record for the deposit date (in the Deposit table as Steve suggested) and a query to reset the yes/no field to "no" after they have been successfully appended. The query appends the pmts to the depdetail but unless I want to use only a deposit detail table, this method is seriously flawed as the query won't enter the DepositID (linking field to depDetail info) into the dep detail table. I was hoping I could do that with a query as I've never used the AddNew function and I'm researching this on the internet. There doesn't seem to be much in Access help but I think I will need a procedure to pass the data to an AddNew function. I really want to learn to do this myself and was wondering if you have any suggestions as to websites where I could find information to learn more about this. Thank you again for your help and patience. I just wanted to let you know where I am in this and how much your advice has helped. Nancy "BruceM via AccessMonster.com" <u54429(a)uwe> wrote in message news:a45f8c1150f26(a)uwe... > This is where I learned a lot of what I know. Just returning the favor. > I > will continue to monitor this thread. Good luck. > > Nomy wrote: >>Bruce, >>Thank you so much for your help. I will post back in a few days. You are >>so nice to do this for people. >>Nancy >> >>> The Family table is one of the top-level tables. Below that is the >>> ClassPayments table, followed by PaymentDetails to show how the payment >>[quoted text clipped - 33 lines] >>>>>>>>>>>>>>> Thank you in advanch so much. >>>>>>>>>>>>>>> Nancy > > -- > Message posted via http://www.accessmonster.com >
From: BruceM via AccessMonster.com on 15 Mar 2010 07:36
I have been away for a week, and don't have much time to look at your question in detail, but from what I can tell you are mostly looking for tutorials, etc. anyhow. I will look at the specific issue you mentioned when I get a chance, but meanwhile here are some links: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials Nomy wrote: >Bruce, >You've been so kind with your interest, I wanted to let you know what I've >done so far since you said you would check the threads for this post. I >took your advice and created one table (tblPayments) to hold >all payments and/or >purchases. I added a field called NonFamName so I can enter a non family >purchase name if I need to. I also created two different pmt forms based on >the pmt table. One stand alone continuous form as you suggested and one >with a subform to post >class pmts. This seems to work good with no problems yet. All my forms are >very simple at this time. > >The payment table fields are as in previous posts except I added a yes/no >field called MkDep as a criteria selection field to append to the deposit >detail table. > >I created another form to list the pmts that are marked "yes" in the in the >MkDep yes/no field. This form lists only pmts that have not yet been >deposited. The fields in the deposit table are depositID and >DepDate. I created an append query to append the pmts >to the dep detail after I entered a new record for the deposit date (in the >Deposit >table as Steve suggested) and a query to reset the yes/no field to "no" >after they have been successfully appended. > >The query appends the pmts to the depdetail but unless I want to use only a >deposit detail >table, this method is seriously flawed as the query won't enter the >DepositID (linking field to depDetail info) >into the dep detail table. I was hoping I could do that with a query as >I've never used the AddNew function and I'm researching this on the >internet. There doesn't seem to be much in Access help but I think I will >need a >procedure to pass the data to an AddNew function. > >I really want to learn to do this myself and was wondering if you have any >suggestions as to websites where I could find information >to learn more about this. > >Thank you again for your help and patience. I just wanted to let you know >where I am in this and how much your advice has helped. >Nancy > >> This is where I learned a lot of what I know. Just returning the favor. >> I >[quoted text clipped - 10 lines] >>>>>>>>>>>>>>>> Thank you in advanch so much. >>>>>>>>>>>>>>>> Nancy -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201003/1 |