Advertisement
- Home
- Software
- Database
- MS Access
- Access Forms
- Continuous Forms, "Form_Current()" and .Visible command
Advertisement
- 1. capricorn1 1,001,987
- 2. boag2000 703,255
- 3. LSMCons... 563,438
- 4. DatabaseMX 454,307
- 5. peter57r 355,026
- 6. harfang 196,202
- 7. jimhorn 168,990
- 8. wiswalld 158,488
- 9. hnasr 109,444
- 10. ldunscombe 100,086
- 11. GRayL 95,447
- 12. eghtebas 89,813
- 13. koutny 89,650
- 14. MikeToole 88,218
- 15. mbizup 79,834
- 16. frankytee 77,464
- 17. TextReport 76,173
- 18. LennyGray 74,748
- 19. matthews... 74,462
- 20. omgang 71,150
- 21. irudyk 69,530
- 22. JDettman 69,070
- 23. Rick_Ric... 60,265
- 24. dqmq 60,103
- 25. jefftwilley 57,170
- 1. capricorn1 1,490,229
- 2. DatabaseMX 805,520
- 3. boag2000 752,345
- 4. LSMCons... 740,806
- 5. peter57r 571,995
- 6. jefftwilley 342,237
- 7. harfang 338,723
- 8. mbizup 282,451
- 9. jimhorn 272,537
- 10. wiswalld 198,702
- 11. frankytee 185,705
- 12. GRayL 173,515
- 13. MikeToole 153,036
- 14. stevbe 146,536
- 15. matthews... 138,812
- 16. LPurvis 129,295
- 17. ldunscombe 121,545
- 18. JDettman 121,270
- 19. dqmq 112,975
- 20. eghtebas 112,058
- 21. hnasr 109,444
- 22. koutny 100,675
- 23. omgang 96,485
- 24. puppydog... 92,189
- 25. LennyGray 84,328
| 03.30.2008 at 05:55AM PDT, ID: 23280635 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Continuous Forms, "Form_Current()" and .Visible command
Asked by impactuser in Access Forms
Tags: Microsoft, Access, 2003, Continuous Forms, "Form_Current()" and .Visible command
What I have currently got is a technical database with various tabs with client information. One of these is a broadband information tab.
In the past, I used to have a single form displayed and users of the database could scroll through the details (IE if they had more than one broadband connection...). It also included a simple script that would show if the broadband was cancelled via this code:
Private Sub Form_Current()
If Len(Me.Cancellation_Date & "") = 0 Then
Me.Label77.Visible = False
Else
Me.Label77.Visible = True
End If
End Sub
The above script functions like this: If there is nothing on the cancellation_date field then it does not display a message, otherwise it will, simple, straightforward and very effective!
I have changed the way the database looks so that it displays a list of available broadband details in a continuous form where the users can see quick information and an option to press a view button to expand....
The main problem is when I am trying to get the message to report that the broadband is not active. It either does not display anything or displays it for all the connections - even if they do not have a data in the cancellation field!!! To show this I have attached an image to explain better. The first line is the line that is "NOT ACTIVE" as it has a cancellation date... however the 2nd line is an active line and does not have a cancellation date... however it still displays the NOT ACTIVE when it should be hidden.
Is anybody aware of limitations of the .visible function in Continuous Forms mode or is there another solution I could implement?
Thanks,
SteveStart Free Trial
