Recent content by Edgar_

There is already notable interest in OP's solution. Many members of the community have shown some level of interest in seeing it in action and experimenting with it. In fact, if there was no interest, we would not have made it to page two of this thread. The idea behind it seems solid. Many of...

Based on previous talks with OP, I think the method is using unbound forms with many unbound controls each. On form load, OP maps some table to the unbound controls and hides unused controls. He then attaches common behaviors to the controls in use. I suppose the tables contain the metadata to...

I'm not really sure about the whole point of this exercise, please forgive me for that. Anyway, watching the replication id field from a recordset returns this: {guid {4384FD92-A138-4F05-A2F7-129B6F3C49E7}} And when I open the table, the datasheetview form used to visualize the data shows the...

You're exporting the table to Excel, not creating any link. The data exports as is and won't ever change automatically. Excel should be fetching the data in one of the many ways there are. Simplest of which is: Data tab > From Access (Get External Data group) > choose table > choose where you...

That should totally work. That said, the problem is probably that the value of PINCOUNT isn't set when the OnCurrent event runs. How are you populating the thing? I assume you're doing this, are you not? Private Sub Form_Current() Me.PINCOUNT.Value = Me.Recordset.RecordCount If...

So what did BS (mod edit) do apart from trying to dox people here?

Hello, @JPR I did my best to understand your intent, and I created a database schema with a form and queries that match your request. The data I used is completely fictional, but it should still help you understand the structure and adapt it to your real dataset. Based on your code, I did not...

I trust Richard.

Try this code: Private Sub cmdsearch_Click() Me.lstsearch.RowSource = "qry" & Me.cboQueries.Value Me.txtsearch = Null Me.txtsearch.SetFocus If Me.lstsearch.ListCount = 0 Then MsgBox "Sorry, no records were found.", vbInformation, "Test Search Menu" End If End Sub...

I think he's asking for a section to ask about the debugger, debugging tools, debug practices, etc.

I cannot test it myself, so I cannot say for sure what you are encountering, but it seems like there is something off with how you are approaching it. Instead of waiting for the page to be fully ready, I would recommend testing for the existence of an element that is expected to render. In your...

You should use a watch to check when the state is changing, the state can change for many reasons, so you should verify that it's not stuck trying to do something it can't do at that point. I can't replicate the issue as the Edge browser control is not available in my Access installation, but...

I believe that post needs moderation. smh EDITED by TDM: 11/26/2025 9 AM CST (GMT+6): Original post was edited; quote of that post that contained the offensive language is also edited.

Try twinBasic for your add-in. By the way. It has a template. Good luck finding resources though, luckily, it supports VBA and VB alike.

Who are you referring to as someone who cheered for censorship? be direct and assertive, dude.