June7's latest activity
-
June7 replied to the thread Relationships.Listing folders and subfolders - to what depth? Why are you trying to replicate Windows file manager? -
June7 replied to the thread Relationships.Your posted table presumes a single computer and one set of associated mapped drives. The_Doc_Man describes a parent/child relationship...
-
June7 replied to the thread Solved OpenArgs From SubF.CurrentRecord[FieldName].Not saying CONTROL cannot be referenced, saying a RecordSource FIELD that is not the ControlSource of any control might not be able to...
-
June7 replied to the thread Solved Why Some Calculated Fields Will Not Work In A Query?.As already stated, can reference alias (or constructed) field name in another calc but don't include the table or query name. So in...
-
June7 replied to the thread Solved Why Some Calculated Fields Will Not Work In A Query?.Use dot instead of bang. Why did you have bang (!) instead of dot? Query builder will use dot with fields. Plog's second point is...
-
June7 replied to the thread Solved Why Some Calculated Fields Will Not Work In A Query?.Actually, can use a calculated field alias name in another calculated field. Except for extraneous comma before FROM (which I removed)...
-
June7 replied to the thread Select Statement Problem.SQL definitely can't handle the embedded Column property (not in query object or VBA built string). Use parameters or concatenate...
-
June7 replied to the thread Inserting Dates.Why are you including spaces in that date construct?
-
June7 replied to the thread Inserting Dates.To extract year: Year(Date()) You want to add 1 to year and save 01 Jan 2026? Yes, why not include this calc in the INSERT action and...
-
June7 replied to the thread OpenQuery and TransferSpreadsheet?.Why are they opening query? How many records for 300 customers? Does Transfer pull from open object? I don't think so.
-
June7 replied to the thread Solved OpenArgs From SubF.CurrentRecord[FieldName].I just tested with Access 2021 (MS Office Pro Plus). Form still opens the "old way" - referencing field not bound to control as criteria...
-
June7 replied to the thread DLookup Problem.Most domain aggregate functions return a value if there is a match or NULL if there is not. DCount is the only one that also returns a...
-
I find error messages like "Expected bracket" to be quite useful in troubleshooting incorrectly written SQL. Not that I ever do write...
-
June7 replied to the thread Solved It needs a bracket.Parenthesis must be in pairs - that means an even number. You have nine parens - none of them are actually needed in that clause. Access...
-
June7 replied to the thread Passing form's Data to different forms in a project.With VBA, options for passing data between forms are OpenArgs, global variable, TempVar (macro can also refer to TempVar), one form...
