Solved

MS Access form is blank if no records

Posted on 2014-12-11
6
478 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
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 35

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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