Recent content by NorthNone

An .accdb database requires a password which I want to remove. When I go to "On the File tab, click Info, and then click Decrypt Database..." instead of "Decrypt Database" I see "Encrypt with Password". So I tried going with the flow and encrypting the database, but always get "Not a Valid...

Thanks so much, Mark. Have a star!

How can I check whether the max values for the same field in two separate tables are equal? Could a stored procedure do this? Then I'd use the SP result in SSIS to stop a load process because data are not up-to-date. Thanks, Jean

If the witness was lying in the street, how did the witness find them?

Is there something like sysprint.sep but that uses less toner per page - perhaps by utilizing smaller fonts, less bolding, and/or fewer horizontal lines? TIA NorthNone

P.S. Have a STAR!

[bigsmile] Works a treat! I am MOST grateful. THANKS!!!! [thumbsup2]

Is it possible in Cognos Report Studio 8.3 or 8.4 to create a report that summarizes last year's budget as a total number, then use that total as part of a calculation in the same list report? The goal is to have a running total for the new budget AND show what percent it is of last year's...

Thanks again. I'll give those things a try.

Thanks, Carl. It would be better said that from an existing SharePoint site (which resides on a SQL backend), I would like to display from a different SQL Server database via a WebPart data.

I've connected lots of VB and Access front-ends to SQL Server back-end databases and it has been very easy. Is it also easy to connect SharePoint to a SQL Server back-end database? TIA NorthNone P.S. we have MOSS

lhuffst - I have attempted to duplicate your compile error. When I put Aaron's code into a module, it compiled just fine. When I tried to put code behind a form, it would not compile. But you specifically mention putting it in a module, so that must not be the problem. Is there any more to the...

On an ASPX webpage, no SharePoint web parts at the moment. There is an ASP.net control from which an employee can be selected. Data is filtered to show only that which applies to the selected employee.

There has to be an easy SharePoint way to display a different picture depending on which employee's record you are viewing on a SharePoint page. Assistance GRATEFULLY received (sorry for shouting)! NorthNone "Talent hits a target no one else can hit; Genius hits a target no one else can see."...

Richard: I am trying to get a view-only Access database to SharePoint in a way that Access is completely abandoned. So I've brought in the tables as lists. The top level list drives whose data is displayed in the mid-level list and the detail-level list. Top, mid and detail level lists are...