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...

for the subordinate form, these lines will change 'Finally, apply the string as the form's Filter. Me.Filter = strWhere Me.FilterOn = True

I did not find a subordinate form, you simply do not have it, there are not even subordinate tables

your first base is working, but I fixed it a little so that I couldn't find the value of the subordinate form

Private Sub cmdFilter_Click() 'Purpose: Build up the criteria string form the non-blank search boxes, and apply to the form's Filter. 'Notes: 1. We tack " AND " on the end of each condition so you can easily add more search boxes; _ we remove the trailing "...

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...

an incomprehensible approach to the CONTACTS task , instead of filtering by last name, first name, job, phone code/ number, maybe you used a page view by note

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 = .....