Recent content by edwilli

I prefer procs for three main reasons: 1. SQL in a stored procedure is optimized for performance after the SQL Server runs it the first time. This doesn't happen with dynamic SQL. 2. Keeping the business logic in a proc allows to reuse the procs with multiple applications. This way I don't...

Users complete an online application using textboxes and such. The data is stored in a database. There is a page on our site - let's call it the "Print Page" - that displays all the data a user entered, and it is formatted for printing; so with the click of a button an administrator can print...

I have a request to create a batch print program that will print the contents of a web page as well any PDF documents that are linked to the page. For example a user fills out a contact information web form and uploads a resume to the site. I would like to create a method that will print the...

I am having trouble applying rules to SharePoint 2007 audiences based on the "member of" option. I want the audience to be a member of a particular security group in my Active Directory. After setting the "member of" option though, SharePoint cannot find any of my security groups. When I...

I have a portal area with the URL www.mysite.com/c1/helpdesk. I want to change the URL to www.mysite.com/helpdesk (remove the "c1") Anyone have tips on how to do this? Eric

I have an event list (i.e. Calendar) with several recurring events on it. One of these recurring events is a weekly meeting we have every Monday. One of these meetings has been canceled, but I can't find a way to delete this single occurrence without deleting the entire series. Am I missing...

We have set up some conference rooms as resources in Exchange. When I use my desktop Outlook to reserve the resource, it books the time on the resource calendar just fine. However, when I try the same thing with the OWA client, the resource receives the request via email, but doesn't...

Oh, and the solution cannot include temp tables. That's cheating! :-)

I have two tables named "People" and "Email". Because people can have more than one email, I created a one-to-many relationship between these two tables with a PK/FK named PeopleID. Now someone has given me a list of 1000 names and email addresses they want added to the database. The list...

Are you sure? In the time since my last post, I've come across documentation saying it's possible as long as both products are located on the same server. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp Admittedly this documentation discusses linking...

Are you sure? In the time since my last post, I've come across documentation saying it's possible as long as both products are located on the same server. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp Admittedly this documentation discusses linking...

I am looking for a way to view and edit Exchange Server data through SQL Server 2000. I idea behind this is to have the ability to run queries on the data. Has anyone connected the two servers before?

My user was connected to an HP LaserJet 5 as well. Great job of sleuthing Vitamin!

That did the trick! You're awesome PHV! And thank you Richard for sending me in the right direction!

Richard I tried applying your Requery suggestion to my existing code, but without success. However I am at a loss as to why it doesn't work. Here is the code from one of my subforms with the Requery included: Private Sub Quantity_AfterUpdate() Me.WorkOrderMaterialPrice.Value =...