Datagrid in access?

[BasilM]

Good Day All,
this is the first time I use access for application


I was using the VB studios
but I am facing a little difficulties in access .. for example the the form design !
and I am missing some important controls .. like datagrid ...
how to extract a certain SQL in datagrid?!
also I would like to have a website where you can fins a professnial designs templates other than MS

[June7]

Search forum or Google.

http://www.granite.ab.ca/access/gridcontrols.htm

Why do you need? Can't form in DatasheetView serve?

[BasilM]

Thank you June7 for your reply
what if I want to do an SQL search about the "type" for example
I should right the "type" as variable in a form and directlly the results should be retrieved in a datasheet data ..
can I do this ? and how?

[June7]

Review this for one method http://datapigtechnologies.com/flash...tomfilter.html

[BasilM]

many many thanks

[BasilM]

can I click in one record of the datasheet and show another form which will contain it's details ?

[June7]

Yes. Need code. I use only VBA. I use form DblClick event for this.

DoCmd.OpenForm "formname", , , "ID=" & Me!ID