[access] field visible on condition

Hello,

I am making a program in Access 2003 for managing a car fleet.

I would like to know how to integrate the depreciation schedule for the vehicles, which is titled as follows:

Acquisition date: DA

Value date: DV

Acquisition cost: CA

DV1 = DA + 365 days

CA1 = 75%*CA

DV2 = DV1 + 365 days

CA2 = 50% *CA

DV3 = DV2 + 365 days

CA3 = 25% * CA

DV4 = DV3 + 365 days

CA4 = 0% * CA

Your help would be very valuable to me.

Hello everyone,

I have a problem similar to yours but the proposed solutions aren’t working...

I’m editing invoices using Access 2010. The report retrieves the necessary information from the forms filled out previously.

I have 3 fields that should only display if they are different from 0 and I’m unable to do that.

I right-click, create an event, code generator. I type this:
Private Sub Quantité_achat_pour_vente_Enter()
If Quantité_achat_pour_vente <> 0 Then
Quantité_achat_pour_vente.Visible = True
Else
Quantité_achat_pour_vente.Visible = False
End If
End Sub

And so when I open my report it gives me an error message because in the properties of my field I have visible = YES. My only other choice is NO and I am forced to leave the field filled.

Any ideas?

Thanks thanks!

Hello everyone,

I also have an issue with a continuous form where I have an image that I want to display (or not) depending on the value of field S1. (if S1<0, display the image)

I entered the following code (access 2002)

Private Sub Form_Current()
If [S1] < 0 Then
[alert].Visible = True
Else
[alert].Visible = False
End If
End Sub

The problem is that the display is the same for all records...If I select a negative value in one of the records, the image is displayed properly but for all records (even those where field S1 is >0). I applied your different suggestions, but it still doesn’t work!

Thank you in advance to those who will take the time to help me, and well done to everyone for the quality of your responses

Best regards

If checkbox_name = True Then 'if the checkbox is checked
Me!field_to_hide.Visible = True 'show the text box1
Else
Me!field_to_hide.Visible = False
End If

Hi everyone,

Just to thank you, your many suggestions on this post helped me solve my problem without having to ask a question. Namely, displaying fields when a checkbox is checked.

It’s very simple after all:

1 - right-click on the checkbox - create event code
2 - enter this (with your field names of course)

If checkbox_name = True Then 'if the box is checked
Me!field_to_remove.Visible = True 'show text box1
Else
Me!Location.Visible = False
End If

3 - select Form from the choice list above on the left and "current" from the choice list on the right in VBA and copy exactly the same code

If checkbox_name = True Then 'if the box is checked
Me!field_to_remove.Visible = True 'show text box1
Else
Me!Location.Visible = False
End If

See you later

Fab

I’m coming back to this post again...

I have another issue, but of the same level...

Still in the same database.

In my quote form, when I enter a product, I want it to appear either in the "quote" state or in the "delivery note" state, or both...

So I created 2 checkboxes on my items: one for "appear on quote" and one for "appear on DN"

I right-clicked on the checkbox and selected "create event code" and I entered:

