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

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

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

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

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

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

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

Information Week's Top Tech Exec for 9/29/2008 "Favorite leisure activity: Spending time with my wife and three kids, who are all under the age of 12" "Talent hits a target no one else can hit; Genius hits a target no one else can see." --- Arthur Schopenhauer

How can I use VBA to add standardized worksheets from a template to an existing workbook? I have a 3-worksheet workbook to which users may want to add standard-form supplemental worksheets. Once these standardized worksheets are imported from another template, formulas for a few cells in Sheet1...

Is it possible to keep Excel 2007 from displaying security warnings about macros? We have some templates that people use on network drives with VBA code we want to run every time, but our users are getting sick of the security warnings. We do not want to always let all Excel files run all macros...

Main form - click on command button to open another form causes the other form to open in an unexpectedly shrunk down state. Sometimes it is flattened, but the same width, sometimes it is very small and can't be clicked on. It is an Access database developed in 2002 and now running under 2007...

I have a database now running under Access 2007 where the reports no longer get filtered via the code behind the scenes. The database is still in the earlier format, BTW. If I open the database in Access 2002, it works like a charm. Any idea what changed in 2007? I'm on another project now and...

Has anyone noticed a significant report generation speed difference between PDF and HTML when generating reports in Cognos 8.x? TIA NorthNone "Talent hits a target no one else can hit; Genius hits a target no one else can see." --- Arthur Schopenhauer

Not a Word wizard, so please bear with me. I've inherited a Word document where one paragraph is duplicated immediately beneath itself. Changes to the first are immediately reflected in its duplicate. This only shows in print layout view, not in other views and it does not print the duplicate...

Does this headline seem strange to anyone else? "Clayton math teacher awarded" "Character cannot be developed in ease and quiet. Only through experience of trial and suffering can the soul be strengthened, ambition inspired, and success achieved." - Helen Keller

Is there an easy way to get the Microsoft Office version installed on a user's machine? "Character cannot be developed in ease and quiet. Only through experience of trial and suffering can the soul be strengthened, ambition inspired, and success achieved." - Helen Keller

Does anyone know a way to open Excel, make a copy under a different name on the user's personal desktop (not all users) and switch the user to that copy AND if the file already exists, prompt them for a new filename? TIA NorthNone "Character cannot be developed in ease and quiet. Only through...

I want to loop through all the cells in a workbook, find those with formulas that begin with =sum( and replace them with the value of the cell. I do NOT want to replace all cells that have formulas with values, just the ones that sum a range of cells. Can anyone help? TIA NorthNone...