Hall of Fame

1. capricorn12,136,854
2. DatabaseMX1,791,758
3. LSMCons...1,256,766
4. boag20001,036,189
5. peter57r799,346
6. matthews...688,896
7. rockiroads574,427
8. thenelson445,637
9. GRayL434,146
10. TextReport434,053
11. puppydog...400,608
12. tbsgadi367,274
13. JDettman322,461
14. cactus_d...281,926
15. mbizup243,682
16. jimpen211,515
17. harfang207,824
18. GrahamM...183,618
19. Helen_Fe...177,740
20. LPurvis165,663
21. angelIII146,835
22. hnasr137,021
23. kelvinsparks136,703
24. Tramtrak136,379
25. mildurait128,151

1. capricorn113,063,646
2. DatabaseMX6,134,612
3. rockiroads6,047,347
4. nico50385,705,281
5. LSMCons...5,307,939
6. peter57r5,070,812
7. LPurvis3,627,703
8. harfang3,312,263
9. shanesue...3,288,317
10. GRayL3,271,116
11. stevbe2,861,511
12. jimhorn2,807,017
13. boag20002,733,425
14. matthews...2,521,203
15. mbizup2,374,174
16. thenelson2,146,006
17. flavo2,117,383
18. jadedata1,968,277
19. jefftwilley1,887,172
20. puppydog...1,849,966
21. cactus_d...1,681,384
22. eghtebas1,534,843
23. JDettman1,468,976
24. jjafferr1,340,995
25. dannywar...1,329,637

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.4

have a save button that will take the current data in a form and add it to a table

Asked by meaculpa1113 in Microsoft Access Database

hi..

i have already tried the add record button, but that wont work for me, as everytime i click it, it blanks out the form and asks the user to enter in new data.

my question is in two parts..

first part is,

i want to have a form w/various fields in it. name, acc #, checking balance, saving balance. (i know that the design is terrible, but i cant come up w/a better example for now,, this is just an example)
so, i want my form to be dummy proof. wat was happenning is that when different ppl entered names, they entered all kinds of funny stuff which screwed up the database. so, i want to have a dropdown menu for the name. all good up till now, i noe how to create a drop down menu, and have done it successfully. now, each customer can have as many as 20 accounts. and even the account numbers are 15 digits long. so i also want to make the account numbers a dropdown menu based on wat was selected in the customer field.

somethin like..

select myTable.customerAccNum
FROM myTable
WHERE customerName = "wateverWasSelectedInTheCustomerComboBox"

how can i accomplish this?

the 2nd part of the question is..

when the first part is resolved, and all the data is bein nicely inputted into the form i want to have a save button. wat this save button does is that it takes all the data thas currently in the form and add its to myTable. I dont want to use access' Add Record button, because everytime i click on that, it empties the form and asks the user to enter new information. i want the user to enter the least amount of information, at least as far as the primary keys are concerned.

any ideas??

just so the experts know, i also have another question open which is worth 250 points (it essentially contains the same material as this), but no one has been able to give an appropriate answer so far.. so if someone can answer this, and post the same answer to that question, i'll award all 600 points to u...

help much appreciated.. have to sorta get this done by monday..

cheers

View the Solution FREE for 30 Days

20091021-EE-VQP-81

have a save button that will take the current data in a form and add it to a table

Asked by meaculpa1113 in Microsoft Access Database

About this solution