PDA

View Full Version : MS Access Help


entersanjay
April 9th, 2006, 03:39 PM
hey everybody.. can sumbody tell me how do i create a simple voting system in MS ACCESS where in i can vote for the candidats and then total it. nothing advanced just simple.wud really appreciate any help.thanks a lot.

oracle128
April 9th, 2006, 04:42 PM
Create a new Access project. Within it, create a new table. Insert the fields "Candidate" (text) and "Votes" (number).

How would you like to interact with the database? SQL/ODBC? ASP? A Form?

entersanjay
April 9th, 2006, 07:16 PM
a form... and preferrably something taht i can create using acess and no need for any code or anything.

PS:JUST FOR MY GENERAL KNOWLEDGE WHAT LANGUAGE IS USED AS THE CODE IN MS ACCESS AND WHR DO WE TYPE? IS IT SQL?

oracle128
April 9th, 2006, 07:33 PM
Access forms use macros, expression builders, or Visual Basic for Applications (which can contain SQL statements). You will need to add some code to the form for this otherwise it can't be done.

entersanjay
April 10th, 2006, 03:30 AM
according to u which is the most simple out of all of those?
and can u gimme a link as to whr i can learnt that code from or if its simple cud u just the type the code here and tell whr i shud put it.

smurfy
April 10th, 2006, 03:34 AM
And shall we do your English & Chemistry homework while we're at it?

entersanjay
April 10th, 2006, 11:55 AM
smurfy.. look at ur signature in ur post..
Remember that we are all here to learn so please post back and tell us if it's working (or not).
so im here to learn and if u think thats it doing homework.. SO BE IT.
now can anyone answear my question??

oracle128
April 10th, 2006, 01:52 PM
http://www.databasejournal.com/features/msaccess/article.php/3505836

You'll need to use this:
http://www.w3schools.com/sql/sql_update.asp