PDA

View Full Version : Need help to write code for the interface?



bunty
07-07-2010, 11:26 AM
Hi friends..
I wanted to build one interface in that one command button called view.when I click on that a grid view will open which contain user data.there are few more command button for add ,delete and update user record.If you want to delete any record select that record and click on delete button.If you want to add some record you can able to add record.
As I just started to work on access,and this my requirement.I am not able to write code for that.please help me its very important.

Thanks

OBP
07-08-2010, 04:09 AM
Bunty, do have any Forms in your database?
As forms are where data should be added and edited.
You can create a simple "Switchboard" to open forms using a blank form and Command Buttons. The Command Button Wizard creates the VBA code for you to open a Form or Report.

bunty
07-08-2010, 09:45 PM
Hi OBP,
first thanks for your response.No,I have only the database which holds user and admin records.I have design one form in which only one command button is available.I dont know how to add the grid view option to fetch that table whenever I click on that button.When the grid view will display I need to perform other operation like add or delete record.Please guide me bcoz i dont have any idea.If possible pls provide me vba code and some intruction to design that forms.Waiting for your response....

thanks

OBP
07-09-2010, 05:56 AM
bunty, you need to go to the Forms Objects and use the "create a form by using Wizard".
Select the Table and fileds you want to display on the Form and press OK.