MCVE:

Public Property Get Foo() As Access.Form
End Property

RELOAD!

[rubberduck-vba/Rubberduck] 19 commits. 4 issue comments. 42780 additions. 20231 deletions.

save as a class, then implement it another. Say good bye to the editor as it's now bricked.

well changing the return type to object seems to unbrick it, though.

Really bothers me it behaves like that. Wonder if it's different symptom of same bug. IDK.

@this weird. How about Public Property Get Foo() As Form_Foo?

I'm working on my FRMFRX parser, and thinking about the serialization. I think I'll add an encodeBinaryAsBase64 argument, and then binary gets encoded as an in-line base64 attribute, otherwise, the binary (for known binary properties) gets extracted as FormName.ControlName.ControlIndex.PropertyName.InferredFileExtension

@NelsonVides Just the concepts presented in the first 20 mins was worth it for me. Thanks for sharing.

@Mat'sMug @Mat'sMug Do you have a tentative time for when you'll be able to publish this?

@IvenBach I'm guessing once he releases a working product...

I look forward to it. Since I'm better understanding things I'm rethinking how I have nearly all my macros in my PMW (Personal Macro Workbook).

Being able to unit test them for breaking changes is one that excites me the most.

@ThunderFrame no problem implementing a custom form.

the only difference besides the obvious fact that custom form will expose its controls earlybound is that it doesn't source events (you have to use the Access.Form interface to listen to the built-in events).

but not sure that helps because interface implementations don't give a hoot about events.

The more I use the code explorer the more magic it seems filled with.

@this This seems to work:

Public Property Get Foo() As Access.[_Form]

although you have to manually edit the return type when implementing the interface

strange. I did try that but didn't work. let me check again

nope it didn't, @ThunderFrame

even though I typed it by hand

How did I miss that link all this time

@this, admittedly, a little too simple an example?

Nope, doesn't work....

it's very weird

@Mat'sMug, the author apparently didn't figure the trick that @ThunderFrame described, though.

the other weird thing is that I earlier said that changing object will unbrick the VBE

and that worked 2 times, but other 2 (including just now), it's still bricked after the change.

something not right under the hood.

BBL

@this I have production code hanging on the back of the workaround

@this, if I type out the entire implementing class manually, it compiles just fine, but if I use the codepane dropdowns, it introduces the "User Defined Type not defined" message. And that message doesn't go away (regardless of the edits I make) until I remove the class, and reimplement. i.e. I suspect that something about the codepane dropdowns is corrupting the class.

that's what I saw and suspected but as I mentioned, the last time I typed it all by hand, and still got that error. I'll try that again.

If that is the underlying cause, then AvalonEdit/RD Implement Interface should make it go away.

I am inclined to think that once it's borked, it's likely going to stay confused.

after I resterted and did it all by hand, I had no problem compiling

kind of sucks. Yes, we need to buy lot of purple velvet suits from Mat to get it sooner, I think. :)

but why Access.Form and not any other types, though?

I have no problem using dropdowns for Excel.Worksheet and Excel.Workbook

IDK, given the weirdness in Excel, and the requirement in VSTO to add controls dynamically to a sheet (which necessitates having the VBE be visible), I suspect that document type classes and Access.Form objects are resolved at runtime, in some voodoo way, like F3 dynamic controls on a UserForm.

or maybe it's because there's an Access.Form and an Access._Form? Doesn't VBA do something funky with _ prefixed class names?

wait, excel doesn't have them?

_Something was an old convention for interfaces, AIUI

hmm interesting. The only class i can see is _Globals

and Excel has lot more ISomething

which kind of make everything worse because Excel and Access both are about the same age

I guess the teams in each diverged in their conventions. :\

BTW, FYI - UF controls and Access controls are different. UF controls are each a window. Access form, OTOH is just a one big window, with only the active control having a window. That was primarily done for performance reasons back in the dark days of 16 MB RAM and CPUs measured in megahertz. UF controls are common controls so they can be created at runtime with no problem. Not the case w/ Access'.

