Replies

If you send your workbook to someone else, Excel will use the decimal and thousands separators from their system, so there’s no real need to display numbers differently.

Hello Hans,

In fact there is. I have an Excel spreadsheet supporting a Word report which is intended for US users. My local settings display numbers as 3.499.123,28. These are the default settings in Argentina and I don’t want to change them. However, I need to paste tables from Excel to Word in US-compliant format. That’s why I would like this custom format, so I can apply it whenever a similar need arises without having to go switching regional settings.

Thank you anyway!

Thanks, Jeff!

Found a use for it. In Access 2003, when you create a query, the “Show Table” dialog is short of space to display some queries’ full names (which is a glaring error… if I can use n characters for a query name, why in the world does it display the first n-k only?).

ResizeEnable allows to stretch this window to display the queries’ full names.

Thank you, Hasse!

I am not working there anymore, but there’s a chance they will still find this useful. I will let them know.

Thanks, Joe. Looks like a keeper!

The push-pin button is very useful, and it alone makes FbX a must. For that purpose I used to use Deskpins, but this is much more convenient. The other features look pretty cool too, although I haven’t used them yet.

A little bit late here, but thanks for posting this. Ashampoo Burning Studio is a great piece of soft!

From the XP List (haven’t checked the Vista one):

[indent]

---

SequoiaView – Treemap visualization of hard drive’s contents. (Utilityapproved by the PowerToys group)

---

[/indent]Regardless of having been approved, it’s a great utility and it’s been so long since I last saw a mention of it in this forum that I thought it would be a good idea to draw attention to it for those who may not know it.
Grab SequoiaView here.

Thanks. AutoIt is a great tool!

Unfortunately I don’t have much use for it, but it’s easy enough to recall whenever I need to.
I have also found SciTE4AutoIt3 very useful.

Thanks Alan.

If I ever need to use graphs again I will turn to R before trying out anything else. Here‘s a graphical gallery showing off R’s graphical cababilities.
On the down side, R is pretty complex (overwhelming I dare say) to start from scratch, so if Veusz is sensibly simpler it might be worth keeping.

[indent]

---

Assuming you have XP.

Windows Explorer | Docs & Settings | All Users | Start Menu | Programs | Start Up

Drag & Drop a copy of the exe file into that location.

---

[/indent]Never used Sunbird, but in case it is not a single EXE file requiring no installation, perhaps it must launch in the same folder it was installed to (to check for & use other program files maybe). So if this is the case, instead of dragging a copy of the EXE file, try copying it (Ctr+c) and then pasting it as a shortcut (right click | paste shortcut) in the location(s) Bob suggested. If done right, you should see the shortcut in Start | All Programs | Startup. Let us know if this works.

HTH.

Hi Joe,

If PDFUnlocker does remove passwords, then we might include it in the list of PDF utilities post that has been going on for quite some time now.

BTW, what does your RapidShare upload version differ in from these available versions?

Thanks.

Thanks.

I see there are some other suggestions in the comments to the blog post, but no one mentions IrfanView, which is my choice. Actually I use IView for viewing images, but it serves many other purposes, such as rotating, batch-resizing/resampling, and yes, image capturing. Just press “c” and a dialog box will pop up with some options for you to choose what you want to capture.

What’s more, I keep using old version 3.85, which doesn’t even require an install .

Edited by Diegol to provide the link for the English Wikipedia entry on IIS

Hope I’m not too late.

Yes, I’ve stumbled on that difficulty many times. It’s likely that your ISP is placing a limit on the number of recipients per e-mail when you use their SMTP service. After getting the “bounce” message you have the sensation of having committed felony when you actually were up to no big deal (inviting a bunch of people to my birthday was my case), but it seems reasonable that they control outgoing traffic some way.

I tried some mass/bulk mailers in the past, but they were kind of problematic. I also tried Windows’ Internet Information Services, which lets you set up your own SMTP server. However, some sent e-mails never made it to their destination and I didn’t get any notice. At some point I got tired of this too (much too troublesome to send ONE or TWO mails a year). I recall there being a security issue with leaving the IIS service up and running all time, so I had to turn the service on and then off each time.

My last approach was to use the web interface of my Gmail account. It’s not all that comfortable to pick Outlook contacts one by one, copy their e-mail addresses and paste them into Gmail’s “CCO” field, but not such a chore if you don’t do this routinely. I’m certain there must be a way to handle Gmail contacts in a convenient way. Up to you to investigate!

Many thanks, Hans. I really appreciate your valuable help.

Have a nice week!

Thank you, Hans.

I think I could finally help myself out with this.

The preliminar code (which is working) is as follows:

Private Sub cmdAbrirConsulta_Click()

Dim qdfNew As DAO.QueryDef

On Error Resume Next
With CurrentDb
.QueryDefs.Delete (“z_Temp”)
Set qdfNew = .CreateQueryDef(“z_Temp”, strSQL)
.Close
End With
DoCmd.OpenQuery “z_Temp”

End Sub

Any further suggestions are welcome!

Hi Hans,

[indent]

---

if you tick the check box for a reference, it should be ticked whenever you open that database.

---

[/indent] Yes, but I need to import the form to new databases, and after so doing I find I have to make the reference afresh. If it is hard to accomplish via VBA code I guess I’ll keep doing it manually .