Search results for query: *

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

Thanks for taking time to respond, Patrick! I want to display summary information in various categories about a person on a webpage and let the user click a button to show the detail behind the summary information. I'm not writing to tables or the like. I was thinking to create a mega page with...

How can I make a SharePoint page load with a certain table hidden and show that table when the user clicks on a button. I'm a newby to SharePoint and am having trouble finding "cookbook" type help for such issues. Assistance gratefully received! NorthNone "Talent hits a target no one else can...

Aaron, thanks for posting your solution. It worked a charm! "Talent hits a target no one else can hit; Genius hits a target no one else can see." --- Arthur Schopenhauer

Roy, GREAT air-code. It works like a charm. I found the code to generate the initial print screen here: http://www.tek-tips.com/viewthread.cfm?qid=1525020&page=1 Tip of the hat to aarondewberry who recently posted it. A little error trapping and I'm in business. Thanks so much! NorthNone...

Is there code out there for Office 2007 to automate the process of taking a print-screen of the current Access 2007 screen and printing it in landscape mode? I'm thinking of a print preview in Word 2007, but other ideas are welcome. TIA NorthNone BTW I know that the ideal solution is to create a...