Search results

If you are starting out working with custom classes, note this debugger setting... If this is not set, the debugger will not break at the error in your custom class, it will break at the line making the call in the consumer.

You can also try to decompile the program file first, before doing a complete rebuild, and see if that makes a difference. During development I fairly commonly get the same crashy kind of behaviour you describe. I keep a shortcut on my desktop with this as the Target... "C:\Program...

You can force data validation in cells. Check out ribbon path: Data->Data Tools->Data Validation. This opens a dialog that lets you pick various formats, including Time. A time range is required, so you can do Start=0, and End=23:59:59.

If you start MS Access from a shortcut, the value of the shortcut's "Start in" field may override your MS Access File->Options->"Default Database Folder" setting.

If the United States is in decline, it is because you have lost respect for each other, and you would rather see the other side lose, rather than work together for a shared win.

Neither party is talking about paying off the debt as a national priority. This is a systemic problem, not a partisan one. The biggest problem in the US, the way I see it as a Canadian anyway, is that all your hyper-partisanship is getting in the way of you solving actual problems. Republicans...

Beaucoup bienvenue.

I would never rely on data previously loaded into ListBox columns to perform an operation that matters. A ListBox is for selection in the UI. The format of the data it contains, if it contains anything, will all be strings. This is prone to error, as you are finding, and subject to change...

Private Sub cmdExecuteSpec_Click() CurrentProject.ImportExportSpecifications("SpecName").Execute End Sub

The question you ask, can Access VBA read formatted data from Excel? Yes. What matter though is how. Maybe provide an Excel sheet with a demo of the data and formats you actually encounter. A solution is going to come down to understanding the very precise details of the actual problem.

You don't need to load the ribbon programmatically, you need to show/hide its features programmatically. Here's a fast and dirty sample of how it could work...

Say you need 5 ribbon tabs for one application state, and 5 completely different ribbon tabs for a different application state. Define one application level ribbon in USysRibbons with all 10 tabs. Then selectively show/hide the ones relevant to the current application state. How will that not...

Ribbons defined in USysRibbons load automatically, so there is no need to load them programmatically, or to close and reopen the app to do so. Alternatively, you can load a ribbon using the Application.LoadCustomUI() method, but then you need to pass in the Name and the XML as strings. To manage...

Horse is thirsty. Horse is led to water. Horse was instructed not to drink. Horse remains thirsty.

You can just use one main ribbon, but programmatically show/hide different tabs. Tabs can execute a GetVisible callback method, and show or hide themselves based on changing state--apart from any form--in your application.

Also, an easier way to keep track of a list of stuff--and not have to ReDim an array and keep track of an index--is use a collection. Dim col As New VBA.Collection Dim rng As Excel.Range ... Case dbDate Set rng = Sheet1.cells(r, C) If Not...

A time value that has no date component will always be numerically < 1, so you could write your own IsTime() function like... Function IsTimeOnly(vTest) As Boolean Dim d1 As Date If IsDate(vTest) Then d1 = vTest IsTimeOnly = d1 < 1 End If End Function

Don't choose course of action based on difficulty. Choose course of action based on desire. My observation based on various posts I have seen you make is that you are curious as hell about OOP. So feed your curiosity. Mastery is difficult. Mastery of the difficult brings immensely...

The oldest code I can find in my Library file was written in 2004, so it's not super new.

I distribute my Library file as a companion to the FE, so each user has his own copy.