Search results

Will the specification of the Decimal data-type apply to all calculations wrapped inside the Decimal data-type & each calculation inherit the accuracy specified by the parent Decimal type (26 decimal points in e.g.). I'm hoping it does because I have complex calculations which I do not want to...

In Access I used a composite index of 2 fields, but unsure best option in MSSQL for performance to avoid a duplicate record of the combination of the 2 fields? In the child table (relevant to topic) I have a foreign-key & a normal field. I think I have 2 options? Composite Index like in...

EDIT - On closing & reopening MSSQL the changes have taken effect fully. I can handle the 4 FK constraints manually; that's no big deal but would appreciate if someone can help in doing this for PK's? After importing to MSSQL I want to convert certain FK's/ PK's data-types. So need to drop all...

Silly question - how does one determine the existing join-type between a table-relationship from the Diagram-View in MSSQL 2022? Also can't see any indicators in the Table-Design itself. There seems to be a bug in double-clicking the relationship line does not open the relationship (articles...

Can anyone recommend a good book exposing common pitfalls...? I'm a complete novice in both Access & Azure. Seems that using an ODBC connection in MS Access exposes passwords... in the registry.... Also as I still have not finished my application which I am planning to sell as an .accde & Azure...

I have Option Explicit & Option Compare in ALL code behind forms, modules & classes. But I receive no highlighted prompt where the error occurs. I thought I'd solved it a week ago but I keep receiving it on compiling. Pretty sure it's not reference related as I've not changed anything there...

Built a simple testing form; in a separate db to obtain what the keys should be As per Richard Rost. Trying to assign KeyDown/ KeyUp the form itself one or the other: Seems ctrl-delete = Keycode-46 & Shift-2 Frm - Key Preview = Yes The KeyUp event is detected but I cannot generate/ detect the...

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