Solved Order Approval History (Submit command Button) (1 Viewer)

Sarah.M

Member
Local time
Today, 13:04
Joined
Oct 28, 2021
Messages
335
Hi, Plz note, My "VBA" is disabled at work for security reason
Plz in your explanations use only Expression builder, Macros, Queries, Tables, Forms or Reports only.
Plz understand my circumstance
---------------------------------------------------
I have Order Form and its approval history
Picture 1
I want it to prevent me from submit the status twice and a message appears that "you cannot send twice, please make a new submission"
Picture 2
If you open the same form, the command button should not return to the enabled state, It must remain disabled, it should be only enabled with the new record
plz help me to do it

1635707576260.png
 

Attachments

  • ‏‏‏‏‏‏‏‏‏‏IssueTrack16Ask.zip
    234.8 KB · Views: 336

theDBguy

I’m here to help
Staff member
Local time
Today, 03:04
Joined
Oct 29, 2018
Messages
21,357
Hi. You should be able to use DCount() to check for duplicates; and since you're using a Continuous form, you won't be able to disable the submit button for specific records. It will be all or nothing. So, I would suggest that giving them a warning message or ignore the click if they're not supposed to submit the record.
 

Sarah.M

Member
Local time
Today, 13:04
Joined
Oct 28, 2021
Messages
335
Hi. You should be able to use DCount() to check for duplicates; and since you're using a Continuous form, you won't be able to disable the submit button for specific records. It will be all or nothing. So, I would suggest that giving them a warning message or ignore the click if they're not supposed to submit the record.
Hi, thanks you for ur reply,
Kindly can you show me ur solution by uploading database.
plz!
 

Gasman

Enthusiastic Amateur
Local time
Today, 10:04
Joined
Sep 21, 2011
Messages
14,038
I am just wondering what vba can do, that queries, macroes etc cannot? 😔
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:04
Joined
Oct 29, 2018
Messages
21,357
Hi, thanks you for ur reply,
Kindly can you show me ur solution by uploading database.
plz!
Hi. Sorry, I'm not in front of a computer now. I would recommend you give it a try and let us know how it goes. You could also maybe learn better that way.

Sent from phone...
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:04
Joined
May 7, 2009
Messages
19,169
i replaced your command button with a Textbox and used Conditional Format
to set it to Red background.
 

Attachments

  • __________IssueTrack16Ask.zip
    141.9 KB · Views: 350

Users who are viewing this thread

Top Bottom