@IvenBach I'm glad you liked it :)

Good morning everybody

I see you were discussion the building process of C/C++, and I'm afraid there's no simple answer for this

have a look at the next 5min of this one: youtu.be/7THzO-D0ta4?t=25m34s (Yes, I have lunch with cppcon on my tv)

Static linking, also called implicit linking, or load-time linking, and god knows what other synonyms, is, at compile-link time (that is, developer's time), the sections of an external library are linked into your final solution. Which is yeah, a copy/paste of the code, but of the binary code. You're just gluing zeroes and ones and tons of pointers.

correction: windows has a weird slight variation of what implicit linking means related to static. They're not the same, but, whatever.

guys, I have a very recurrent bug on source control

when I click on create a new repo, and I select a folder, it creates the repo with the exports and the initial commit, but then it doesn't link the workbook to this repo

2017-12-01 10:12:49.5957;TRACE-2.1.6544.18357;Rubberduck.UI.SourceControl.SourceControlViewViewModel;Initializing repo;
2017-12-01 10:12:49.9697;TRACE-2.1.6544.18357;Rubberduck.UI.SourceControl.SourceControlViewViewModel;Provider is being assigned.;
2017-12-01 10:12:49.9697;TRACE-2.1.6544.18357;Rubberduck.UI.SourceControl.SourceControlViewViewModel;Registering StateChanged parser event.;
2017-12-01 10:12:50.0113;WARN-2.1.6544.18357;Rubberduck.UI.SourceControl.SourceControlViewViewModel;Handling SourceControlException: System.NullReferenceException: Object reference not set to an instance of…

it's related to what I was trying to explore the other day with @Hosch250

damn, I have a thing that is killing my git now

@IvenBach added a dynamic current year for the .resx file, but my system is calculating this year and changing automatically the {0} to 2017 and insisting on unstaged changes on git

if you have an idea

TIA

Hello again Pond. I had just closed an Excel file and was opening a new one when i got an unhandled Win 32 exception message flash up. Now whenever i try to do Alt + F11 Excel crashes (even for new workbooks).

Nothing in the RubberDuck error log

VS debugging gives Cannot find or open the PDB file (Excel)

Can this be related to RubberDuck?

Does anyone know if the amount of data on a sheet affects how much memory is reserved for the EXCEL.exe process? I had a weird error where on the last bit of data my macro needed to pull it went OOM, but the code doesnt hold any of the data in memory any longer than it needed to. This morning Excel is running at 5m KB reserved in memory. Just seems odd.

@QHarr theoretically possible, but I doubt it...

sounds like repairing the EXCEL installation should fix it

@QHarr VS allows you to debug the process by default, but I have never actually been able to 'Debug' Excel using VS. It is far more likely that your VBProject is corrupted.

I use RCTools to clean my VBA projects and that usually allows me to open them up again. Also, if you dont use a code cleaner, at least export and reimport any files within the VBA project periodically. As far as I know, with my limited knowledge on the matter, VBA is just bad about cleaning up code that is deleted from the file itself.

:-( Opens fine on other machines so guessing could be Excel on laptop has become corrupted in some way. @BrandonBarney You think this might be related to memory?

@QHarr I highly doubt it unless your macro is doing something incredibly wasteful as it opens. You could check the resource manager to be sure...but I think it is far more likely something to do with the VBProject.

I have yet to have my Excel installation corrupt, but I have had countless VBProjects become corrupted. From a statistical standpoint, I would start with the project itself.

And code cleaning would help with this? I am guessing the action for now is a repair

I would try cleaning the code first. RCTools has a free trial.

You could also try opening Excel in safe mode

And then get into the project.

I believe safe mode is something like hold the shift key while launching the Excel.exe (not a shortcut to a file). And it should prompt you.

But again, if experience is any kind of teacher, I would start with the VBProject, even if you have to open Excel in safe mode to use RCTools, and then go from there.

I will have a look at the code clean. If you do safe mode what do you actually do after that point?

Of course...I could be Icarus flying too close to the Mug right now...

lol

Open in Safe Mode > Open the problem File > export the VB Project to a folder > Save the File without Macros Enables > Open the Non-Macro version > Save as .xlsm > Import VBProject files

@BrandonBarney Wasn't it CTRL?

Basically a longer version of cleaning it, but sometimes is the only option

@Vogel612 It definitely might be. Its been a while.

@BrandonBarney Thanks. Will give it a try.

@QHarr No problem, let us know how it goes.

I have done Open in Safe Mode > Open the problem File but how do i then export the VB Project? As soon as i do Alt + F11 Excel crashes.

Alt+F11 opens the VBE? I cant test it since my excel is frozen. If you're trying to open the VBE and its crashing then it is almost definitely a macro, or the project, causing the issue. In that case some form of code cleaner is really your best option.

It crashes even new workbooks. Will investigate further.

Where could i find RCTools please? I will need to ask my IT department to investigate.

@QHarr - try uninstalling RD from your machine and reopening the workbook on your machine. That would be the ultimate test. If it opens fine on your machine w/o RD, make a backup of the workbook (you already had a backup, right?), reinstall RD and see if the problem reoccurs.

Sorry, comp frozen. Search for Ribbon Commander in Google. It should show up. It's part of the Ribbon Commander framework.

I have lots of backups. To uninstall do i need to go and manually delete all the files in the folder? Also, can't seem to easily find where the files were installed too. :-(

You should be able to uninstall through Programs and Tools, but I have had that same exact issue before with my projects where even new workbooks crash

And it isnt crashing because somehow the new workbook is corrupted. Instead, Excel is trying to recover the corrupted file while opening the new workbook.

Not to sound like a broken record here, but start with the simplest source of the issue first, and then go up the ladder.

Install Ribbon Commander > Open Excel in Safe Mode > Use RC to clean any VBProjects you have been working on today.

If that doesnt fix it, then work on uninstalling RD, or repairing Excel, etc.

But I am just about willing to guarantee you wont need to go beyond cleaning the workbook.

Is this the source you are referring to ribboncommander.com/index.php/…

Yes, just get the free trial

Where is suggests downloading the framework?

I ultimately bought a license for a year since I was using it so often.

That link you posted is the right one.

I would need to speak with my IT dept about this i think. Thank you.

No problem, but if they want to chase this down the rabbit hole instead of installing a tool, good luck to them.

Uninstalling rubberduck and everything works fine. Reinstall rubberduck and VBE wont open.

:-(

Monking, @all!

Though had to disable solver add in aswell

Quick VBA question... A while back someone recommended using Strings.Join() instead of & to do concatenation.

There's a lot more typing in:

foo = Strings.Join(Array("This ", this, " and that ", that, " and the other ", other), vbNullString)

than there is in

bar = "This " & this & " that " & that & " and the other " & other

and an extra function call Array(), is it really worth it in terms of performance and memory? Is there some other advantage that I don't remember someone mentioning?

@FreeMan The top one creates a single string.

The other one creates a new string every time it concatenates.

Which is significantly slower.

(Unless VBA is like .NET and ultimately compiles that into a Strings.Join() call.)

@NelsonVides That's in the rubberduck settings config, and it's a bit messed up. If you just open the repo then, it should work.

@Hosch250 ah yes. So the more & you use, the slower it gets and the more memory it uses, correct?

Yup.

@QHarr anything in the logs?

No. Print out is as in image i shared earlier. Can re-upload but basically seems fine.

@Hosch250 have you follow my stack trace? the thing is that on the master version it does work well, but on the next branch, it only creates the repo and then it throws an error (notified on the Source Control window on the VBE)

Hmm.

@Mat'sMug so, quit worrying about the pennies and look for the dollars, eh, Mug? :)

Yup

can't fault a guy for trying...

Sure you can :sarcastic-grin:

I guess that all the logging code I'm throwing in everywhere is going to slow down processing far more than a few & will.

@Hosch250 On Fault Resume Next

I'll reserve the Strings.Join() for the complex concatenations. I guess...

When you twist the pronunciation of Portugal/Portuguese a little, you get some nice birders puns.

Private Function GetComputerName() As String
#If Mac Then
    Dim appleScript As String
    appleScript = "set result to computer name of (system info)" & vbNewLine & "return result"
    GetComputerName = MacScript(appleScript)
#Else
    GetComputerName = Environ$("COMPUTERNAME")
#End If
End Function

lovely

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #3582: Rubberduck.parsing c#6&7 update

[rubberduck-vba/Rubberduck] build for commit 48ea000e on unknown branch: AppVeyor build succeeded

@FreeMan if you're using my LogManager class, you can conditionally register the loggers. No loggers registered, no logging overhead ;-)

okay, so.. making VBA code work on Mac is a PITA. RD needs a way to easily locate all early-bound references to a type library.

Mac's are PITA's anyway. Just don't write VBA for Mac.

:P

which is why one write late bound code for code that's going to be shipped. :)

@Hosch250 you know that they removed VBA completely from Office for Mac at one point?

Whoops they put it back in the next version!

Heheh, silly softies!

@Hosch250 I wouldn't... if that order form didn't need to run on Macs

[rubberduck-vba/Rubberduck] charlesp-l starred us

@Mat'sMug i'm sure you already saw but FWIW, I have found Ron Bruin's site to be a good resource for making everything work on Mac.

github.com/rubberduck-vba/Rubberduck/wiki/Code-Explorer feels like it needs some love.

I'll explain as best I can about the @Folder annotations that way people will understand how to make the most out of it.

Much love towards CodeExplorer!

I can have modules easily/logically stored!

@Mat'sMug I am. Most things are logged at TraceLevel, some DebugLevel. I've got enough going <s>on</s> wrong that I'm usually running at DebugLevel at this point...

note to self: three dashes makes a strike-out. No HTML in chat... :/

@Mat'sMug It may just be me, but I feel like Vityata's approach is super smelly for such a simple problem.

@BrandonBarney if you truly want to get the enumerator, you need a reflection API

...which RD could provide

That seems...complicated...

Q:what is something that can be enumerated in VBA?

An element of a collection?

no

the collection itself

and how does VBA know that a collection can be iterated?

That I have no clue about lol

@Mat'sMug I'll take "Programming" for $100 Alex...

I have barely begun learning Enumeration lol

Thats how to enumerate

Not how it knows it can be enumerated

because its hidden _NewEnum member has a [_NewEnum].VB_UserMemId = -4 attribute

I havent gotten to that level of VBA yet

Let my comment be striken from the record.

I have no clue how to even do that (I assume export as text file, add it, and then reimport?)

and there's no way to query an object for that attribute using VBA code

Doesnt exist in the VBE, right?

nope

you're standing on top of a stack of unicorns, rainbows and fairy, and all thing magical that is VBA world.

actually maybe the Function [_NewEnum] As IUnknown member is sufficient for built-ins, and the VB_UserMemId attribute is only for user code

I understand that kind of stuff in python __str__ means it can be converted to a string. I just dont understand using those hidden properties in VBA, not yet at least.

Except, in Python, you define the logic with the member

@BrandonBarney I think you should read this

You can be read?

Sorry, that has to be a common joke...

Oh yeah!

seems enumerable custom collections don't work on Mac-VBA

@Mat'sMug i always wondered how they faked COM in Mac....

and how much of it is fake

IIUC the only thing they really need to fake is the Registry, because they control all COM interaction in the VBA p-code interpreter anyways

Hardcoded values everywhere.

they can just replace the registry with NIX-based configuration ideas

hmmm. IDK. When I spy on VBA, I do see it uses lot of COM calls... CoCreateClass among several other things. Those'd have to be faked at least.

isn't that just C?

C works just fine on Mac

yeah, the point being they'd have to implement COM somehow if they don't want to change how VBA interpreter works

but from what I see, it's very incomplete

#If Mac Then
    'apparently comboboxe value can't be set like this on a Mac
#Else
    CollectionCodeBox.Value = this.data.CollectionModels.Models.First.Code
    CategoryCodeBox.Value = this.data.CategoryModels.Models.First.Code
    FabricCodeBox.Value = this.data.FabricModels.Models.First.Code
    ModelCodeBox.Value = this.data.ModelModels.Models.First.Code
    ExclusiveCodeBox.Value = this.data.ExclusiveCodeModels.Models.First.Code
#End If

#MindBlown

Perfect time to demand a whole webapp :)

I don't get it.

so they didn't fully implement UF controls?

4. UserForm and controls problems on Mac

Rowsource does not exist on a Mac to fill the listbox, you must use List to add your data on a Mac.
ColumnHeads = True is also not working on a Mac

MatchEntry is also not working properly on the Mac
I always like Option 0 : fmMatchEntryFirstLetter, but no luck on a Mac.

And many, many more things are not working OK on a Mac.
To much to list them al here

rondebruin.nl/mac/mac027.htm

Wow.

Now knowing this, this means the howling and moaning over the removal of VBA and precipitating the return of VBA back to Mac Office all the more surprising/impressive. In spite of all those flaws, they really want it to work everywhere.

optional parameter resolution doesn't work the same either

Public Function Contains(Optional ByVal Key As String, Optional ByVal Value As IModel, Optional ByRef outItem As IModel) As Boolean

on Windows I can omit the argument name when passing an IModel

on Mac I get an error unless I explicitly say I'm passing it to the value parameter

@this They had to be careful and remove everything correctly, only to put it all back?

no no they wanted to remove VBA completely

deprecate it for reals

they even shipped it without VBA

but the community basically erupted

^

came down on MSFT hard, so they did a about-face in the next version and even improved the VBA editor of Mac

to make it more like Windows

How hard is it to realize VBA is the lifeblood of tons of smaller businesses?

But... but...but! You're supposed to be on web!

You're supposed to use HTML!

You're supposed to fill order on your ipad!

no no, your phone!

Don't you wanna your contents in clouds?!?

oh yeah, pay us monthly and we'll take care of you real good!

Not when you've got 4 people running the place. None of whom are experts and barely make it work.

That's exactly what MSFT can't/won't understand.

:shrug: I guess it's hard to relate when you've never had to do everything yourself?

The Mac VBE SUCKS like ..there's no words for how bad it is

What windows VBE lacks compared to VS isn't a fair comparison?

are you using 2016, @Mat'sMug?

AIUI, they improved it only very recently in 2016.

in prior versions, it was basically VBA5 or VBA6

@this no. and it's a royal pain in the neck to use

@Mat'sMug Like the Windows one without RD?

Worse

MUCH worse

That's barely possible :P

yeah that's why you're suffering.

They did it

Who did what? #ReadingComprehensionFail

what? there's an IDE for media access control?

It seems Mug is having to do VBA on a Mac and the IDE for it is worse than for Windows.

Aha, a Mac. Now it makes sense. When you said MAC, it seems inconceivable to have an IDE for a MAC... :p

i mean how the heck do you make an IDE for what is basically a string of hexadecimal string?

words #MyStruggleIsReal

A MAC is to a computer what JAVA is to Java.

^

NB: you can spot a old fashioned person if he calls Excel EXCEL.

(Somehow I don' t think @this gets the joke, because he likes MAC's.)

Ah but I do! I like me my MACs. Otherwise I wouldn't be bantering with you!

JAVA is horrible Java. That means a MAC is a horrible computer :P

Well, of course! How would you even make a computer out of a hexadecmial string?!?

Oh, I'm slow today :P

LOL.

ok wtf excel

Dim currentRow As ListRow
For Each currentRow In table.ListRows
    If removeNewRows Or isNewColumn = 0 Then
        currentRow.Delete
    ElseIf isNewColumn > 0 And Not removeNewRows Then
        On Error Resume Next
        If currentRow.Range(, isNewColumn).value = False Then currentRow.Delete
        Err.Clear
        On Error GoTo CleanFail
    End If
Next

currentRow.anything is throwing random errors

table.ListRows.Count says 3

Go MAC's!

that's on Windows

Oh, go VBA!

:P

Did you bork your Excel installation?

there's gotta be something I'm not seeing

ffs, I run it again and it works

@Mat'sMug don't you preach the gospel of For instead of For Each ?

ListRows is an object collection

... badly implemented?

apparently

FWIW, someone found a case where For Each'ing a FormatConditions collection (something in Access) only returns only 3 elements even if there are more

had to use For to get them all.

Law of leaky abstraction!

gah, gotta go Step -1

doh. Yes.

you're pulling yourself out underneath

so, that appears to work

For Each + deleting element => a new inspection for RD!

grats. you're modifying the collection you're iterating

@this That's exactly my off-by-one yesterday :P

@Vogel612 yeah yeah

(dammit)

@Vogel612 "Experience is recognizing the mistake when you make it again"

God knows how many time I did that to myself. :\

I'm pretty happy that Java does have a convention how that is supposed to work

OOC, what would it look like?

Collection<? extends T> collection = [...]; // somehow we got this
Predicate<T> predicate = [...]; // and this as well
Iterator<T> iterator = collection.iterator();
while (iterator.hasNext()) {
    T el = iterator.next(); // note: this also advances the iterator
    if (predicate.test(el)) { // check this element
        iterator.remove(); // removes the element last returned from `next` from collection
    }
}

clarify - will hasNext advance the iterator?

no

to be correct: it must not

in .NET, we have stuff like Read() commonly used in while(Read())

different beast entirely

yeah

that's IO

nice that you can "peek" ahead

and IO is weird, because C

@this no you can't peek

it got a C, after all...

you can only ask the iterator whether there is a next element

@this WOOT! I understood the implications of that before it was mentioned. #ICanBeLurnd.

hmm. hasNext isn't essentially peeking? -- yes it is. You don't get the actual elemnt but you get to know whether there's next

if you call next on an exhausted iterator, it will throw an exception

give it some water first, and let it catch its breath.

@this which is very different

I wasn't thinking of the method Peek, just the idea of looking ahead

@Mat'sMug exhausted iterators generally are better off than terminated streams

hehe

@this again: different thing...

[rubberduck-vba/Rubberduck] Vogel612 merged pull request #3579: German i18n updates from Vogel612/Rubberduck/german-i18n into rubberduck-vba/Rubberduck/next

Either way, you get to know. With .NET's equivalent (which is used with stuff like ADO.NET DataTableReader, IIRC) it all uses Read() which advances as you call it.

[rubberduck-vba/Rubberduck] Vogel612 pushed commit b614880a to next: German i18n updates

[rubberduck-vba/Rubberduck] Vogel612 pushed commit c98a6edd to next: Correct i18n inclusion for RegexAssistant

[rubberduck-vba/Rubberduck] Vogel612 pushed commit f512260d to next: Correctly include French RegexAssistant resources in project

[rubberduck-vba/Rubberduck] web-flow pushed commit c21a1561 to next

@Mat'sMug you want to do the french translation this weekend, or would you release without the handful of missing resx strings?

[rubberduck-vba/Rubberduck] retailcoder created tag Rubberduck-v2.1.1.2526

[rubberduck-vba/Rubberduck] retailcoder published prerelease Rubberduck-v2.1.1.2526

[rubberduck-vba/Rubberduck] build for commit c21a1561 on next: AppVeyor build succeeded

hmm interesting. I seem to recall Microsoft saying they already had discontinued VBA for ISV.