Search results

  1. D

    Nested Headers - Nested Subqueries/ Normalization Correct?

    Video linked for explanation. I have 7 different HeaderTypes. Which I need to be displayed in a continuous form; similar to grouping on a report. Do not be fooled by the apparent sorted order of the BillTemsF. It appears sorted because correctly because BillHeadersAndItemsT ID has been created...
  2. D

    Solved Good Resource For Learning Access SQL?

    A brilliant SQL resource on Youtube tachTFQ (great teacher) - BUT exactly how different is native SQL compared to ACCESS SQL? Richard Prost does not indicate a great difference & I would have thought semantically it would be near identical. Seems to have different datatypes, ∴ data-sizes...
  3. D

    Solved Maintain Recordset Updatable With SubQry Single Result Over Many Rows?

    What technique can be used when returning a single value used as the entire field in a qry (Field 3; populated by a subquery) whilst also maintaining an editable recordset? (SELECT TendersT.[Margin%] FROM TendersT WHERE (((TendersT.Current)=True))) I have no relationship between the tables/...
  4. D

    Solved Perils Referring To A Value In Listbox By Referring To Listbox Itself (Not .SelectedItems)?

    Everywhere I have read says to use the .ItemsSelected property of a listbox to obtain the value. Looping through on multi-selections. On a single selection listbox it seems that referencing the listbox itself will return the bound column value. Also if there is nothing selected it will return...
  5. D

    Solved Why Some Calculated Fields Will Not Work In A Query?

    Am I wrong here (usually am) - It seems in a query a calculated field (residing in that query) will require a subquery to be used if you reference the query name in the formula: AliasName: [QueryName]![CalculatedField1]*[QueryName]![CalculatedField2] Whereas if you reference the field itself...
  6. D

    Solved Display Less Decimal Point Accuracy To What Is Stored In Calculated Field Of Query

    I have deduced that I need to work to 12 decimal places on a double data-type on a calculated field in a query. I have rounded to 12 dp's in the calculated field within the query for the stored value. In the consecutive form I have set the properties of the control to 4 dp & Format as 'General...
  7. D

    Solved OpenArgs From SubF.CurrentRecord[FieldName]

    Activated by the SubF btn_Click event I am trying to open a childForm (not pictured) to a specific record using OpenArgs, from a field of the recordsource (not a control but a field which is not shown in the controls of the form). The form is based on a query (unsure if this makes a difference...
  8. D

    Solved Data Type Inaccuracies

    My problem is similar to a previous thread (unable to link SPAM warning) regarding a high degree of accuracy to adjusting fields (a fractional small number; a multiplier of another field [a currency data type]). The consensus seems to store the multiplier as a double & the currency as a currency...
  9. D

    Solved Grab Record From Another Frm?

    Off a previous topic which I thought I understood but don't - how can I grab a record from the sourcefrm & put it in the newHomefrm? I want to use a buffer variable & feed the ID to the newHomefrm without opening the form & using openingArguments. The sourcefrm will already be open. I want to...
  10. D

    Solved Normalization - Struggles In Access

    New to db design & really struggling with it. Watched countless tutorials; implementing seems far harder. Been told to avoid composite keys in Access as it makes hard work, which seems to cause violations but I really don't understand normalization. ResTypesT - Labour/ Plant/ Material/...
  11. D

    Solved Invalid Procedure Call Or Argument On Everything!

    Creating the most basic new blank form & putting a button with an event just to display a msgbox results in the error in title; nothing wrong with call-name or passing any arguments data types... It is much more sinister than that Code which worked fine is no longer working VBA Editor no longer...
Back
Top Bottom