Search results

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.

Thanks, was not intended as a critique, it was a post on a forum to try to fully grasp something. Yes it was a great solution & I am grateful; I have been studying it since you posted it trying to grasp what's going on. Modal - Only if the form is unopen it wall cause cessation of executed...

Thanks @MajP, not really what I spec'd in the uncryptic 1st post :ROFLMAO:. Don't worry about any more examples; I'm trying to learn all the ways to obtain a value. I was Moreso trying to implement your previous example (attached) but simplified. Not wanting to offend - I think you may be...

Thanks @MajP, too complicated for me to grasp that demo & our previous topic I don't want to have to filter selections from the source each time. I'll have the SourceFrm open each time at the area I want. I select the item I want from the Sourcefrm & it puts it to the NewHomefrm. A variable...

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

Obviously, just expressing gratitude for other help from CJ. Lost count the amount of times I've thanked @MajP