Basic Access Query Tips

Here's a useful page on some quick tips when performing MS Access queries.

http://www.fontstuff.com/access/acctut06.htm

Microsoft Office Outlook autocomplete transfer

To transfer the autocomplete data from one computer to the next follow the link below. For Vista or Windows 7 you just need to go to the same directory but instead of "Documents and Settings" you have "Users".

http://office.microsoft.com/en-us/outlook/HA011394511033.aspx

SharePoint Backup And Disaster Recovery with Joel Oleson

Check out this SlideShare Presentation:

SharePoint Backup And Disaster Recovery with Joel Oleson

View more presentations from Joel Oleson.

Repair / Clean print spooler

Read this article to help fix a problem where the print spooler does not start or keeps stopping after each start.

It says for XP but I have tested this on Vista and it corrected the problem I had.

http://support.microsoft.com/kb/324757

You can also use cleanspl.exe from Windows 2003 Resource Kit but this does not work for Vista.

What happens when you run "Repair" on a network connection.

1. Attempt to renew DHCP Lease
2. Flushes ARP cache (arp -d *)
3. Flushes NetBIOS cache (nbtstat -R)
4. Flushes DNS cache (ipconfig /flushdns)
5. Re-Register NetBIOS name and IP address with WINS (nbtstat -RR)
6. Re-Register computer name and IP address with DNS (ipconfig /registerdns)

Absolute positioning in a CSS container

Now this was a real pain to figure out as there wasn't much documentation on it. In order to successfully utilize absolute positioning inside a CSS container where the position will be relative to the container and not the window you will need to define the following:

#container {
position: relative
}

This will ensure that any object placed within this container will be positioned relative to it.

<div id="container">
...
...
...
</div>

IIS 6 - Install IIS using an answer file

Old stuff but I keep forgetting the command line everytime I do it again.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/750d3137-462c-491d-b6c7-5f370d7f26cd.mspx?mfr=true

Using Report Services on a SharePoint 2007 site

First you will need to install the reporting services add-on for SharePoint Server 2007 if you haven't already.

Second, the web parts that will be required for SharePoint to access Report Services will need to be installed.

By default, the webparts are installed with SQL Server 2005 and are located in ..\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab.

You will need to copy this file over to front end web server and run the following command:

stsadm.exe –o addwppack –filename “<path to file>\rswebparts.cab” -globalinstall

Finally, in order to properly get the Web Parts just installed to function on a MOSS2007 setup with Reporting Services you will need to make a change on the site's web.config file. The trust level must be changed to WSS_Medium.

<trust level="WSS_Medium" originalurl="">