About Button Features

[notrino]

Hello,


You know, wew can open any form with criteria like this codes;

DoCmd.OpenForm "Form Name", acNormal, , "[ID]=" & Me.ID

I want to like this code for button feature adjestment. For example, I want to enable the button1 with criteria.
I know, "Me.Button1.Enabled=True" code is working always but this code is not incluyding any criteria. I want to like this: ID=1 record Button1 must be enabled=True..
Is that possible? Thanks.

[June7]

Yes, button controls can be conditionally enabled/disabled. It's just If Then code. However, I don't understand your criteria. Why would it matter if the record ID is 1?

[davegri]

Maybe in the form_current event:
If Me.ID = 1 then button1.enabled = true

[June7]

Would need Else for when the ID is not 1. This can be done without If Then Else with simply:

Me.button1.Enabled = Me.ID = 1

[notrino]

Ok, I'm asking again, please look at the attaced file. This is a continuous form and a1, a2 areas disable. When I push the ID1 line button, ONLY that "a1 text box" must be enable.(Not ID2 a1 text box) Question is this...ID must be criteria like

DoCmd.OpenForm "Form Name", acNormal, , "[ID]=" & Me.ID

[Missinglinq]

You've completely reversed your scenario!

In Post #1 you say "...I want to like this: (if) ID=1 record Button1 must be enabled=True...."

Then, in Post #5 you write "...When I push the ID1 line button, ONLY that "a1 text box" must be enable.(Not ID2 a1 text box)..."

Which is it? Are you trying to Enable the Textbox or the Command Button?

If it's the Command Button, on a Continuous Form, you can't have it Enabled on Record and not on all Records...that's just the way Continuous Forms work. While you see multiple Buttons, only one Button Control actually exists.

You'd have to use a Textbox in place of the Command Button, tweak its Formatting to look like a Command Button, then use Conditional Formatting (off of the Menu or Ribbon) to Enable/Disable it.

Linq ;0)>

[Eugene-LS]

notrino try file below:
kritere_gore_denetim_ozelligi_v03.zip

[notrino]

Hello everybody,

Yes, Eugene_LS, you understand me and you sent me true solution. Thank you so much..

[Eugene-LS]

Yes, Eugene_LS, you understand me and you sent me true solution. Thank you so much..

notrino - Name your DB objects in English only (Captions = Free), or you will have troubles with opening it in computers with other language setting
I did not immediately understand why your application does not work for me
I have:
Win10 x64 Pro RUS + MSO 2010 x86 ENG ... for example.

[notrino]

Ok Eugene-LS, you are right..Thanks.

[notrino]

Eugene_LS,
I want to ask something about this application. Your solution is working well but when I do same things, (create table, create form, controls, write your codes etc..) my application is not working. Why? Have your solution including any hidden module or query etc? Because my objects and your objects are, all of them same!Thanks..

Not: I attached my solution..

[June7]

No idea why, but your db does not like the Load event for this form. Sometimes corruption happens without apparent reason and cannot be fixed. I created a new form, copy/pasted all controls, set up event code. New form works. Delete old form. Rename new form. However, Compact & Repair had an issue. It renamed the database.