Search results

I'd go this route but it will get confused by things like the word A and chord A.

I'm working on a script that will clean up and transpose chord/lyric sheets. Here's a couple examples of what I mean - the chords are the letters atop the lyrics. G All of my love all of my kissing You don't know what you've been a missing C G Oh boy when...

The Ctrl+C/Ctrl+V thing got me. :LOL:

Legitimate question: what counts as a "comorbidity" and how does one go about determining the number of them one has?

Certainly you can get that sufficiently clean without disassembling it like that(?) At the very least, I've never done such a thing except to perform an actual repair - seems too risky to pull all that off when a good can of air and some patience can get things good enough. But the only tower...

The Universe not having an end doesn't preclude it from having had a beginning and, thus, a current age. You are correct to state that using your approach to get the age of a universe with an infinite lifespan would prevent getting its age since we can't get a midway point and so could never...

I don't know that the answer is obvious at all. Our discussion should show that a question like that can have different answers depending on the aim. So a sensible response might be "what man?". That then leaves the clarification of an average man or most men (among other possibilities)...

Perhaps it is that I don't understand the purpose of trying to guess a number that "minimises ... errors" instead of trying to guess the number most likely to be correct. However, if you want to average closer to the right answer (even if it means less-often getting the right answer), then...

Your question is basically "which line looks like it's closest to the middle?", but if the aim is to figure out which guess is more likely to be correct, finding the middle doesn't help - what we want is the mode. A better analogy: Suppose a barn wall covered in square tiles of different...

Not quite. For an issue like that, the average age is not really relevant; what you want instead is the most common age. For the UK, that age is 55. You are more likely to be accurate guessing 55 as an age than you are guessing any other age.

@Isaac, can I ask what the side effects were after the first and second doses?

Also, using the file path approach you wouldn't need to distribute the images - just put them in a subfolder where your BE is stored. Everyone would be using the same images.

You're clearly not as lazy as I am... ;)

How can I access the research cited in the article? Sometimes it takes a bit of clicking, but I'm used to there being at least some way to navigate myself to the actual data when I read stories like this...

Thank you for insisting... That worked! :) I didn't try that at first 'cause I didn't think it would make a difference what number I used (really it shouldn't make a difference, right?). But this program is a strange one. Here's the finished code that auto-sizes all the columns with the option...

Thank you. Unfortunately that doesn't work. Here's code based on that principal and the resulting Debug.Print values. In every case, the returned value of .ColumnWidth is still -2 and not the width of the column. From your link: "I should note that I did try assigning a temporary dummy...

Hello! I am trying to determine the width of my columns in datasheet view. My code first SETS the columns to auto-width (.ColumnWidth = -2). I then have need to go and grab their widths (ie, need to auto-width them and then figure out what that auto-width is). When I go back to read the...

Is it cbm or cmb? Not sure that's really the problem (I would suspect something like that not to compile) but it'll be easy to check to be sure.

Consistency is the real key. I use cmb for comboxes, which I suppose could be a dyslexic's nightmare with cmd, but it works well for me.

A properly-built database shouldn't really have that many fields, should it? But I agree with using a mapping table. Only I wouldn't go with having DLookup() to fill the table with friendly names. Users don't often go to audit tables and that would slow down data entry. Instead, store the...