Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access course london - opening form datasheet view

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course london - Opening a form in datasheet view

access course london - Opening a form in datasheet view

ResolvedVersion Standard

Andrew has attended:
Access Advanced course
Access VBA course

Opening a form in datasheet view

I want to open a form to show a list rather than individual records, via a button. I have set the default view of the form to "Datasheet". If I open the form from the Database window it opens as I want it to, but whenever I open it via the button it opens in Single form mode. Any ideas please?

RE: Opening a form in datasheet view

Hi Andrew,

Behind every button, there is a macro that specifies how the form will display when clicked.

Did you build this macro or did you use the wizard?

If you buld your own macro, use the OpenForm command. One of the properties of this command is the way you want to view the form. Set this property to the one you want, and then allocate the macro to the button.

Let me know if that works..

Regards

Richard

RE: Opening a form in datasheet view

Thank you Richard, I think that's what I needed.
Andrew

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.