Solved Bar at the bottom of the screen

[cbabi2]

Hi guys,

what is the name of the bar at the bottom of the screen before the status bar and how can I hide it when opening forms or report

Thanks

 

[isladogs]

Navigation buttons.
Go to design view and set the property to No in the form property sheet

 

[arnelgp]

it is the "horizontal scrollbar" of the form.

 

[cbabi2]

Navigation buttons.
Go to design view and set the property to No in the form property sheet

Thanks , I get to hide it on the form... I have this report which is default to show as page preview, I also want to hide its navigation buttons but I cannot find the navigation buttons property in report property sheet.

 

[Gasman]

Well if you are going to show Print Preview, you need the page buttons to view the pages surely?

 

[cbabi2]

Well if you are going to show Print Preview, you need the page buttons to view the pages surely?

I want it to be like this

 

[cbabi2]

There are two ways to view a report. Print Preview and Report View. Print Preview is like a paper copy. There is no interaction with the user. Buttons are not active so you need the navigation bar to go from page to page.. The other view is more like a web page and it does support buttons and other types of code. HOWEVER, it does NOT paginate so it does not run any page break code and you would NOT be able to use your own buttons unless you are willing to write the code to paginate yourself. Not that hard but you won't find any examples unless you have an old COBOL textbook.

Why don't you just use a form and be done with it? You can make the form not updateable.

Thanks for the response Pat, is it possible to show a non-continuous report in a form which can navigate the pages through a command button?

 

[cbabi2]

I created a subform bounded to the main table and formatted the the report looks like (contineous)... but on these subform I to show only a certain numbers of records and the remaining will be on the next page and these pages can be navigated in a control button on the form. I also want this subform locked for editing. Thanks for the replies

 

[cbabi2]

Set the AllowEdits, AllowDeletions, AllowAdditions properties to No

Thanks my subform is now locked for editing, the subform was still in continuous form...how can I make the subform comes in pages? I am planning to add a control button on the main form to navigate the pages on the subform if I am able to break it.

 

[oleronesoftwares]

Change the form's default view property, this can be accessed via design view

 

[cbabi2]

I have tried to cahnge the view property but theres no option for page preview only datbase view, split, continuous and single

 

[Gasman]

I have tried to cahnge the view property but theres no option for page preview only datbase view, split, continuous and single

Forms do not have pages?
You would likely need to move x records forward back, depending on how many are displayed.?
Then you would also need to test if you cannot move forward/back x number of records.

 

[cbabi2]

how can I move and test them?

 

[Gasman]

how can I move and test them?

DoCmd.GoToRecord method (Access)

Office VBA reference topic

docs.microsoft.com

    DoCmd.RunCommand acCmdRecordsGoToLast
    DoCmd.GoToRecord acDataForm, Me.Name, acPrevious, 5 ' Needed for a continuous form as only last record shows.
    DoCmd.RunCommand acCmdRecordsGoToLast

 

[cbabi2]

thanks guys, @Gasman 's code helps me to navigate my subform.