Button to show all records on "Data Entry Form"

[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.

 

[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 ?

 

[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.

 

[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.

 

[moi]

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.

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.
View attachment 113898

Thanks.. I knew it, i will learn it here..

 

[CJ_London]

Data Entry property means you can only ever add records.

Not quite true- you could add a record, add some more then edit an earlier just added record before closing the form. I think filtering or sorting will also clear the form

 

[Gasman]

Not quite true- you could add a record, add some more then edit an earlier just added record before closing the form. I think filtering or sorting will also clear the form

Hmm, never realised that, though TBH never use that either.
Just tried it out, (I like to confirm for myself as well ) and can see that records added in that session can be amended.

Thank you @CJ_London that could help me help others in the future.