Button to show all records on "Data Entry Form" (1 Viewer)

[moi]

Good day,

How could I show all my records in my data entry form by clicking a button.. I tried "ShowAllRec" but it is not working (Invalid use of property)..

Thank you

 

[theDBguy]

Try:

Me.DataEntry=False

 

[moi]

Try:

Me.DataEntry=False

Many thanks theDBguy... why i did not see this!

 

[theDBguy]

Many thanks theDBguy... why i did not see this!

You're welcome. Good luck with your project.

 

[Pat Hartman]

How could I show all my records in my data entry form by clicking a button.. I tried "ShowAllRec" but it is not working (Invalid use of property)..

How many records can the user work with at any one time?

 

[Gasman]

Good day,

How could I show all my records in my data entry form by clicking a button.. I tried "ShowAllRec" but it is not working (Invalid use of property)..

Thank you

Where did you find ShowAllRec ?

 

[Pat Hartman]

@moi If your form is filtered, you need to remove the filter. If your form is bound to a query with a where clause, you need to provide a different search value.

 

[LarryE]

DoCmd.ShowAllRecords

 

[moi]

Where did you find ShowAllRec ?

Hi.. When i type Me. It shows me that selection..

 

[moi]

@moi If your form is filtered, you need to remove the filter. If your form is bound to a query with a where clause, you need to provide a different search value.

Hi pat, good day.
My form is bound to a table..

 

[moi]

DoCmd.ShowAllRecords

Thanks..

 

[Gasman]

Hi.. When i type Me. It shows me that selection..

Hmm, when I try in the load event, the first I get with M.sh is .ShortcutMenu ?

 

[moi]

Hmm, when I try in the load event, the first I get with M.sh is .ShortcutMenu ?

hi, i think i did not say that it is the first item.. it is there 3rd item on the list..

anyway thank you for picking up my post sir.. slowly am learning..

 

[Gasman]

That is what I am saying. They are displayed in alphabetical order?
Here is mine. I do not even have that entry? I am on 2019 now,

 

[GPGeorge]

As I understand it, intellisense shows User Defined Functions (UDF), and probably also user defined subs, in the current module. That suggests to me that what @moi's screenshot shows is actually a function in his module.

 

[Gasman]

As I understand it, intellisense shows User Defined Functions (UDF), and probably also user defined subs, in the current module. That suggests to me that what @moi's screenshot shows is actually a function in his module.

Yes, the O/P seems to like creating functions instead of looking for using the Access functions.

 

[Pat Hartman]

If your form is bound to a table, it is already showing all the records. What did you do to make it not show all the records??????

 

[LarryE]

The OP seems to be confused between what is an ACCESS executable command and what is a defined control name on a form. I think they wanted to somehow execute a control name.

 

[moi]

If your form is bound to a table, it is already showing all the records. What did you do to make it not show all the records??????

I set it as a "data entry".. Reason for wanting to showallrecords is sometimes i need to browse the records..

 

[Gasman]

A form in edit mode is still capapble of data entry using the button on the bottom of the form. You could also use your own button.
Data Entry property means you can only ever add records. The most misnamed property in Access.