ON STOP

[Harry Taylor]

Hi,

I have a list of customer accounts, some of which don't pay and I want to put their account on stop.
I have tried a text box with conditional formatting (red), but it looks a bit naff

I'm looking at putting an "On Stop" button on a form, which then displays 'On Stop' across the entire record.

Possibly an On Stop png picture?
So it opens and closes the picture file using a toggle button

Any thoughts / ideas?

Thank you

 

[plog]

Change the background to red, Disable all appropriate inputs. on stop image is fine, but you are going to want it transparent so the user can still see relevant info so they know which record looking at.

Whatever method you choose, the code will need to be in the OnLoad action as well--what if a user opens a record that is already on stop?

 

[Harry Taylor]

Thanks Plog,
I dont really need to disable anything, users can still make changes, but i want them to know they're on stop.
The staff are good enough that they wont offer assistance until any debts are paid

Ideally, I want to open / close a PNG picture using a toggle button.
Is this possible?

 

[The_Doc_Man]

The more important question is whether that account is singly displayed or part of a continuous form.

The idea of controlling the account via some kind of command button is eminently possible. What you are able to display when using it depends on the form type.

 

[plog]

Ideally, I want to open / close a PNG picture using a toggle button.

Yes. You could make a whole new form for it and open it. That would be DoCmd.OpenForm

DoCmd.OpenForm method (Access)

Access VBA reference

docs.microsoft.com

Or you could just hide/unhide the image on the existing form:

Image.Visible property (Access)

Access VBA reference

docs.microsoft.com

 

[arnelgp]

you add OnStop (Yes/No) field to your table.
then you create a new table (OnStopImages) with fields:

OnStop (Yes/No) (PK)
Image (Attachment)

add one record to the above table and add the "OnStop" image.
create a Query that joins your table with OnStopImages table (Query1).

see form SampleOnStopForm that uses such table.