Search results for query: *

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 =...

I have a work order form with 3 embedded subforms. Each of the subforms contains one or more items with its price, and a total price for all subform items. There is a calculated control on the main form that adds together the price totals from each subform. Users can add, change, or delete the...

The error handling tips do allow for a graceful exit. However the problem I'm having is that the 2501 error shouldn't be happening in the first place. The code works on all machines except one. I've googled other threads that report similar problems, but up to now no one has reported a solution.

I have a simple form in an Access Project (2003) where a user selects a value from a dropdown list and clicks "Submit"; which runs VBA code to open a report with the selected value used in the where clause. The form works perfectly on my computer and most client computers. However there is one...

I have the same problem as the original postee, but I don't have the WRKGADM.EXE file on my desktop. What's worse is that I did name the workgroup file SECURITY.mdw Is there any other way to undo this mess?

After creating a database, I ran the security wizard in Access. Now not only can I not get into my new database, but I am locked out of all the old ones as well!! What did I do wrong, and how do I fix it?? Eric