Search results

How does one protect against multiple records being selected on a subform? Current Event - if multiple records are selected it will not recognize Record Selectors Property - would be handy if it had a collection of the currently selected records but does not seem to have Situation The subform...

On math heavy queries what is the best way to handle titled? Was advised that other db systems would fail on a calculated field which obtains it's value from a calculated field defined in that query. So I'm not doing that. In an ideal world this makes it much easier but I will want to use MSSQL...

I have a PopUp Form containing two listboxes (the control I refer to is the child listbox). Parent listbox has no multi-select property; child listbox (in question) mutli-select (simple) & an optionGroup (irrelevant) with other irrelevant buttons... MouseDown event assigned to a txtBox in the...

Trying to learn Implementation Classes & Class Factories - Parameterized Object Initialisation from this great tutorial,but I get the pic'd error & I can't see where I'm going wrong? I've Predeclared the classes as per tutorial. I'm just before he turns it into an Abstract Factory. I also tried...

Sorry to hog forum. In a subform (datasheet) I have a calculated control; which obtains it's vale from a function placed in a global module. First value produces #Type! in the calculated control The calculated control is not processing the first record. Has anyone experienced this sort of thing?

Faster solution on a single-user system where records increase by around 20k per week. Will be going to a multi-user system where that could be around 100k per week (but that's an idea atm): Select Query on 10k records based on a parent query to restrict the amount of items or Seek on Millions...

I want to assign parameters to an action query. I'm trying to avoid doing it by altering the querydef.SQL property in VBA. It would be much nicer to do it in the below fashion but I'm struggling with the syntax of the last two: SortOrderAdjustmentToMake should take the values in the query field...

I have some Properties (around 30; most are typical assignment format). Some values are assigned by procedures/ routines inside the Property/ or called. I'm probably going to get told off but these are quite intrinsic values to the class object. I would prefer to call a function to keep the...

Class-A instantiates Class-B. I need a subform (outside of Class-A & Class-B) to gain access to the instance of Class-B. How do I get a pointer to the instance of Class-B? I could create an object variable of Class-B inside the subform but this would create a new instance of Class-B (undesired)...

When I go to debug I'm getting "This action will reset your project, proceed anyway?". The problem occurs in a certain sub-form, with classes & user-declared events... My code is running fine, but this does not seem good practice; or am i being pedantic? I've stepped through code looking at the...

I have a class for a Subform; trying to encapsulate all relevant things. The MouseUp event (assigned to the class) deletes & builds a relevant right-click context menu. But if I place a Public Function InsertPageFromABill() within the class to handle a button in the Command Bar it is not visible...

Is it not a waste of space; causing unnecessary scrolling & wasted time in making it appear so tall. Not the end of the world, but myself personally think it would be better if it was a normal post size; shrink-wrapped css. Says how well designed the forum is if this is my only gripe :).

I wrapped all textboxes in my frm.description in a cls to assign a right-click CommandBar menu to all textboxes to save me doing it individually. Then added them to user-defined collection so the right-click event would stay around. The trouble is I was playing around with the cls names &...

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