If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display switchboard name in textbox on switchboard form
How do I go about displaying switchboard name in textbox on switchboard form.
My switchboards setup has a number of sub-swtichboards and I would like the name of this to update as the user navigates. After looking at the table Switchboard Item, I guess I need to show the Item Text for ItemNumber 0 which each matching SwitchboardID. However, can somebody help me on how to do this please. Regards, Bruce |
#2
|
|||
|
|||
Display switchboard name in textbox on switchboard form
On Wed, 14 Jul 2004 16:45:02 -0700, Bruce wrote:
How do I go about displaying switchboard name in textbox on switchboard form. My switchboards setup has a number of sub-swtichboards and I would like the name of this to update as the user navigates. After looking at the table Switchboard Item, I guess I need to show the Item Text for ItemNumber 0 which each matching SwitchboardID. However, can somebody help me on how to do this please. Regards, Bruce Unless you have modified the built-in Access Switchboard, the main label is actually 2 labels offset a bit to give a shadowed effect. Display the Switchboards code window. Find the Private Sub FillOptions() sub-procedure. Find the If(rst.EOF) line, and add the 2 lines of code shown with the *** below so that that portion looks like this: If (rst.EOF) Then Me![OptionLabel1].Caption = "There are no items for this switchboard page" Else While (Not (rst.EOF)) Me("Option" & rst![ItemNumber]).Visible = True Me("OptionLabel" & rst![ItemNumber]).Visible = True Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText] rst.MoveNext Wend End If Label1.Caption = Me.Caption ' *** ADD Label2.Caption = Me.Caption ' *** ADD ' Close the recordset and the database. rst.Close dbs.Close End Sub -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
Switchboard form views | Garry | New Users | 4 | July 14th, 2004 08:22 PM |
datasheet forms open in form mode from the Switchboard | Paul James | Using Forms | 5 | July 13th, 2004 06:51 AM |
Display file size (or other attributes) in textbox on form. | Craash. | General Discussion | 2 | July 4th, 2004 09:13 PM |
Creating a Switchboard Form | Mark G | Using Forms | 1 | May 28th, 2004 09:13 PM |