topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday July 8, 2025, 9:26 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Target [ switch to compact view ]

Pages: prev1 2 3 4 [5] 6 7 8 9 10 ... 73next
101
FWIW the solution to your 'problem' is the program itself.  No value in using external apps like AHK, or probably even an addin, cos its something thats easily done in excel using VBA (ie a macro).

That said, unless you can give us a sample file (or at least some reasonable details) its probably going to be difficult for someone to put something together for you (and I don't currently have access to excel or I'd knock something up)

Of course any solutions offered now will be moot because you've already resolved the issue anyway

102
if all the sheets are in the same format (all columns match and all formulas are the same) then you're only copying the data (the calculations can be done in the target sheet)

The simplest way to do this for a one time job is to copy + paste - it would have been done in less time than you've spent on this thread

if you need to do this often (ugh...), then its not as simple as just finding an addin.  Every situation is different and you have to make sure the data is clean before you even start (else you just end up with garbage)


103
and its not like this is news, it's been like this for years.  Clearly there's something that needs to change, but we're not seeing any activity from either side of the fence here...

104
General Software Discussion / Re: Best app to learn SQL on
« on: November 05, 2019, 12:06 AM »
The current version of SQL server isn't compatible with my OS (W7) so I guess thats out...

I understood that the various implementations all had distinct dialects so I guess I was looking for something reasonably generic to get me started

105
General Software Discussion / Best app to learn SQL on
« on: November 04, 2019, 06:01 PM »
Any recommendations? 

I'm wanting to teach myself some SQL and want to know a good place to start.  I have a couple of books, but I'm a bit confused about which software package to work with (I tried MySQL and it installed a million things that I didn't know what to do with)

106

Then let me counter with this video. You have to get through the first 2 minutes or so with a narrator who is not too fluent in English and spouts what he does with a heavy accent. But after those two minutes or so, the engines on the bikes start doing their "thing"...

Honda CBX 1050:

shouldn't this be in the music thread?

107
How motorcyclists think people react when they drive by...


108
General Software Discussion / maybe of interest - another security flaw
« on: September 29, 2019, 05:32 PM »
besides being pointless fluff, it seems all this RGB blinky stuff can also be a potential security threat 

leds-light-the-way-to-this-backdoor

109
Some feedback in case its useful to others......

I couldn't get mplayer to work with that string, nor could I decipher the command line options (there appear to be hundreds, most relating to video...)

The AHK script worked, but audio disappeared after 2 folders, and only a reboot resolved it (until the next 2 folders...).  I could open/play the files manually regardless

Final solution - I eventually found that 1by1 had a configurable 'intro scan' function that does exactly what I wanted.  I knew it was there, but last time I used I don't think the play time was configurable 

EDIT:  Maybe worth noting that the 'preview' function in 1by1 only works on a folder by folder basis.  Not quite as convenient, but it's working for me...

110
don't mind the cli, but damn if the help file for mplayer isn't exactly helpful here.  I assume that there's no option for a recursive search with this option...

that AHK script is a winner (dunno why i didn't think of that).  Only thing I would like to see is some sort of delay between the tracks, ie the instant transition from track to track is somewhat jarring, though it does keep me focused (I added a 2 second mute at the end of the loop. does the trick) 

111
Looking for an app that I can use to review >800 tracks. 

Background is that the files were all on a USB stick in my wifes car, and some were displaying odd artifacts at the beginning of the track when played on the car stereo. 

Rather than scrapping the whole lot I'm wanting to review them to see if any are actually corrupted or whether the problem may lay with the player (its in a 4 year old subaru)

60 seconds should be more than enough to id any offenders, and I can listen to them while I do other things.  Having to do it manwelly is tedious, and gets in the way of work

Idea's or suggestions appreciated! 

112
another one that might be worth consideration, though probably not strictly a freeware site

Alternative To offers alternative solutions to a lot of mainstream apps

113
Living Room / Re: Recommend some music videos to me!
« on: August 05, 2019, 08:28 PM »
not much  of a video, but this guys worth a listen

here's a link to him doing enter sandman in the style of David Bowie



or see his other stuff on his youtube channel

114
portablefreeware.com - its my goto when I'm looking for something I can't get here. 

I monitor a handful of sites but if something catches my attention I always try and find the devs page rather than download from wherever I found it mentioned

115
just to confirm, you only need to define a time?

quick and dirty AHK code...

#persistent
MyHour = 07
myMin = 07

loop
{
  if A_hour = %myhour%
    loop
    {
if a_min = %myMin%
          click

sleep 750
    }
  sleep 750
}

116
DC Gamer Club / FarCry New Dawn
« on: June 06, 2019, 03:10 AM »
any players here?  curious to know if its worth spending any money on

I loved 3 & 4, and I've just finished 5, but it has to be one of the buggiest games I've ever seen...
 

117
Screenshot Captor / Re: Draw a rectangle on W10
« on: April 02, 2019, 12:17 AM »
try changing the blend mode

thanks mouser! 

For some reason it was set to multiply.  No idea why it was like that, but as an occasional user (and a non graphics person) I don't know what most of these settings do

118
Screenshot Captor / Draw a rectangle on W10
« on: April 02, 2019, 12:02 AM »
It's likely me cos I'm not a regular user, but I'm not able to change the colour of a rectangle, specifically the border

I'm trying to highlight a bunch of fields on a screenshot and can only get a black rectangle (not yellow like I specified).

Any suggestions?

119
Good lord this Cranioscopicallity is spreading like a virus.
Do I sense some internal resistance?
-cranioscopical (March 20, 2019, 06:01 AM)

That was a circuitous path to that current pun.

Circuitous?  More like a straight conduit to the pun...

Just DODdering along, more like...
-cranioscopical (March 20, 2019, 07:18 PM)

This thread keeps soldering on....

we're determined to wiring as much out of it as possible

no doubt at some point we'll loop back to the beginning again

120
he was on a charge...

As long as he didn't charge into somebody, which might be considered battery, there should be no need to get the coppers involved.

we'd all end up in cells

121
Wow!  Congrats!  That didn't take long at all!

he was on a charge...

122
i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)
It all works?!  To celebrate, I volt for a Faraday for an entire week!
We'll just call you the generator of a new war...
Leave it to Jody Ohms to be the transformer of the conversation..
can someone remind me, wire are we doing this?
Because no one will be the terminator of the arc.
Yep, we just keep plugging along.


I suppose for some its an outlet, but for the rest its just circuitous...

As long as the posts are positive, and not negative, I'm happy to continue.

IC...

123
i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)
It all works?!  To celebrate, I volt for a Faraday for an entire week!
We'll just call you the generator of a new war...
Leave it to Jody Ohms to be the transformer of the conversation..
can someone remind me, wire are we doing this?
Because no one will be the terminator of the arc.
Yep, we just keep plugging along.


I suppose for some its an outlet, but for the rest its just circuitous...

124
i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)
It all works?!  To celebrate, I volt for a Faraday for an entire week!
We'll just call you the generator of a new war...
Leave it to Jody Ohms to be the transformer of the conversation..

can someone remind me, wire are we doing this?

125
Living Room / Re: Best Programming Jokes
« on: March 12, 2019, 05:40 PM »
You either die a feature or live long enough to see yourself become a bug.

either one is irrelevant if its not documented

Pages: prev1 2 3 4 [5] 6 7 8 9 10 ... 73next