Search results

the quote is usually quite a long line , it may need to be moved to additional lines - this does not agree with the list the second remark is that rarely anyone remembers the exact order of words in a quote, which will greatly reduce the chance of finding what is required if there are not 10-15...

the list is clearly not suitable for this search, it should also be a continuous form

At a minimum, I would filter by the fields that you know (including by a fragment of the value, in continuous form by the client companies phone time interval (for example, 2022 or the last 2-3 years or a long-ago interval before 2010) type of work .... And only then by the text of the...

if you specify med12 in the search field, med1 will not be selected if you specify med1, then mad11 and med12 and med 13 will be selected next, a visual selection of the necessary sometimes you can vary with asterisks med1* all combinations starting with med1 *med1 all combinations that end...

and of course I use the GO TO operator to simplify the web from IF .... END IF by going to the end of a loop or procedure

my main rule of code formatting is that the string should be fully visible, so 1 - I rarely use the line continuation character (underscore) 2- I use minimum margins (no more than 1-3 2 spaces each) 3- I use the short names s1 and s2 as temporary working lines when forming a long line, so as...

there are no nested IF ...END IF in this code, only 4 groups of 3 lines, and this is the modified code of the author of the topic I just fixed the errors, made the code work

I prefer to separate blocks of text with empty lines - it's much clearer of course, I also use margins, but no more than 1-2, so that the line of code does not go beyond the boundaries of the screen

filtering is more convenient to do in a continuous form 1 -green field - search terms by code 2-time - you can add a filter for other main fields 3- yellow -data is protected from unintentional damage red symbols in the first field - output to correct the selected record, you just need to CLICK...

apparently the system font is damaged on this computer

the most problematic part of the code and incomprehensible 'The main loop per record Do While (Not Xl_qry.EOF) 'find Sharepoint "Long text" table index LngTxtIndexFnd = True With tblLngTxt .MoveLast Do While .AbsolutePosition > -1 If Xl_qry!ID = !ID Then Exit Do 'Record found If...

Query TEMP00 SELECT w.Progress,"1 EstimatedPrice" as typ,column, nz(w.EstimatedPrice,0) AS sum1 FROM ProjectYearToIntQ AS w union all SELECT w.Progress,"2 ProjectCost", column,nz(w.ProjectCost,0) AS sum1 FROM ProjectYearToIntQ AS w UNION ALL SELECT w.Progress,"3...

Progresstyptotal1234567 D-1 EstimatedPrice568151.61568151.61 D-2 ProjectCost00 D-3 EstimatedPrice-ProjectCost568151.61568151.61 E-:1 EstimatedPrice12818301281830 E-:2 ProjectCost942208.43942208.43 E-:3 EstimatedPrice-ProjectCost339621.57339621.57 F-1 EstimatedPrice91720209172020 F-2...

maybe I don't understand something, but such a form name is hardly reasonable Forms![Form: Tab Page]![TabName]

in such forms, I search for an arbitrary combination of the main fields (department, cabin,service number, surname, first name, position, city, ........- for all the main fields of the table / query), I highlight them in a ribbon (tabular) form for visual final selection when you click on the...

renamed RAR archive NgayTmaxT1T2T3T4NgayT1T2T3T4 10-окт-2163221310-окт-213252629 13-окт-212320143210-окт-214262730 15-окт-215584310-окт-215272831 17-окт-219489110-окт-216282932 20-окт-2155424713-окт-2120343739 22-окт-215321313-окт-2121353840 24-окт-2176232113-окт-2122363941...

Public Sub Reset() Dim txtCID As Variant 'txtCID.Value txtCID = AutoNumberReturn("tbl_Customer", "CID") Me.CustomerID.Value = AutoNumberReturn("tbl_Customer", "CID") MsgBox Me.CustomerID.Value & " or " & txtCID End Sub

yes!

it seems like all the brackets are in place with pseudocode it can be written like this NULL means the field is empty, not filled in If [Last Name]=null then If [First Name]=null then kupfile=[Company] else kupfile=[First Name] else If [First Name]=null then...

you have blocked the output of warnings, so you do not know the result of the request