Recent content by Edgar_

Technically, the focus is set to the control regardless, you just can't see it because the subform has no focus yet. However, it's true that in most scenarios, simply setting the focus to the control won't immediately allow you to work with the recently focused control. So, I stand corrected...

You don't need to set focus to the subform first, like you seem to be trying to do here: [Forms]![PatientAdmitanceF].[PatientNotesSF].SetFocus [Forms]![PatientAdmitanceF].[PatientNotesSF].[Form].[Pnote].SetFocus You can simply use the second line...

We should all agree that overpowered procedures are the heralds of inferno, only Satan thrives within them.

For web development, choose a stack and a database. So ask the GPT this: 1. I come from ms access, show me some frontend/backend stacks to start with web development Regenerate the answer multiple times. You will notice a pattern that will help you see what is the most used out there. Then, to...

This ☝️ I used to write them all at the top because that's what most people did. Then I went to .NET and I enjoyed declaring and initializing at the same time, so I started doing it in VBA. However, I follow some rules as much as I can: - It depends on the length of the initialization, but if...

I think what we're experiencing with PFG is a good example of the Golden Hammer analogy. They want to do everything with a tool that might be limited for that, or might introduce additional hassle. I've used Power Query - another Power Whatever Tool - for HTTP and while I do get some results...

It will be ready soon, just give me some more time 🤏 Thanks a lot!

Thanks, John, you guys helped me a lot. I'll be uploading the talk with some postprodution in the following days.

La reunión está por comenzar, los espero ahí, muchas gracias! Link de zoom: https://us06web.zoom.us/j/85235927405?pwd=FsVY4qeVz1Gi7iLlNSIAAYygBD1arW.1

Thank you all for the encouragement, tips and the help. I really appreciate it. I hope not to stutter too much ;)

Done. Thanks for spotting that, Colin. Hope it's done in real time, if not, I will add the subtitles myself once it's ready.

English version included below. Buen día a todos. El capítulo de Latinoamérica en Access User Groups se reactiva para la comunidad de desarrolladores de MS Access de habla hispana en la región latinoamericana. La reanudación se llevará a cabo el día 25 de abril, a las 9:00 pm, Ciudad de...

OP, you're trying to drive a tank to the lake to attempt to catch a fish with a 20m x 20m fishnet. You would ease a lot of the pain by letting Access do the Recordset stuff and letting Word do the reporting. Use a Word template and populate it using the Find & Replace method (not the bookmarks...

You can use this forum's default color palette. You could also make your font sizes and text alignment more consistent, it's all over the place in the top/bottom part, headers are too small, records would look nicer if they had some padding, etc.

@MajP Thanks for sharing your dataset for testing. You have made a very educational demo. I don't know how much of the existing code is a part of the tree view examples, but it seems like a challenge to try to evaluate right now. I did make tests with the three versions. Light recursive load...