Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Goodness that sounds frustrating, ZenKitty!
I have another access question. I am creating a form letter to email to our students. I have most of it down, but I would like to customize the letter with different directions based on what room with class is in. The rooms are stored as numerical values in the field "Location". Basically, I need a expression that means If the Location = 1, then Directions to room 1, If Location = 2, then enter directions to location 2, etc.
I only see, in access how to deal with 2 such variables (If, Else). In Filemaker I could use a function called "case" to do this, but I don't know the equivalent.
As long as the location data is in a table, the function you want is DLookup.
You could try the 'Switch' function. You can read about it in the help system - if you have questions then let me know....
Thanks-- I will investigate. Google and help was getting me nowhere without the right search terms.
As long as the location data is in a table, the function you want is DLookup.
I wouldn't use DLookup in a query except in very special circumstances, as there can be major performance penalties. If the location data is in a table you could just add the table to the query, join it to the main table and get it that way.
OTOH, if the mailing list is small, performance shouldn't matter much.
What happens when you shoot an LCD monitor with a high-powered BB gun: [link]
Cool. Liquid crystal displays really do have liquid in them....
Sean, I think you guys should keep this in mind the next time you have a frag party: [link]
My sister has a dead Dell Inspiron 1000 that she needs to get the hard drive out of to transfer the data to a new computer. Since I've turned internal hard drives into external ones before (on desktops), I offered to do the surgery for her. (She's going to buy a cheap 2.5" USB enclosure.)
Is there anything specific I should know about laptops in general, or Dell laptops in particular? I'm pretty confident I can extract it and put it into a new case once I crack the machine open, but I've only done this on desktops before, and I don't want to frell it up.
I've taken apart more Dell laptops that I can count, and all I can say (this is true for all laptop dismantling) is that you need to keep careful track of all the screws by the order which they were taken out, and their size, otherwise you're going to likely be left with some leftover, which is not a good thing.
For hard drives--I don't know about the inspiron 1000 in particular, as we usually had latitiudes, which were lighter and more economical with space--but in Dells, there is usually a slot-out hard drive. You just need to find where it is, and it's usually one screw that allows the drive to just slide out. Disengaging the drive from that slot is pretty straightforward too.
Good luck.