if [Ab2]=true then
me! États![P_Devis#Devis#]![AbsMontant].Visible = true
else
me![Ab2].visible=false

Legend: [Ab2] is my checkbox
[AbsMontant] is what should display or not, which is found in the report P-Devis#Devis#

I close it, and when I click on the checkbox for the item, it tells me:

Microsoft Office Access cannot find the macro if [Ab2]=true then
me! États![P_Devis#Devis#]![AbsMontant].
The macro (or its macro group) does not exist, or the macro is new but has not been saved.
Note that when you enter the syntax groupnamemacro.macroname in an argument, you must specify the name under which the macro group of the macro was last saved.

Then it still checks the box but does not change the quote state...

Anyway, I’m a bit lost... thanks to those who can help clarify my problem.

Hello,

My problem has led me to this discussion. I see that some of you are skilled in Access (lucky you) and I need your valuable help.

I have a database called "contract" that includes several tables (info, contacts, billing, scheduling, date, etc.). I have created forms and subforms for data entry to make it easier for my users.
Furthermore, some contracts have been terminated and I do not want to delete the record but only hide it using a checkbox, for example, active or inactive. While still being able to find them by clicking a button "show inactive contracts."

I know it is possible to hide "inactive" records using a query. But my records are established directly from several tables.

I have not yet set up any macros in my database. I don’t master macros in Access (but I can manage in Excel)

Is this possible?

Thank you.
LH

PS: do you know a site explaining SQL language formulas? Thank you.

Hello,

I have a similar problem but in Word.

I created a form and I would like the checkboxes to be interactive when someone fills it out.

Let me explain: in the question about the product material, there are options for Steel or Stainless Steel, and I want the person filling it out to be able to check only one box (either one or the other, but not both).

Thank you.

Hello,

I also have a problem trying to make a field visible conditionally.
The field remains visible regardless of the condition.
Here is my code, hoping someone can help me.

Private Sub Form_Current()
If EMPLOI = "Unemployed" Then
nivrequis.Visible = False
Else
nivrequis.Visible = True
End If
End Sub

Private Sub nivrequis_BeforeUpdate(Cancel As Integer)
If EMPLOI = "Unemployed" Then
nivrequis.Visible = False
Else
nivrequis.Visible = True
End If
End Sub

Hello,

At first glance, if I stick exactly to what you're telling me, you have a quote table with product codes in it?
If that's the case, it sounds like a convoluted setup.

But then again, you might not have time to redo a database from scratch.

In your state, like in your form, you can create code to show/hide objects (controls).

In design mode, right-click and then create the event code, the code generator.
You choose the open() event and there you put the appropriate code, like:
if vchek2=true then
me.texte3.visible=true
.....
else
me.texte3.visible=false
.....
end if

Of course, this needs to be adapted.

For the "big hole in the middle" as you say, I don't really see how you have just one quote table. The use of sub-reports was definitely indicated.
If not, but it’s honestly a hack, you can use the above code to position your objects.
So, if your texte3 is not visible, you need to "move up" your texte4, with its properties:
if vchek2=true then
me.texte3.visible=true
me.texte4.top=
....

But that’s a hack...

Give me the structure of your tables, there might be a simpler way.

See you soon
--

When Jimmy says what’d I say, I love you baby
It’s like saying, the whole province sings in English.

I sincerely appreciate your help, but I can't send you the database because it is part of software with access code. So if I send it to you, you won't be able to open it....

Let me know if I'm on the right track:

In the table of my quote form, I have "name, first name... (of the client); AN8, PT4... (which correspond to the product, price...) ....
I added several checkbox columns to this table that I named VCHEK1, VCHEK2, VCHEK3, VCHEK4

In my form, I added an "existing field" and I dragged from my table VCHEK1, VCHEK2...

Then I created a report, and it's in this report that the text corresponding to the VCHEK1 checkbox should appear if I checked it. And that's where I'm stuck.... Furthermore, I would like that if I check boxes 1 and 3, the corresponding text in the report appears one after the other, without a big gap in the middle where there would be text 2

So that's it, and thanks again.

What I’m proposing is that you send me your zipped database.
If you’re worried about your data (I’m not a crook lol), make a copy and empty the “sensitive” tables.

I'll have a better look "visually" because right now it’s blurry!

My email is in my profile.

However, I won’t be able to look at this until Monday afternoon, I’m heading off for the weekend.

See you!
--

When Jimmy says what’d I say, I love you baby
It’s like they say, the whole province singing in English.

uh... it would be a bit long to describe because I didn't design the database. There are 50 tables and just as many forms and queries, possibly...

Let me explain:

The database was created to manage equipment rental. Basically, it manages a client file, manages the stock of equipment, and issues quotes and invoices...

I want to make a quote. So I open a form where I enter my client, my products... and I generate the quote (document)

Everything works well, but in addition to that, I want to add those little checkboxes in my form that I can check or not. Then I press a button, and it generates the corresponding document with the text from checkbox 1 and 3 displayed because I checked box 1 and 3 and the text from checkbox 2 not displayed because I didn't check checkbox 2 for this specific quote.

Well, it may seem a bit complicated like that, but it would be very useful to me...

Thank you

Re,

In my opinion, there is already a design issue...

For the opposite effect as you mentioned, the code I gave you should work. Obviously on the form.

Let us know what tables you have and what the database is for, in short, what you want it to manage.

Catch you later
--

When Jimmy says what’d I say, I love you baby
It’s like saying, the whole province singing in English

Hi and thanks for this initial information... I see things more clearly

The issue is that, here’s what I would ideally like to do:

I have a form that is part of a pre-built database.

On this form, I have checkboxes with titles for example:

chkbox 1: meals
chkbox 2: hotel
chkbox 3: travel

I want to choose in this form what I want to display but on a corresponding report and not on the form. The text described in the report is more complete than on the form, like "provide for 5 meals"

With the code you gave me, it makes it visible on the form. Moreover, it actually makes it invisible and it doesn’t reappear afterwards. I would like it to have the opposite effect as well.

Even better, I would like that if I check box 2, the meals are displayed at the top of the report and not in the middle.

Thank you for your help

Hello, three years later....

I'm brand new to Access but super motivated!

I'm working in Access for equipment management. The database has already been created, but not by me.

I would like to add this to the database: when I check a "checkbox" on a form, it displays text. If the box is not checked, it doesn't display.

Another condition: On my main form, I have all the texts that are displayed, so I can find my way around. When I check the corresponding box on this form, I want it to display on a report created specifically for that purpose.

I've already created my table, my form, and my report, but I'm a bit overwhelmed by the queries and relationships... I need a little help....

Thank you for your responses.

Hello,

This should help you: https://grenier.self-access.com/?post/2007/09/05/Listes-deroulantes-liees

See you
--

When Jimmy says what’d I say, I love you baby
It’s like they say, the whole province singing in English

Hi everyone, I'm new to the forum
I have a problem with combo boxes, actually I would like to display a list based on another list, more specifically:
when choosing an item from one combo, the items in the second combo should change. I tried using a query but it doesn't work. And this in the same form (Access 2003)

```html j'ai le même problème, j'ai mis mon code dans Current et je veux que si une date n'est pas saisie alors mon champ est activé, sinon non et ça ne marche pas :s

Private Sub Form_Current() If Not IsNull([dateValidPlanMinute]) Then [remarqueNonValid].Enabled = True Else [remarqueNonValid].Enabled = False End If End Sub

```