Solved

MS Access form is blank if no records

Posted on 2014-12-11
6
546 Views
Last Modified: 2014-12-13
Why is the form blank if no records are found in the table that sources the main form or sub form.  I do not allow additions, but I do allow updates.  

Is the rule if I do not allow additions or deletions the form will always be blank if no records are found ?
0
Comment
Question by:upobDaPlaya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 37

Accepted Solution

by:
Neil Russell earned 100 total points
ID: 40494781
If no records are found how can it be anything except blank? It cant display something that it has not found.
0
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 100 total points
ID: 40494796
A form will usually show a blank record. But if you do not allow additions then it cannot show the empty record. So the form is"empty". No field, no nothing.

Is just the way access works.

Kelvin
0
 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 100 total points
ID: 40495018
You may not allow additions on this form but somehow the records got added.  If you want to use the same form for both add/update and you don't want it set to allow additions, you can add a button the user can press and you can change the form properties to allow additions if the user needs to add.
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 100 total points
ID: 40495455
There seems to be a lot of confusion about your question, based on the Expert's responses.

So lets be clear:
Why is the form blank if no records are found in the table that sources the main form or sub form.
So are you saying that the source table HAS records, ...yet they do not display in the form?
If so, then perhaps you have the "Data Entry" property set to YES.
Setting the data entry property to Yes will always display a blank form (ready for the user to enter new records only.)
If this is the case, set the Data entry property to NO.

JeffCoachman
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 100 total points
ID: 40495880
Why is the form blank if no records are found in the table that sources the main form or sub form.
What would you prefer to see if there are no records?
0
 

Author Closing Comment

by:upobDaPlaya
ID: 40498063
The confusion for me was I had a control button on the form so it could be pressed on and import records.  This button was not visible and I thought at minimum it should be visible.  Thus, I moved the button from the details section to the page footer.  I agree if there is no records why would I expect to see anything.  Sorry for the confusion and thanks for the inout.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

734 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