Solved

Form Datasheet with Buttons allowed?

Posted on 2014-01-30
4
711 Views
Last Modified: 2014-01-30
Hello,

Attached the  test DB. There is form- frmItem_Country_DisPipe_LINE
I came across this issue – if I want the form to appear in datasheet mode, I can’t place any button on that view. Now someone in the internet suggested that if  in that case, we use a continuous fomr type – it will let me do datasheet view  and  also let me put buttons on that form view as well. Can someone be kind enough to help me do that?

I want to add a button within this form specifically - frmItem_Country_DisPipe_LINE, not the main display form

Thank you
howDoesThisLook2014-Working.accdb
0
Comment
Question by:Rayne
  • 2
4 Comments
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 225 total points
Comment Utility
look at form "frmItem_Country_DisPipe_LINE_CF"
howDoesThisLook2014-Working.accdb
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 275 total points
Comment Utility
I stopped using Continuous Form views a long time ago, using Datasheet Views exclusively these days. Right ... you cannot directly add buttons on a DS view form. So ... what to do?

Put the Datashee View Form - as a subform - on another 'main form', wherein you can put your buttons in that form's Header and/or Footer.

That is what do when buttons are needed.

DS View forms have so many advantages over Continuous View forms ....

mx
0
 

Author Comment

by:Rayne
Comment Utility
Thank you both :)
I have been here in this site since 2007 or older. I have received help from both you previously years back as well. This is the first time - I am seeing your real names in addition to your  alias - I guess this is a EE ui change I suppose.

Thank you million
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
You are welcome.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now