Good code for sending email from Access here: http://accessrelic.blogspot.co.uk/2015/10/sending-e-mail-from-access.html
It also discusses how to get around the pop-up dialogue referred to by lameid, using something called Outlook Redemption.
Also, for scheduling Access tasks, there's always...
I should add that I don't need the data on the hard disk, so if I could somehow boot from a CD or other device and then reformat the hard disk in question, that would be an acceptable option for me.
@kjv1611 - I am misled, the disk works but prompts for a HDD password, which I don't have.
What would be the best way to remove that? Can I do something with it if I am able to boot from a CD?
Thanks for all the thoughts and suggestions. As luck would have it, have managed to lay my hands on another old laptop, so can pop the hard disk in that directly. Have also downloaded a BIOS upgrade from Toshiba so can burn that to CD, boot from the CD and then flash the BIOS on the hard disk...
@626F62 - both laptop and PC are running XP, SP3 and SP2 respectively.
@vacunita - no, I didn't miss your post, but isn't an adapter effectively what I already have? Perhaps I'm missing the point, sorry.
Did you know you can create your own (and easily customisable) pop-up calendar using native Access forms? http://www22.brinkster.com/accessory/forms/005.shtml
To clarify, the disk definitely had a BIOS password set, not a HD password.
The laptop it came from is in pieces, and now incomplete. I guess I'm going to have to try to find another laptop to plug it into to be able to enter and then remove the BIOS password... unless anyone has any other...
Aha! Yes, Rawle24, it did have a BIOS password. Darn, I'd forgotten that.
So now what can I do? Putting the disk back into the old laptop is not an option, as the laptop in question is in absolute bits.
Is there a way I can flash the BIOS now the disk is in an external enclosure and connected...
@Nelviticus - yes, the cable I have is the same kind of asymmetric Y you describe, and I've tried using it as you describe. But I still get the same results. The device is certainly getting power - the disk spins up and the light comes on. Maybe it's not getting enough power, but I don't think...
Trying to re-use the hard-disk from my old laptop as a USB storage device.
Removed the disk from the laptop, popped it into a nice new enclosure and plugged it in to my desktop PC at work (where I have administrator priv's). No joy. What happens is this:
- The PC recognises a USB mass storage...
Am using a UNION query to collate two disparate queries, and then want to use that query nested within another. This is what I have:
SELECT DISTINCT cid, logdt, MIN(closedt) FROM
(
SELECT cid, logdt, closedt
FROM Call C
WHERE datediff(ss, C.logdt, C.closedt) < 21600
UNION
SELECT c.cid...
You may find this useful, as it discusses programmatically changing default print queues in Access, specifically to facilitate printing to a PDF queue.
http://www22.brinkster.com/accessory/modules/009.shtml
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.