Search results

Thanks Dave, it was merely a test in trying to understand what's going on at a basic level. Surely on something so basic it is capable within the Access Query Designer itself & not necessary to alter the SQL. Grateful for the input & I can see what's happening with the SQL but I'm trying to see...

Thank you both for your input. Creating a simplified test this morning (attached); calc'd fields in CAPS with a simple e.g. AREA based on tbl values & VOLUME dependant on the query result: @plog thanks for the detailed explanation. I must not be following you completely as if I'm interpreting...

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

It's tempting to hide behind the more technical issue & save face. But I have to be honest - I was referencing the field incorrectly of the record source. Got very confused with sub form referencing & I don't even think it was needed. I was not referencing a control on the form as I'm trying not...

Thanks Pat, sure enough I missed something :p.

Thank you both for posting & especially the explanation of how it works. I lost a lot of time trying to figure out how different ones worked & found tutorials out there to be scarce/ hard to find. Even the basic fundamental of transferring a value from one form to another I found confusing &...

Thank you all @arnelgp I recon that's what I'm after. Interestingly the first few times i tried it I was unable to change this way then all of a sudden after several attempts it allowed this change. Format Function - I'm probably missing something here, but just testing the format function...

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

This is not an isolated incident; I am experiencing the exact same issue in March 2025. I will not hijack the thread but wanted you to know you are not alone.

Thanks so much @Edgar_ & @Uncle Gizmo .

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

Astutely observed; I was referring to data-type conversion only so kudos for recognizing this on such limited info. Sounds like VBA is quite different to other languages in this area. Interesting, I would never have figured that out. If I'm interpreting this correctly (I'm not going to try this...

Sorry - what about the data type for a calculated field in a Query? There does not seem to be the Field Properties available? One could think that an implicit Typecast occurs dependant on the data types of the info used in the Query, but I would have thought this is quite dangerous & the User...

Fascinating topic which I always wish I understood but did not until now thanks to you both. Thanks @Minty, I did not comprehend that the accuracy would be limited to the surprisingly small amount of significant figures, quite interesting. I would have thought that there would be linked...

Thanks Minty, I am in disbelief as to the lacking info on accuracy on MSN. Managed to find 'Set The Field Size' on MSN under Access > Tables > Creating Tables > Set The Field Size. Hopefully helps someone out in the future (can't link as lacking privileges). I must be wrong here because in the...

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

Thank you very much, grateful of another method of pulling values & no events behind it, very effective.

Thanks, I'm altering my design to accommodate & you're making me aware of things which I've not accounted for; like 2 forms open at the same time which I'm changing & am most grateful for. I wouldn't even be able to load the form if it wasn't for yourself so mega thanks.

Thank you for your comments, agree completely. Sorry @MajP I should've questioned if I could remove the subform in the other post rather than poorly wording it here & don't doubt your way is the best way & have implemented all your suggestions. Big thanks for all your help.

No - I reiterate as my previous post was unambiguous - doCmd open ACDIALOG an existing already open form (main topic of post) you'll see it does not stop execution. AGAIN I reiterate - you have to close the form, then open in ACDIALOG. Using an open form was the main topic of the post.