VBA Rubberducking

« first day (2469 days earlier) ← previous day next day → last day (711 days later) »

Duga

00:01

RELOAD!

[Zomis/Duga] 1 commit. 2 additions. 1 deletion.

[Zomis/Games] 1 commit. 1 opened issue. 2 issue comments. 4 additions. 1 deletion.

[Minesweeper] Games Played: 130, Bombs Used: 75, Moves Performed: 17870, New Users: 10

3 hours later…

IvenBach

02:58

Updating code without unit tests is not enjoyable...

5 hours later…

Duga

07:58

[rubberduck-vba/Rubberduck] Conqi-dev opened issue #5684: Generate files: DbContext, Repository for Dao in VBA

> **Justification**
Feature: Generate db pattern files for selected tables
Encapsulate the database access. So that the developer can use a fluent environment.
Example now in vba the database access for fields looks like this rs("fieldname"), rs!fieldname
You have not a central place to make a change in your code.
This feature could help to write a cleaner code.

**Description**
I thought you can make a special pattern for Dao db connection.
first thought:
To have an interface IDbConte

[rubberduck-vba/Rubberduck] Conqi-dev added label enhancement to issue #5684: Generate files: DbContext, Repository for Dao in VBA

2 hours later…

Duga

09:35

[rubberduck-vba/Rubberduck] TomFox7 starred us

6 hours later…

Duga

15:23

[rubberduck-vba/Rubberduck] Vogel612 edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

2 hours later…

Mathieu Guindon

17:31

@mansellan still alive, getting swamped again... fml

BigBen

that sucks.

FreeMan

At least you're still alive to be swamped...

How's the new job hunt going?

BigBen

@FreeMan always the optimist.

Mathieu Guindon

haven't heard back from the recruiters, didn't bother following up.. not really looking either, for now anyway (I suppose I'll hit "emergency mode" when the ship finally sinks)

FreeMan

17:53

@BigBen Whenever possible!

@MathieuGuindon pokes the sleeping bear...

Duga

18:21

[rubberduck-vba/Rubberduck] Conqi-dev edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

Duga

18:37

[rubberduck-vba/Rubberduck] bclothier created comment on issue #5684: Generate files: DbContext, Repository for Dao in VBA

> This would fall under this issue: #4549 which deals with this request in more general fashion. You already have the ability to add user defined template but right now it's static code import with no parameterization support. That needs to be developed but before that can be done, a specification need to be defined for how the template will be parameterized. We can look to the [T4 template files for inspiration](docs.microsoft.com/en-us/visualstudio/modeling/…

Duga

19:20

[rubberduck-vba/Rubberduck] Conqi-dev edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

mansellan

@MathieuGuindon when you're less swamped, would be interested to hear what you think of twinBasic

Duga

[rubberduck-vba/Rubberduck] Conqi-dev edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

Duga

20:02

[rubberduck-vba/Rubberduck] Conqi-dev edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

[rubberduck-vba/Rubberduck] IvenBach opened issue #5685: Updating component via Sync Project leaves Code Inspections with spinning ducks

> **Rubberduck version information**
Version 2.5.1.0
OS: Microsoft Windows NT 10.0.18362.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4978.1000
Host Executable: EXCEL.EXE

**Description**
When importing modules via Code Explorer>Sync Project>Update components from files the inspections window displays spinning ducks and doesn't update.

**To Reproduce**
Steps to reproduce the behavior:
1. Export code
2. Display Code Inspections window via menu in VBIDE Rubberduc

[rubberduck-vba/Rubberduck] IvenBach added label bug to issue #5685: Updating component via Sync Project leaves Code Inspections with spinning ducks

Duga

20:28

[rubberduck-vba/Rubberduck] Conqi-dev edited issue #5684: Generate files: DbContext, Repository for Dao in VBA

IvenBach

20:56

In VBA-landia for forms is there a way to select CheckBox5? Choosing definition gives me a missing F3Dynamic dialog.

HackSlash

21:19

@IvenBach by select do you mean toggle the check?

UserForm.CheckBox5.Value = Not UserForm.CheckBox5.Value

IvenBach

As in select it when in design mode so I don't have to Select. Every. Single. Control.

That way I can avoid having to check every (Name) property.

HackSlash

You want to print the name property for each one? Or just select multiple?

You can highlight a group of objects with a selection box

like drag select

If you have a large number of objects it can be advantageous to create them in a loop. A similar looping through all objects looking for TypeName = Checkbox you could print the name property

IvenBach

I should take a step pack and explain a bit more.

I'm reviewing a workbook created by someone else. They have a from they are using to enter information. On the form are several controls.

The controls left the default name TextBox1, TextBox2, etc..

I'm attempting to update the form to make it more maintainable. My first is to rename the controls.

When I'm looking at the coding pane and have Activesheet.Cells(1,1).value2 = Form.Control.Value I'd like to be able to right click on Control and choose Definition to be taken to the displayed from with that control selected.

HackSlash

And it doesn't ?

The only thing that comes to mind is setting the name to match the Caption. You would have to strip illegal characters from the Caption, like space, but then you could automatically name everything as it is displayed. (Wouldn't work with textbox where you would need to look at the label)

Aha! I just reproduced your problem! I've never seen that error

I've never tried to do that before

IvenBach

21:35

I rarely work with forms. As such I'm a blind pig when it comes to working with them efficiently.

HackSlash

I think the issue is that you are trying to get to a GUI location from the code pane. I don't think that happens.

So automating the action, like I suggested, might be your only recourse for access from the codepane.

I just realized the RD code explorer can't even take you to the form editing GUI

You have to use the classic Project Explorer to even get that window open.

Looks like RD rename can't help either.

Or maybe it can...

Yes, verified. You can right click and do a RubberDuck > Refactor > Rename. and it will change the object name without ever visiting the Forms GUI

IvenBach

I tried that and it previously wouldn't let me. Even made sure of it with two parses to be belts-n-suspenders sure. Now it is. That's a big bowl of WTFies.

HackSlash

21:51

Yeah, the first time I tried it was greyed out. Then it worked the second time.

IvenBach

Thanks for confirming I'm not alone.

2 hours later…

Duga

23:32

[rubberduck-vba/Rubberduck] edgarchinchilla starred us