This code called from a form field change event causes Access 2003 to crash. The DAO 3.6 is enabled.
Sub HideUnhideTable(txtTableName As String, bolEnable As Boolean)
Dim tdf As TableDef
For Each tdf In CurrentDb.TableDefs ' <--This statement crashes
If (tdf.Name = txtTableName) Then
If bolEnable Then tdf.Attributes = 0 Else tdf.Attributes = dbHiddenObject
Many tables exist in the database. Why would this cause Access to crash. 'Found nothing in M$ knowledge base.
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®.
Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…