Search results

in my first database there were 2 tables (5000 records and 15000 records, М:М) the initial size is 5MB after running the query 75MB once it did not condense, after several runs of the request it received 1400MВ then I couldn't compress it - the computers were weak then, there was a good archive

I prefer filtering by all the main fields, and both by part of the value and by the interval, and not all fields for the filter can be set at the same time, spaces, apostrophes, ampersands in text fields, different character styles (superscripts) are also processed starting the filtering...

tblName = "TableA" fldName = "User ID" sqlStr = "SELECT [" & fldName & "] FROM [" & tblName & "]" & _ " WHERE [" & fldName & "] = '" & rs1.fields("Username") & "'" Set rs1 = currentdb.openrecordset(sqlStr)

in the subordinate form, you can add fields 1 who left a note 2 when 3 set the sorting of comments to set their subordination

I use it quite often. the pink zone is a zone for filters for each field (there are 12 of them here), according to the format of the fields, strictly above the fields , the yellow zone is closed from accidental damage , the green zone is the zone of the active memo field, for correcting or...

what is the maximum length of the text 1- if up to 1000 characters and 1 paragraph, then you can highlight it in a new window for correction 2- if the text is longer or several paragraphs, then I prefer a subordinate table (the fields can also be by, but it is more convenient to adjust the line...

if this is ACCESS, then you can put the number in a separate column, although this work is of course for the WORD template, the bookmarks of which can be filled programmatically a long MEMO field can be divided into paragraphs and put a subordinate table

expr1: DateAdd("M", 24, [Overview Tbl]![Installation Date 1])

it is not clear what you need - to count and lay out several dates possible dates=2022/02/01 will be dates with a periodicity of 24 or 2 months 2022/02/01 2024/02/01 2026/02/01 .... or 2022/02/01 2022/04/01 2022/06/01 ....

apostrophes and ampersands are not allowed in names as spaces and other separators

try this, splitting into substrings for clarity, for the forum =DCount("[strID]", "[tblMaster Table]", "[datDate Application Received] between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31) And [strStatus of Application] like '*Denied'*")

I'm almost sure that if I buy beer 2 times a day, one of the records will be lost

the VBA code must be destroyed A FRAGMENT OF THE SEARCH CONDITION IS TYPED IN THE GREEN FIELDS pink - start and reset the filter

what macros can access - open/close forms/reports - make a launch/menu ribbon - - the dynamic filter will probably also be able to, very much beloved, but it can do - export requests (although I had problems the other day) what can't or is unlikely to be able to (potentially dangerous...

this string searches for the first string with the value of the word Select DoCmd.SearchForRecord , "", acFirst, "[tDeptAbbrv] = " & "'Select'" you will not see the second and further, as well as the rows with the value Select 1 or Select2 to see all the lines with the word Select*, you need...

any book has - author or authors - publishing house - year of release - book code ISBN - subject - abstract - type of publication - storage location ... and there have always been classifiers for searching these fields since paper times access does this very quickly, and for any combination of...

I think that the records should be sorted sheet 1 - 150 minimum, 3 columns from top to bottom sheet 2 - the next 150 last sheet - the remainder, for example 3 columns of 10-11 values moreover, the values can be longer than 10-12 characters, 150 last name + first name may not fit on the sheet

maximum of 14 nested

insert into data( recordingDate,rainFall ) values(#10/19/2020#,1.054527) insert into data( recordingDate,rainFall ) values(#10/22/2020#,1.282499) insert into data( recordingDate,rainFall ) values(#10/22/2020#,5.367941) insert into data( recordingDate,rainFall ) values(#10/29/2020#,5.44014)...

I always use a ribbon form with the main fields of the table/query 1 -the headers are fully visible (multi-line) 2 -green search fields strictly above the data fields 3 -you can set the selection conditions in any combination, usually equality, Like(contains) or interval 4 -I don't let the user...