Messages

1

General Software Discussion / Re: desktop backup and restore

« on: July 26, 2020, 10:34 PM »

Is there one?         

2

General Software Discussion / Re: desktop backup and restore

« on: July 26, 2020, 05:01 PM »

Only a building block for making a script, but worth mentioning: The AutoHotkey function DeskIcons works for me in Win10 and some in its forum thread report that it works for them in Win7 too https://www.autohotk...c.php?f=6&t=3529

Edit: sorry, I read too quickly. The above function only saves/restores the position for already existing icons on the desktop. It does not restore icons/shortcuts that have been deleted.

-Nod5 (July 26, 2020, 06:54 AM)

All good, I'd forgotten about AHK in this context.  I shall have to give some thought to how I might approach it...

3

General Software Discussion / Re: desktop backup and restore

« on: July 26, 2020, 03:17 AM »

Not exactly sure how to snswer shades

This isnt my machine (its my mother in laws) so I'm getting support calls whenever it happens.

Don't know about the system setting but itsvworth a check.

I confirmed the behaviour this afternoon by creating a new shortcut, created a save in desktopOK, then deleting it again.  The restore option in desktopOK failed to reinstate the icon, or the other icons i also deleted as a test

4

General Software Discussion / desktop backup and restore

« on: July 25, 2020, 09:27 PM »

I'm pretty sure I've seen this asked about before but I can't find it now so apologies for asking again

I have a Win7 desktop that forgets/loses/deletes its icons periodically, and to the best of my knowledge without any user input

I've tried a couple of tools that are supposed to backup and restore the layout (Desktop OK, ICU) but they don't appear to work either.

Lots of questions about this on the net, but they all pretty much point to the aforementioned solutions (which aren't working in this instance)

Anyone got any clues or suggestions?

5

LaunchBar Commander / Re: Hotkey and graphical control

« on: July 13, 2020, 06:22 AM »

First thing that jumps out at me is your naming convention.   Try to come up with shorter names, eg 'cam' instead of 'logitech webcam'

6

Screenshot Captor / Re: Any idea why capturing triggers a bluetooth notification with "YourPhone"

« on: June 30, 2020, 07:40 PM »

what are the shortcuts used in the 'yourphone' app?  sounds like there's a clash to me...

7

General Software Discussion / Re: OpenSCAD is a game changer for 3d printing

« on: June 16, 2020, 11:44 PM »

change the design of the gear such that instead of printing the 'D' shape it has a keyway instead.  That way you can insert/replace a piece of square (?) wire or rod to form the flat in the centre (FWIW keystock comes in standard sizes and should be readily available)

8

Living Room / Re: Recommend some music videos to me!

« on: June 16, 2020, 01:16 AM »

ran across a reference to Hildegard von Blingin' (its a play on words apparently) this morning

she does medieval covers of modern songs, which is an interesting take (YMMV)

9

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 29, 2020, 07:02 AM »

In principle it works yes, although I can't seem to get the Undo function to work.

-Stephen McBride (May 29, 2020, 05:24 AM)

Unfortunately theres no undo, but im not sure why you might need it (unless you're wanting to reverse changes made incorrectly?)

10

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 26, 2020, 06:48 PM »

any feedback on this?  Did it do the job?  should I try to polish it up a bit?

11

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 20, 2020, 03:08 AM »

apologies for my tardiness, been a bit preoccupied with the job hunt...

regardless, try the attached.

It's just an on-change macro, ie when a value on the sheet changes it fires off.  It uses a couple of 'helper' values - the stock column (B) is duplicated in column D and used to check for changes in stock levels, and there are subtotals in cells B1 and D1. 

• If the value in the stock column goes up, the corresponding check value in column D is amended accordingly.
• If the value in the stock column goes down, the difference between the new value and the check value is added to the sales column (E), and the check value is amended to match the new stock value.

in practice both row 1 (with the subtotals) and the check column would be hidden as they don't add anything useful to the user (and any user changes to those values would result in corrupted values)

its not terribly pretty, but it works OK for a first cut

appreciate any feedback you might have

12

Living Room / Re: Doordash and Pizza Arbitrage - Unloading capital cannons on customer acquisition

« on: May 19, 2020, 10:06 PM »

seems like the big business approach these days is to carpet bomb the market into oblivion, then build your business once any/all previous players are gone.  It takes deep pockets (which don't seem to be in short supply) and the only likely winners are big business (and certainly not the consumer)

13

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 11, 2020, 03:44 AM »

pretty sure I can automate this, but it might take me a few days to organise...

TSaints solution works, but seems (to me) like a convoluted way of doing it

14

General Software Discussion / Re: Need a little help with an Excel file please

« on: May 09, 2020, 02:22 AM »

question, and apologies if this seems inappropriate for your situation. 

Why 'assume' that the 2 correlate?  I don't know what your product base is but would assume that you might need some means of identifying lost items, ie just because the stock level has decreased a corresponding increase in sales shouldn't necessarily be assumed.

FWIW I'd be happy to have a look at it for you, but I will need a copy in xl format (I don't have access to excel at the moment, but I can work with spreadsheets...)

15

Living Room / Re: Gadget WEEKENDS

« on: May 05, 2020, 06:35 PM »

the friday rule is out the window -- post whenever you like

-mouser (May 05, 2020, 09:30 AM)

...or defenstrated.

-Arizona Hot (May 05, 2020, 02:52 PM)

...or framed.

-cranioscopical (May 05, 2020, 02:56 PM)

one day lad, all this will be yours....

16

Living Room / Re: Share your tips and comforts for dealing with the stress and fear of a pandemic

« on: March 26, 2020, 11:11 PM »

see, people are good...

17

Living Room / Re: Share your tips and comforts for dealing with the stress and fear of a pandemic

« on: March 23, 2020, 11:03 PM »

Maybe just past the text in a quote in your post instead of attaching it as a download.

-mouser (March 23, 2020, 09:21 PM)

I would have but I thought it was too long - I've amended to link to the source page

18

Living Room / Re: Share your tips and comforts for dealing with the stress and fear of a pandemic

« on: March 23, 2020, 09:14 PM »

this was posted on Kottke.org yesterday.  not sure if its helpful or not, but it resonated with me...

Some People

19

Living Room / Re: Do good mice still exist? Looking for recommendations.

« on: February 13, 2020, 11:47 PM »

I can't really offer any sort of a recommendation but man oh man but you must be hard on your gear!   I've never had a mouse (or keyboard) fail and I've been playing FPS games regularly for over 20 years.  FWIW I'm currently using an ($80) gigabyte gaming mouse (M800x) that I've had for nearly 10 years, and a generic logitech keyboard for well over that, and I've yet to have an issue.

Since you've been using generic mice for some time now the MS mouse is probably worth looking at.  Its recently gone back into production and the reviews I've seen have been positive (and I used one for many years at work without an issue). 

20

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 09, 2020, 07:13 PM »

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

21

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 09, 2020, 03:22 AM »

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)

22

General Software Discussion / Re: VirusTotal marking each and every AutoHotKey exe as Virus !!

« on: January 19, 2020, 11:52 PM »

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...

23

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

24

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)

25

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« on: October 08, 2019, 02:47 AM »

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:

-Shades (October 08, 2019, 12:12 AM)

shouldn't this be in the music thread?