A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dance Classes



 
 
Thread Tools Display Modes
  #21  
Old March 5th, 2010, 10:05 PM posted to microsoft.public.access.tablesdbdesign
Nomy
external usenet poster
 
Posts: 11
Default Dance Classes

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@uwe wrote in message
news:a45f8c1150f26@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








  #22  
Old March 15th, 2010, 12:36 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Dance Classes

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/acc...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/For...esign/201003/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.