how to display a table into vba forms?

[sunny1]

Hi,
ANY ONE PLEASE HELP ME TO DISPLAY TABLE ALL DATA INTO A FORMS LIKE GRID VIEW.I tried but there is no grid control ,which control i CAN USE .
THANKS

 

[vbaInet]

1. Open the PROPERTY SHEET for the form
2. Click the FORMAT TAB
3. Change the DEFAULT VIEW property to DATASHEET VIEW
4. Also change the ALLOW DATASHEET VIEW property to Yes

For form basics have a look at the tutorials contained here

 

[Galaxiom]

Set the form Default View property to Datasheet.

Display the form in a subform control if you also wish include other controls on the main form. Set the Default view of the form used as the Source Object of the subform control as Datasheet.

You can simply set the Source Object as a table or query but this is not a good technique as very few features are available to control the display and interaction with a table compared to a form.

 

[sunny1]

Thanks to all for your help..I have set the property but I dont know how to display the table onto the form.My task is we have one form and a table(some field like empId,UserId,Name,pwd etc).All the record which which is store in a table should display in a forms either all at a time or one by one.
If I want I am able to delete or add some new record into table through that form.
If possible please give the code for that.because I dont have any experience in vba programing and the task is very important for me.

thanks

 

[Poppa Smurf]

In the Data tab in the property sheet for the form set the record source to your table name.

 

[sunny1]

HI all,
Thanks for your help.Here I have attaches my data base file.
Please you can go through that.In That file I have created one table.I need your help is please create one forms two display the userdata and perform some addition and deletion operation.
The process is like that frmLogon form is the default forms.If the user is admin the next page is open and that page should perform all these addition ,deletion operation.

Please do it for me,I am not able to do that and the time is very less for me.

thanks

 

[vbaInet]

We tend not do homework for users and in fact we would usually guide into doing it yourself as opposed to us doing it for you