Search results

For tables you can consider Application.ExportXml / ImportXml.

But what if "controlname" refers to a non-existing control? I would only find out at runtime that it does not exist. I think Me.controlname is better, because it provides compile-time checking (as well as intellisense).

Labels don't have a Value property.

When the error occurs, in the Immediate window: ?ctl.Name I bet you it is a control that does not have a Tag property. Long shot: Maybe you have another Reference with a Control or Controls object. Change your code to: Dim ctl As Access.Control Also, do you have Option Explicit at the top of...

Total_Sales should not be a field in a table, but a field in a Totals query, so it can be calculated on the fly, since sales change all the time, and regions may sometimes change as well. As an example of how to do it correctly, take a look at the Northwind Dev Edition sample database...

select * from myTable where InStr(Postcode_Areas, "TN25") > 0 As you are finding out, this is a gift that will keep on giving, until you normalize the database design and spin off the postcodes into their own child table.

Nice to see you here. Welcome!

This helped me today. I needed to resize subform controls, and subform's Report_Open is too soon - the data is not yet available. Report_Load does not fire. Moved the logic to parent form's Report_Load and all is happy.

What would such combination be called in one word? Remember - like Brangelina?

Nice to see you here Rob. Welcome.

You still can manage TLs yourself, because they are in HKCU. On my machine with A365-32: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations There may be additional ones under HKLM, which may be locked down for average users.

> I recall running into some friction with use of the AutoExec macro due to IT policy changes. You may be thinking of File > Options > Trust Center > Macro Settings. The typical setting is "Disable all macros with notification", which is how I run Northwind. Then why does AutoExec macro work...

The startup form is not used much by professionals. We typically use the pattern you also see in Northwind 2 Developer Edition template: AutoExec macro has one Action: RunCode, and it calls a function in a standard module. This function would typically check several things (such as if the...

This is not possible with forms, unless you go to extremes.

This asks the question: is the combobox unbound (not connected to a database field) or bound (connected to the selected field). Often the second option is the correct one, because comboboxes are often used to select an ID value, while the user is looking at Text values. E.g. the dropdown has a...

This link opens generic page for me, not specific comparison text. I found my link at the bottom of the chat.

I asked an AI: "To a Microsoft Access developer, what are the main differences between MzTools and RubberDuck?" It gave a lengthy reply, which you can read here. In summary: Both tools improve the VBA development experience, but they come from very different philosophies. MzTools is a...

My gut tells me that it should be possible to have the line number for each stack frame (assuming there are line numbers like in Northwind). The Northwind Dev edition clsErrorHandler.HandleError does it a different way, requiring passing in of ModuleName and ProcedureName into HandleError, but...

I have the free Ditto app running to capture clipboard items.

It's pretty easy. Search phrase: "how to create a web service endpoint using REST api". I would stay away from SOAP and WCF - too complicated for your needs.