Programming Forums > Application Development > Visual Basic

princess · Apr 11th, 2005, 1:28 PM

hiya i desperatly need help wid my AS computing coursework (terry;s turkeys). i need to use visual basics (which i have neva used b4

!!!) to link up my forms wid my tables. plz could sum1 send me VB codes so i can do this, A.S.A.P, cz it needs to b dun by dis thur!!! thnx

Rory · Apr 11th, 2005, 2:07 PM

If you're using access, the in-database forms "link up" to the data by themselves.

If you want to link your database to an external VB application, then the data control does a good job through Jet or ODBC (you can pull the data by setting the DataSource property to the appropriate settings) - you can even get a wizard to do this bit!

It's when you want to do something more complicated involving the interpretation or validation of data that you need VB (or VBA in office) code - if you could be more specific that'd be helpful.

Good luck with that, though I thought the exams weren't for some time.

princess · Apr 12th, 2005, 2:40 AM

yeh my exam is at da end of may/ begginning of june, but i have to hand in a 1st draft of terrys turkeys this thur! my teacher is an idiot...dsnt seem2 undastand much himself!

basically im using access 2000. ive made all my tables and all my forms but the problem is wen i put customer details into the forms, i have a command button that says 'confirm'. when i click it i want my data to appear in the table (thats what i mean by linking up my tables and my forms) and im using (or trying2 use!!) visual basics by writing in codes to make this happen but its all a big fat mess!!

the only useful thing my teacher said wz 2 use visual basics and thats it!!

plz sum1 out there help me!!!

Rory · Apr 12th, 2005, 4:09 AM

Right, the simplest way to interact with the form in VBA is to manipulate the DoCmd object exposed by the navigation controls, required constants can be found through the object inspector or help. To actually add code you'll have to tie it to a VB event handler (right click the object -> build event).
For instance the following code will save the current record:

(Toggle Plain Text)

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord

So to go to the next record would be:

(Toggle Plain Text)

DoCmd.GoToRecord , , acNext

and so on. Hope this is helpful.

Infinite Recursion · Apr 12th, 2005, 8:14 AM

This assignment sounds awfully familiar... is this guy in your class?

http://www.programmingforums.org/for...ead.php?t=3235

Rory · Apr 12th, 2005, 5:17 PM

Nope (at least I don't think so!) - same continent at least.
"Terry's Turkeys" is this year's coursework for one of the standard Computing qualifications in 16/17 academic year in the UK.

princess · Apr 16th, 2005, 11:48 AM

thanx 4 ur help!, i managed to finish off the flippin coursework!! it wz horrid but i dun it dint realise i h8 computing sooo much until dis coursework!!! thanx again byeeee

bl00dninja · Apr 16th, 2005, 2:12 PM

yeah, bye.

Rory · Apr 16th, 2005, 4:25 PM

well said!

Ooble · Apr 17th, 2005, 2:44 PM

Reminds me - I really should finish that off... thinking of rewriting my tables. I've decided to stick with C# instead of scrapping it and going over to PHP - I want this app to be independent.

Apr 11th, 2005, 1:28 PM	#1
princess Newbie Join Date: Apr 2005 Location: london Posts: 4 Rep Power: 0	Plz Help Me!!! hiya i desperatly need help wid my AS computing coursework (terry;s turkeys). i need to use visual basics (which i have neva used b4 !!!) to link up my forms wid my tables. plz could sum1 send me VB codes so i can do this, A.S.A.P, cz it needs to b dun by dis thur!!! thnx

Apr 12th, 2005, 2:40 AM	#3
princess Newbie Join Date: Apr 2005 Location: london Posts: 4 Rep Power: 0	hi yeh my exam is at da end of may/ begginning of june, but i have to hand in a 1st draft of terrys turkeys this thur! my teacher is an idiot...dsnt seem2 undastand much himself! basically im using access 2000. ive made all my tables and all my forms but the problem is wen i put customer details into the forms, i have a command button that says 'confirm'. when i click it i want my data to appear in the table (thats what i mean by linking up my tables and my forms) and im using (or trying2 use!!) visual basics by writing in codes to make this happen but its all a big fat mess!! the only useful thing my teacher said wz 2 use visual basics and thats it!! plz sum1 out there help me!!!

Apr 12th, 2005, 4:09 AM	#4
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Right, the simplest way to interact with the form in VBA is to manipulate the DoCmd object exposed by the navigation controls, required constants can be found through the object inspector or help. To actually add code you'll have to tie it to a VB event handler (right click the object -> build event). For instance the following code will save the current record: (Toggle Plain Text) DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord So to go to the next record would be: (Toggle Plain Text) DoCmd.GoToRecord , , acNext DoCmd.GoToRecord , , acNext and so on. Hope this is helpful.

Apr 12th, 2005, 8:14 AM	#5
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	This assignment sounds awfully familiar... is this guy in your class? http://www.programmingforums.org/for...ead.php?t=3235 __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Apr 16th, 2005, 11:48 AM	#7
princess Newbie Join Date: Apr 2005 Location: london Posts: 4 Rep Power: 0	thanx!!! thanx 4 ur help!, i managed to finish off the flippin coursework!! it wz horrid but i dun it dint realise i h8 computing sooo much until dis coursework!!! thanx again byeeee

Apr 11th, 2005, 2:07 PM	#2
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	If you're using access, the in-database forms "link up" to the data by themselves. If you want to link your database to an external VB application, then the data control does a good job through Jet or ODBC (you can pull the data by setting the DataSource property to the appropriate settings) - you can even get a wizard to do this bit! It's when you want to do something more complicated involving the interpretation or validation of data that you need VB (or VBA in office) code - if you could be more specific that'd be helpful. Good luck with that, though I thought the exams weren't for some time.

Apr 12th, 2005, 5:17 PM	#6
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Nope (at least I don't think so!) - same continent at least. "Terry's Turkeys" is this year's coursework for one of the standard Computing qualifications in 16/17 academic year in the UK.

Apr 16th, 2005, 2:12 PM	#8
bl00dninja Programming Guru Join Date: Oct 2004 Location: namespace std Posts: 1,246 Rep Power: 5	yeah, bye. __________________ i put on my robe and wizard hat... Have you ever heard of Plato, Aristotle, Socrates?...Morons.

Apr 16th, 2005, 4:25 PM	#9
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	well said!

Apr 17th, 2005, 2:44 PM	#10
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Reminds me - I really should finish that off... thinking of rewriting my tables. I've decided to stick with C# instead of scrapping it and going over to PHP - I want this app to be independent. __________________ Me :: You :: Them

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Programming Forums > Application Development > Visual Basic

Plz Help Me!!!