Search results

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

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

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

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

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

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

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

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

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

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

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