Search results

It needs the query because your CreateQry routine assigns the result as SourceObject for the subform. I think most Access developers would agree that it's better to just create a form that shows all the records of this SELECT statement: SELECT...

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

The suggested unbound listbox offers that behavior. If saving the record by switching to a subform is not the behavior needed, you might want to consider deleting the saved record. Alternatively, an unbound form does not have a dirty property, but you would handle the saving process yourself.

I'll be creating a WordPress website in a few weeks, I could test a few plugins and let you know my findings. The occasions I tried using WordPress plugins for forms were not fun because they always seemed to charge for anything other than basic contact forms. But since most people use WordPress...

All hosting services are roughly the same. Here's how it works, basically: 1. You buy some plan. 2. You install wordpress. 3. You install some template and plugins. 4. You modify the template. Things in between include: 1. Making sure the plan includes being able to install wordpress 2. Making...

If I set the linestyle property of the treeview to tvwRootLines and set the expanded property to false to all nodes after they're loaded, you can. But they're still loaded, so... In my testing, I vaguely recall there was another property to show it collapsed, but I'm not sure if I'm confusing it...