C chrisguk Registered User. Local time Today, 15:39 Joined Mar 9, 2011 Messages 148 Apr 2, 2011 #1 Is there a step by step guide on how to create a status bar on the bottom of forms. Im looking to incorporate "whosloggedin" & "date&time" & "computername" Ay help is really appreciated Thanks guys
Is there a step by step guide on how to create a status bar on the bottom of forms. Im looking to incorporate "whosloggedin" & "date&time" & "computername" Ay help is really appreciated Thanks guys
DCrake Remembered Local time Today, 23:39 Joined Jun 8, 2005 Messages 8,623 Apr 2, 2011 #2 There is no step by step guide but it is not hard to do. 1. Select the status bar activeX controls 2. Drag it into the form footer section and resize to the width of the form 3. Click on the properties of the activeX control 4. Add the panels you want to include in your status bar User Name {Variable} Computer {Variable} Access Level {Variable} When the form opens you can define the contents of the panels (2, 4 & 6) Me.StatusBar.Panel(2) = StrUserName Me.StatusBar.Panel(4) = StrComputerName Me.StatusBar.Panel(6) = StrAccessLevel Attachments StatusbarX.JPG 41 KB · Views: 1,036 Panels.JPG 30.9 KB · Views: 652
There is no step by step guide but it is not hard to do. 1. Select the status bar activeX controls 2. Drag it into the form footer section and resize to the width of the form 3. Click on the properties of the activeX control 4. Add the panels you want to include in your status bar User Name {Variable} Computer {Variable} Access Level {Variable} When the form opens you can define the contents of the panels (2, 4 & 6) Me.StatusBar.Panel(2) = StrUserName Me.StatusBar.Panel(4) = StrComputerName Me.StatusBar.Panel(6) = StrAccessLevel
C chrisguk Registered User. Local time Today, 15:39 Joined Mar 9, 2011 Messages 148 Apr 2, 2011 #3 Have I got this right or have I completely missed the point. God i feel like such a noob. Code: Private Sub Form_Load() Me.StatusBar6.Panel(2) = StrUserName Me.StatusBar6.Panel(4) = StrComputerName Me.StatusBar6.Panel(6) = StrAccessLevel chkScaleControls = True chkScaleColumns = True chkScaleFonts = True End Sub It throws out an error saying method or function not allowed. I am assuming I dont actually type {variable} in every other box?
Have I got this right or have I completely missed the point. God i feel like such a noob. Code: Private Sub Form_Load() Me.StatusBar6.Panel(2) = StrUserName Me.StatusBar6.Panel(4) = StrComputerName Me.StatusBar6.Panel(6) = StrAccessLevel chkScaleControls = True chkScaleColumns = True chkScaleFonts = True End Sub It throws out an error saying method or function not allowed. I am assuming I dont actually type {variable} in every other box?
DCrake Remembered Local time Today, 23:39 Joined Jun 8, 2005 Messages 8,623 Apr 2, 2011 #4 Which line is throwing the error? Attachments Database1.accdb Database1.accdb 408 KB · Views: 177
C chrisguk Registered User. Local time Today, 15:39 Joined Mar 9, 2011 Messages 148 Apr 2, 2011 #5 DCrake said: Which line is throwing the error? Click to expand... Sorted, you missed the "s" off panel: Me.StatusBar.Panels(2) = StrUserName Just out of interest what is the thing for date and time but the time to continue to update automatically?
DCrake said: Which line is throwing the error? Click to expand... Sorted, you missed the "s" off panel: Me.StatusBar.Panels(2) = StrUserName Just out of interest what is the thing for date and time but the time to continue to update automatically?
DCrake Remembered Local time Today, 23:39 Joined Jun 8, 2005 Messages 8,623 Apr 2, 2011 #6 The date and time options are intrinsic and are updated automatically if one of your panels is using the time it ticks over for you.
The date and time options are intrinsic and are updated automatically if one of your panels is using the time it ticks over for you.