Search results
-
C
highlight an option label
I'm glad you got it working oxicottin. I knew you could do it. ;) . -
C
highlight an option label
For the search you want to carry out, I think you should create a Search Form. Based on items selected within the Search Form, create a SELECT dynamic query which will go against the tblMain Table and apply that query to the desired Report. . -
C
Setting Read Only Privlages for Users
Make sure the Cobo Box Control on Form is actually named: cboUsername and is not mis-spelled While in the VBA IDE, do a find & replace on the control name txtUserName and replace with cboUserName. What the code does is check to see if cboUserName actually contains something other that NULL or... -
C
Split User Input into 2 fields in DB Table
Just to point out the obvious for now....you spelled the Variable wrong in: Me.Target_Fault_ID_Suffix = Mid$(TxtContnet, 4) It should be: Me.Target_Fault_ID_Suffix = Mid$(TxtContent, 7) Notice I changed the starting point for the Mid function from 4 to 7? If you want to split the string... -
C
Setting Read Only Privlages for Users
If you want to fill the string Variable CurrentUser with the actual name of the Employee rather than the Employee ID then instead of: CurrentUser = Me.txtUsername.Value you would use: CurrentUser = Me.txtUsername.Column(1) This is how you access the Columns of a Combo Box. Column(0) would... -
C
Getting records to display in order
Try setting the Form's Order property. Put in he Table Field Name you want to sort by, like this: [MyTableFieldName] By default it will sort in Ascending order. If you want to sort in Descending order then you would enter: [MyTableFieldName] DESC . -
C
Split User Input into 2 fields in DB Table
If not already in Form, create two more Text Boxes. Name each of the two Text Boxes to represent the two Fields in Table you want this split data to go into. You can set the Visible property to No for each Text box if you do not want them visible i the Form. Set the Control Source property for... -
C
Split User Input into 2 fields in DB Table
Is the contents of this Text Box to be stored into to Form Fields on the Same Form, into the same Table bound to the Form, or into two fields within a separate Table altogether? To separate the Two items: Dim ItemA As String Dim ItemB As String Dim TxtContent As String TxtContent =... -
C
Subform Filter by Selection using multiple combo boxes
Glad it worked out for you John. The forum as a whole is here to assist you with whatever issues you may have with the development of your project. There are many many professionals here that can and will assist you. If you prefer a more personal approach to your project (and many do) then... -
C
Setting Read Only Privlages for Users
Yes....for that Database instance Yes....for that Database instance. Yes...I feel this is good way to keep track of who is or has been on the Database. Although this can get quite in depth (such as who is viewing which Form etc.), a simple Table structure might be: tblActivityLog (Table... -
C
Subform Filter by Selection using multiple combo boxes
Well John, here is your Sample DB back to (from one Sawmiller to another :) ) you and I believe it does the task you were looking for. Due to the complexity of the Query used to pull the data from, a Dynamic Filter was the definite way to go in my opinion, not the dynamic query string into the... -
C
Subform Filter by Selection using multiple combo boxes
Just downloaded your sample DB. Will take a quick look at it now. . -
C
Checking staff against booking date?
Use either the DLoopUp function or the DCount function. Either of those can tell you what you need. See Access Help with regards to these two functions. . -
C
highlight an option label
Read Posting #26. The reason is explained there. With regards to all you other questions, well, see your sample DB (slightly modified) attached to this post. I have also added a simple Time Picker Form to the Sample DB. You can access it by Double-Clicking on the Time Of Incident Form TextBox... -
C
calculating due dates in access
Basically all you are to create is a Search Form which should contain a Combo Box Control so as to select the desired Priority Level, a Text Box to display the Calculated Due Business Date, and a SubForm (in DataSheet or Continuous format) to display the Records found matching the desired Date... -
C
Option Group controls have backcolor?
When changing the the Back color of a Control in Design view, the BackStyle property should automatically change to Normal. If the Back Color is changed via VBA code then you will need to also change the BackStyle property. 0 is for Transparent and 1 is For Normal (Solid)... -
C
highlight an option label
Create a Sub Procedure within the SubForm code module and name it SetBodyPart. In this SetBodyPart Sub Procedure you should have code like the following: Private Sub SetBodyPart () Dim V as Integer Call ClearBodyParts V = Nz(Me.optNatureAndExtentGroup.Value, 0) If V > 0... -
C
highlight an option label
This is because the Option Group is Nulled (cleared) before the Text ForeColor and the Background Color is changed. When the optNatureandExtentGroup Option Group Control is Nulled to clar the Radio Buttons, the optNatureandExtentGroup.Value is set to Null which in turn does not properly fill... -
C
Setting Read Only Privlages for Users
In a quick nutshell..... Create a global database variable, let's say: UserPrivilage. To do this, open an existing or start a new Database Code Module (not a Form Module). Under the Option Compare Database or under the Option Explicit if it exists (if it doesn't....it should), enter tis line of...