need help with creating this kind of access form

cysklement

Registered User.
Local time
Tomorrow, 06:55
Joined
Aug 19, 2013
Messages
13
Hi I had attached a sample form here from a sample database.
I need help with how to create a database that looks like the file as attached.
The form here has the outlook of combination of datasheet and buttons.:banghead:

Thanks.
 

Attachments

  • sample database.jpg
    sample database.jpg
    93 KB · Views: 125
Can you explain further - if you want a db to look like the sample database, and you have the sample database - what can we tell you that the sample database doesn't?
 
That's just a standard form with a subform in datasheet view... the buttons will be on the header of the main form.
 
yes

if you have a continuous form, you can include the buttons in the form header and footer. with a datahsheet, you just do not see the header or footer - so you need a different technique - which is to put the buttons on another form - of course the coding then becomes a bit trickier, because the data is on a different form to the buttons.
 
Go to the home page of this website and click on video tutorials.

This one may give you a headstart ...
Creating a main Form and sub Form using the Form Wizard
 
That's just a standard form with a subform in datasheet view... the buttons will be on the header of the main form.

I think I have tried this but it doesn't seems to be working. I am going to try again to build a form like this to see it it works. Thanks
 
I am just curious on how this form sample build it's form with a datasheet and buttons on top. I want to build 1 that looks as file attached "DBFORMSAMPLE1.jpg" where there's buttons on top of datasheet.

But when I put the form into design view as attached "DBFORMSAMPLE2DESIGNVIEW", It doesn't seems like the form is created with a subform of datasheet. Any1 could help me with this kind of form build?
 

Attachments

  • DBFORMSAMPLE1.jpg
    DBFORMSAMPLE1.jpg
    88.8 KB · Views: 108
  • DBFORMSAMPLE2DESIGNVIEW.jpg
    DBFORMSAMPLE2DESIGNVIEW.jpg
    87.1 KB · Views: 108
I have found it. It's a split form. :D

Thanks all

:D:D:D:D:D:D:D:D
 
Last edited:

Users who are viewing this thread

Back
Top Bottom