The procedure entry point IsThreadDesktopComposited could not be located in the dynamic link

13-Aug-0909 Leave a comment

Windows Live Writer. Error on entry

The procedure entry point IsThreadDesktopComposited could not be located in the dynamic link
 
I renamed dwmapi.dll to dwmapi.dll.bak and the error disappeared in UR, but God only knows what else that will affect. While running IE7 inside of UR there does not seem to be any problems.
 
SRS 13-Aug-2009
Did this and problem has gone away
 

Filed under Windows

MS Access 2007 Create MDE for use with MS Access 2003 or earlier

13-Aug-0909 Leave a comment

If starting with MS Access 2007 then making an MDE it is not possible to open this MDE from earlier versions.
You may think that saving the database in MS Access 2002-2003, then making the MDE would work. However it will not.

A solution:

  • Save as MS Access 2002-2003. Perhaps with a different name say MyApp2002.mdb
  • Open the new 2002-2003 database in MS Access 2002 or 2003 on another machine.
  • Make the MDE file from this machine as MyApp.mde
  • Voila !! Should now work

Another more complicated solution:

  • Distribute the application from MS Access 2007
  • Use MS Access 2007 run-time

Steve 13-Aug-2009

Filed under MS Office

You may receive write conflict errors when you update records of a linked SQL Server table in Access 2000

10-Aug-0909 Leave a comment

 
 
Add a timestamp. Even if a view include this column.
 

Filed under MS Office

Search Crystal Reports in Visual Studio for table/procedures

03-Aug-0909 Leave a comment

 
 
This is a part of the VB proc I built to generates the list of all tables used by my reports. Reports are listed in a ‘reports Table’, and I use a memo field to store the name of all used tables. It is then quite easy to update all requested reports once tables have been modified.
Publicfunction tablesUsedByAReport(myReportName asstring)asstringDim m_report As CRAXDRT.Report, _      m_crystal As CRAXDRT.Application, _      m_tablesUsedByAReport AsStringDim m_table As CRAXDRT.DatabaseTable, _      m_section As CRAXDRT.section, _      m_objet AsObject, _      m_subReport As CRAXDRT.SubreportObjectSet m_crystal =New CRAXDRT.ApplicationSet m_rapport = m_crystal.OpenReport(m_nomRapport,1)'table names in the report'ForEach m_table In m_rapport.Database.tables    m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"Next m_table 'table names in each of the subreports'ForEach m_section In m_rapport.Sections    ForEach m_objet In m_section.ReportObjects        If m_objet.Kind= crSubreportObject Then            Set m_subReport = m_objet            Set m_report = m_subReport.OpenSubreport            ForEach m_table In m_rapport.Database.tables                m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"           Next m_table        EndIf    Next m_objetNext m_section 'my tables list'tablesUsedByAReport = m_tablesUsedByAReport Endfunction

 

Filed under Crystal Reports, Visual Studio

How to add a network place directed to your own PC

22-Jul-0909 Leave a comment

 
How to add a network place directed to your own PC
 
file://C:\Documents and Settings\UserName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates\Sql

Filed under Windows

Office save/backup my settings

21-Jul-0909 Leave a comment

 
Save My Settings does not exist in Office 2007.
However see below copied from link:
 
 
1. The Quick Access Toolbars for Excel, Word, and PowerPoint are saved in
separate ".QAT" files (stands for Quick Access Toolbar), in the following
directory in Windows XP:

C:\Documents and Settings\(User Name)\Local Settings\Application
Data\Microsoft\Office

In that folder look for:    Excel.qat, PowerPoint.qat, Word.qat, etc.
So for example, if you want to transfer your Excel toolbar settings to
another computer, or after you reinstall Office 2007, just copy your custom
Excel.qat to that same folder, replacing the original.

 
2. All other settings (options menu) are stored in the registry here:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0

You can just export the whole "12.0" registry tree to a .REG file, and store
it somewhere. When you need to use it (after reinstall or on a different
computer), just double click on that REG file to update the registry.  Before
you do that, I suggest that you backup your registry just to be safe, if
something goes south.

Good luck

 
 
 
 
 

Filed under MS Office

Talking about Tip/Trick: Hard Drive Speed and Visual Studio Performance – ScottGu’s Blog

02-Jul-0909 Leave a comment

 
 
 
Importance of Hard Disk Speed on new PC / Laptop especially for Visual Studio 2008
Edited from Windows Live Writer

Filed under Computers

Desktop Search Enable / Disable

26-Jun-0909 Leave a comment

 
 
 

In RegEdit, go to HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS and set "ShowStartSearchBand" to 0, and you’ll get the default search behavior back.

And while you’re at it and poking around in the registry, you might as well go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex and set FilterFilesWithUnknownExtensions to DWORD with the value of "1" in order to enable full-text searching of files (like code!) that Explorer by default skips over.

I am also trying
MSConfig 
and Start Control Panel Administrative Tools Services

Steve

 
 

Filed under Windows

Newer posts →