Search results

they punished themselves - it serves you right

I hope I didn't make a mistake in the brackets =[Forms]![frm_WeeklySafetyHuddle]![cboEmployee1].[column](2) &(", " +[Forms]![frm_WeeklySafetyHuddle]![cboEmployee2].[column](2)) &(", " +[Forms]![frm_WeeklySafetyHuddle]![cboEmployee3].[column](2)) &(", "...

the iif function allows you to have only 14 levels of occurrence, so implement 28 levels through a custom function on vba although it is possible to divide 28 levels into 3 parts (2 may not be enough) and make a double attachment

This is one of your databases – a form for filtering by 10 fields (highlighted in green) or you can add a checkbox to select Yellow entries should be protected from accidental correction When you click on the orange field – a detailed (full) display in the form of the selected record Send only...

apparently, it would form a text engine in HTML format for viewing in a browser

I would probably reduce the number of quotes by simplifying the expression SELECT ",2,4,7,16,27,35," AS Chuoi, IIf(InStr([Chuoi],"," & Val([C1]) & ",") >0,[C1],Null) AS A1, IIf(InStr([Chuoi],"," & Val([C2]) & ",") >0,[C2],Null) AS A2, IIf(InStr([Chuoi],"," & Val([C3]) & ",") >0,[C3],Null) AS...

I can't even remember when and in what program I used goSub, apparently in fortran in 1980, I definitely didn't use it in ms access I think goSub unloads the main part of the code from unnecessary details, but for other parameter values, you will have to write a new goSub the function does...

many years ago, when I was a young specialist, I was given a task to understand the program , it was spaghetti 20+ pages of 72 lines, which means more than 1500 lines - absolutely uninformative variable names like a1,a2,.....k1,k2 - in addition to the usual labels, there were a lot of...

I usually design such a code a little differently - 4 lines per search field, and any combination of fields, for numeric fields and date fields of the beginning / end of the period, there are small changes in the code (there are no quotes or there are #) moreover, only one boundary of the...

of course, these expressions are very useful, but they are very beloved and very difficult to write, especially for a beginner when creating a query even for analysis (error search), I often translate it into a structured view File As: IIf(IsNull([Last Name]), IIf(IsNull([First...

symbol 26(1A) It is put in place of characters whose values were lost during transmission. In CP/M and MS-DOS, it was used to indicate the end of text files and the end of data entered from the console (although the characters ^C and ^D were intended for this).

это как раз то, что ближе, чем 10 км по этому берегу реки или на другом берегу, прямо напротив, по прямой 100 метров, только вот мост через реку в 20 км

cross queries are different the following type is both sorted and selected TRANSFORM Count(Students.[ID]) AS [Count-ID] SELECT Students.[STREAM], Count(Students.[ID]) AS total FROM Students GROUP BY Students.[STREAM] PIVOT year([Birth Date]) in (2000,2001,2004,2005,2006,2007,2008); SELECT TOP...

apparently this is a variable tabular part of the contract and therefore the merge is not applied - only one of the 20+ software options

dim strWhere as string strWhere = .....

Private Sub Btn_Delete_Click() ''''''I had to recreate the form, also added a counter type field for tracking Dim I As Integer If LineNo = 0 Then MsgBox "No Record Selected !": Exit Sub If MsgBox("Confirm Delete " & LineNo & " Sizes ?", vbQuestion + vbDefaultButton2 + vbYesNo, "Confirm Delete")...

Private Sub Form_Current() ''''''''''' On Error Resume Next Dim name_subform, name_button Dim nomer_RGB As Long Dim nomer_subform As Long Dim NAME_TYPE As String ''''''''''' For nomer_subform = 1 To 6 name_subform = Replace("Position%1QrySubform", "%1", nomer_subform) name_button =...

Private Sub Form_Current() Me!Position1QrySubform.Form!Type.SetFocus If Me!Position1QrySubform.Form!Type = "Foam" Then Me.Btn1.BackColor = RGB(255, 228, 181) ElseIf Me!Position1QrySubform.Form!Type = "Water" Then Me.Btn1.BackColor = RGB(255, 0, 0) ElseIf Me!Position1QrySubform.Form!Type =...

didn't pay attention to the word number quote a quote for me is a long text sometimes ....

it seems that terminology and Google are not compatible enough for me, a quote is a long text from some book, a fragment of information for you is a link, a code to some primary source