I have two lists 1.List 2016 2. List 2017 on single sheet
it has Name, Qrtr1,Qrtr2 columns resp. I have to compare this two lists by name.
If same name found then i have to do Qrtr1-Qrtr2 else if not same name then display all different names with values in third list
i knew we were leaking but i didn't realize so many.
the good thing is that the installer will delete all those keys because we already pick up those auto-generated GUIDs from the WiX and it's built into the registry script that's generated.
the bad thing is that if they skip the 2.2/2.3 but previously installed 2.1 or earlier, we won't remove those leaking keys.
Got API under control; will clean up the Main and other COM visible classes tomorrow.
@PeterMTaylor in theory, if we are only interested in queries, we don't really need the Access PIA; using DAO PIA would suffice and we can run queries on the MSysQueries which contains expressions making it easier for us to resolve any expressions buried in the queries. The other common places for expressions usually go into controls' ControlSource which should be accessible by VBA via the typeinfo.
Whether that's actually all we need... that's the question.
@IvenBach the gofundme link can go, and I'd have the "help us" label simply say "Help us improve Rubberduck!" - have you tried setting the VerticalContentAlignment attribute?
Also we need to do something about these white blocks
Perhaps make the whole top part white save a 5dip margin that would be all around the control
The scrollbar looks off... there's a border with a margin there?
@IvenBach consider using a label instead of a textblock for the "report an issue" button. You'll be able to vertically center its content. Or, wrap the textblock with some container, e.g. a grid or a border
Or go fancypants and make it a button with a custom control template =) ..then you can have a command binding for it
Hello Pond - is there any easy way in Chrome when inspecting the source HTML to simply select the entire HTML? Something like Selenium's getBodyText()? I couldn't find an equivalent in Selenium Basic. Or even Ctrl + A (That will work on the HTML code side) . I can obv write out response text to txt file but there has to be an easier way......
> “I’m delighted to hear you have a head of integrity,” one member noted dryly when Mr. Schroepfer referred to a colleague in charge of ethics. In criticizing the number of fake accounts on Facebook, another lawmaker wondered why he, an overweight middle-aged man, was getting Facebook invitations from attractive young women.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=h1) Report > Merging [#3971](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/1b1fe5cb0a9f3f17e4016128b4808fda16af7982?src=pr&el=desc) will **increase** coverage by `0.02%`. > The diff coverage is `0%`.
@Vogel612 I wouldn't call that stalking. On some occasion I clicked your profile, and as I've been living in the Stuttgart area for 12 years now, that information easily stuck in my mind. :)
@this Following your discussion with @MathieuGuindon yesterday about accessing a form's private fields and hidden code stored in queries, I wondered: Is it possible in MS Access to bind my queries only to form properties (defined by me) instead of controls? (As this has been repeatedly tripping me up, and I've only been using Access for about half a year now.)
stuff like those: SELECT a, MyCustomFormat(b) AS betterB, Left(c, 2) AS shortC FROM foo WHERE ID = Forms!frmSomeForm!txtSomeTextbox AND d >= Date(); <== stored inside an Access query.
When I've got a query referencing a certain control on a form to do whatever it needs to do. You mentioned that would easily lead to bugs. And I agree.
So just switching out form.control references for form.property references doesn't work, right? At least my Access installation refused to understand me there. :/
If we assume we are using DAO, there'd be a function to concatenate the SQL taking the parameters. Mat will probably kill me for suggesting that, though because #BobbyTables. But given the circumstances, it is best approach with the DAO model. But if you're running remote queries against remote backend, you should use ADO. In our projects, we use both DAO and ADO... generally DAO only for local Access queries or as a recordsource/rowsource, and ADO in the between.
I do not think the properties are accessible in that manner, no. the expression service only knows about public functions defined in standard modules or where it can get via the global context.
Hm. A public function in a form can't be found. The same function in a standard module can be found whether set to Private or Public. So I guess the limiting factor is class vs. standard module (as the documentation you linked also mentions)
Yeah, one thing about ADO parameters is that they can require lot of code. Using mat's sample would help get that out of way. I usually just use a code generator to create VBA procedure for each stored procedure (and more) in the database so I can have static doe analysis of SQL Server object usage within VBA codebase. YMMV.
With DAO, the best thing is to write a set of functions to sanitize the input for concatenating.
#ProTip: If someone suggest to you that you should get their data by importing a text file, shoot them. Use XML, use JSON, use anything else but not stupid CSV, delimited or fixed with text files.
@this I think I'm not (yet) at that stage of proficiency and professionalism. I've only been working with VBA (or coding in general) for 1.5 years and only half a year with Access. In my team, everyone else works with MATLAB whereas only one of them actively develops while the others only just "use" it. So I'm basically the one guy tasked with developing a database. And sometimes it feels like a way too large undertaking for a single (inexperienced) dev. ;)
@this What about the import as .xlsx feature in Access? That should be ok?
I understand. FWIW, I would place a higher premium on SQL than VBA in such project, as a bad database can easily lead to even worse VBA coding practices.
@this It feels that is a specialty of every MS Office product. They always try to anticipate what you want - and more often than not go totally wrong.
I was thinking of having a *defined* and *automated* deployment process as an example for professional DB development. (Partly done, but not there yet. I feel Access makes this step unnecessarily difficult.) But I also know that I tend to see minor issues as major deficiencies. ;)
FWIW one thing that really annoys me is that we have HTTPS requirement and we have built a web API to meet that requirement but surprise, surprise, the toolings doesn't like HTTPS, which makes it unnecessarily complicated for developers to set up it correctly
even using a self-signed certificate for development purposes can be A Major Hassle™.
Does anyone here know about Substratum? It seems to me that it, if successful, would be able to undermine some of Google's dominance over the internet.
But I'm not sure if their concept will actually work as well as they imagine.
Sure. Just do it the wrong way:
Sheet1.Activate
Range("A1").Value = 42
Unqualified, Range is a member of _Global, which implements its Range property by returning the specified range on whichever worksheet happens to be active... if any.
If you're going to implicitly work off ActiveSheet, you...
> Every time someone makes an implicit call on _Global, a baby unicorn dies and two new Stack Overflow questions involving errors stemming from unqualified worksheet calls are summonned from the darkness.
In addition to @PierreArlaud, sometimes 'genius' code is so horrible that to truly understand it, you have understand things the developer didn't even understand. I worked on a project where relatively simple functionality would reference hundreds of other objects with thousands of connections and have random deadlock errors. So I have to no only understand what the developer thought it did... but what it actually does... and this was a simple application of a few thousand LOC. — NPSF3000yesterday
Just need to get the target server to not say offline. I think that's because someone set up a temporary server for testing, then took it offline when they were done.
something doesn't look quite right... the margins look more sane though, but the 2nd row feels too tall, and we need to do something about the text alignment of the scrollable part. how does it look, centered?
Your variable for DEM_ERow looks to be more complicated than it needs. DEM_ERow = wsDEM.Range("C4").End(xlDown).Row should produce the same row count.
A lot of your Subs were passing in both the sheet name and a string that represents the range. Assume you have Private Sub BoldHeaders(ByVal to...
WallOfTextAnswer++
Another link out there for RD.
@Vogel612 Glanced at the updated UI you did. How long did that take you?
I have two lists 1.List 2016 2. List 2017 on single sheet
it has Name, Qrtr1,Qrtr2 columns resp. I have to compare this two lists by name.
If same name found then i have to do Qrtr1-Qrtr2 else if not same name then display all different names with values in third list
Sure. Just do it the wrong way:
Sheet1.Activate
Range("A1").Value = 42
Unqualified, Range is a member of _Global, which implements its Range property by returning the specified range on whichever worksheet happens to be active... if any.
If you're going to implicitly work off ActiveSheet, you...
Your variable for DEM_ERow looks to be more complicated than it needs. DEM_ERow = wsDEM.Range("C4").End(xlDown).Row should produce the same row count.
A lot of your Subs were passing in both the sheet name and a string that represents the range. Assume you have Private Sub BoldHeaders(ByVal to...
VBA Rubberducking
VBA Rubberducking