@M.Doerner I do not know what a typical Excel codebase look like but in Access, we find ourselves reaching out to many external components since it acts as the glue to bring together disparate components. Which implies that if the external component is written in .NET, python wouldn't help us any.
So I can still assign a date to a string variable or string to an int variable, and it'll run happily until something actually expect the value to be an int or a string instead of whatever it is.
More recent languages do support some type-checking, anyway.
@this That's the whole reason they don't work, TBH. The program just dies with a stack trace.
but it annoys me when people conflates Access with database -- it's actually both a RAD tool and database rolled in one but you don't have to use database to use the RAD
I have a button that calls a function that then processes hundreds of records. I want it to happen but not keep the user from doing other stuff in the meantime.
@this It runs through each record in a table and runs 4 queries to determine what needs to change on that record, and then makes the changes.
Basically I'm caching data about each record so that when I need to load the record later it can get the info directly from the table instead of running the additional queries at that time.
I'm really not a fan of my implementation but it's my best idea yet.
if it's any appeasement, know that because the hoodie says "CANADA" in big bold obnoxious white letters, I'm not allowed to wear it - only to pack it with me for next MVP Summit :)
@MathieuGuindon No appeasing, we just don't want you getting slain by some oddball space alien that looks suspiciously like an earthling in tinfoil and bubble wrap with some green body paint.
btw (back on topic) Access has long been leaving a hung process when otherwise appearing to shutdown correctly. This time, I happened to notice that I keep getting an VBE window showing up with my phantom MSACCESS.EXE process.
I don't think I've ever noticed that before, though it's possible it's been there in the background and I've not seen it before it disappeared when killing the task
@a3k4 I think @FreeMan's spot on, post on CR to give more meaningful feedback. Hard to give a good advice without the implementation. The only concern i have is that you are apparently looping a recordset then running 4 queries - I'm sure they can be done in a single query, dumped into a temporary table for caching, rather than looping. Looping mucho slowo
Is there a way, in Excel 2016, to get an MDI interface? I don't see the value (even in a mobile/tablet environment) of seeing the ribbon on the top of each workbook I've got open when I'm looking at two different ones arranged horizontally. I need to compare data in the two, not see the exact same ribbon for them both.
Seeing one ribbon in 2010 worked perfectly well and left more vertical room to look at the actual data in the workbook.
Multiple Document Interface- I think that's what it's called. In Excel 2010, you get one Excel application window and within that you can open multiple workbooks. You can tile or arrange horizontally/vertically or have each "full screen" within the application window.
A multiple document interface (MDI) is a graphical user interface in which multiple windows reside under a single parent window. Such systems often allow child windows to embed other windows inside them as well, creating complex nested hierarchies. This contrasts with single document interfaces (SDI) where all windows are independent of each other.
== Comparison with single document interface ==
In the usability community, there has been much debate about whether the multiple document or single document interface is preferable. Software companies have used both interfaces with mixed responses....
Also, a while back there was discussion about RD configuration settings and whether/how to show the user had set something different from the default RD ships with.
Firefox still does this:
and I don't think it looks all that horrible as I recall someone mentioned. Seems pretty reasonable to me.
@M.Doerner - thanks. :( haz a sad. Of course, Uncle Bill (and his minions now that he's no longer in the day-to-day) know best. There's no possible way that having all the extra screen real estate taken up by a second copy of the ribbon (even when it's minimized to just a menu bar) would bother anyone.
There are various cells that, if populated, they cause a non-default value to be used. Is there any issue with meta-programming to check for any namedranges with override in them to be cleared for a ClearOverrides button?
you want to loop through all your Named Ranges, check the .Value2 of each, and do something if .Value2 = 'Override'? Don't see a problem with that, but you'll want to be sure to handle Named Ranges that are larger than one cell.
@M.Doerner oh, and I could do that before by starting a second instance of Excel and opening a 2nd file in it. Do it somewhat regularly here at the office.
I have the cells as NamedRanges. I'm rubberducking about any possible issues of doing
Sub ClearOverrideCells()
Dim clearName As Name
For Each clearName In Me.Names
If UCase$(clearName.Name) Like "*OVERRIDE*" Then
clearName.RefersToRange.ClearContents
End If
Next
End Sub
Btw, it is really annoying that the WinAPI always thinks that you want to maximize on the monitor on which the largest portion of a window is painted instead of just using the one where I double clicked the caption.
Your code seems reasonable so long as you account for multi-cell ranges. Remembering that just because there aren't any now doesn't mean some nimnod user won't add one in the future.
I store everything in my inbox in Outlook and separate my mail with Search Folders. My main folder I work out of is a search folder called "Follow-up" which only shows me unread mail.
I would like to create a simple Macro that runs in the background so when a massage gets marked as read it ref...