w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories
Most Efficient Way To Export Access 2003 Listbox RowSource (query) To Excel 2003
Try generating a XML file. Here an example: http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx P.S. About first method. To avoid users clicks you can hide Excel. Also you can speed up Excel (see functions below). Use Prepare() before putting data and Ended() after it or in case of error. Public Sub Prepare() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False ActiveSheet.DisplayPageBreaks = False Application.DisplayStatusBar = False Application.DisplayAlerts = False End Sub Public Sub Ended() Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic Application.EnableEvents = True ActiveSheet.DisplayPageBreaks = True Application.DisplayStatus

Categories : SQL

Joomla frontpage component template parameter switch
Try the following: <?php $app = JFactory::getApplication(); $menu = $app->getMenu(); if ($frontpageshow){ // show on all pages ?><jdoc:include type="component" /><?php } else { if ($menu->getActive() !== $menu->getDefault()) { // show on all pages but the default page ?><jdoc:include type="component" /><?php } } ?> Hope this helps

Categories : PHP

Do any standards and practices exist for applying acceptance test driven development to non-development tasks?
Take a look at this post in StackExchange: Agile methodologies such as Scrum in non-software development projects Also there is a nice article called "Scrum is not just for software" written by the Agile Alliance (note that this is a PDF download)

Categories : Misc

"The Web server does not appear to have the FrontPage server extensions installed and iis6
FrontPage server extensions (FSE) is a server side package that FrontPage and some other Microsoft applications use to upload files to web sites. FSE must be installed on the server in order for these applications to upload files. FSE has nothing to do with Microsoft desktop products directly. It is often installed on Apache systems, for example. cPanel has an option to install it, if you are using that to manage your server. IIS should come with FSE already installed, AFAIK. That would certainly make sense, with it being a Microsoft product.

Categories : Visual Studio 2010

ODP.NET 32 bit on Win 7 64 bit and Win Server 2003 64 bit
IMO There are a few options: Compile for x86 and install the 32 bit Oracle Client on your 64bit server (could run side by side if you change the ORACLE_HOME, TNS_ADMIN, ... system variables); Compile for x86 and pack all DLL's for a 32 bit Oracle Instant Client together with your binaries (make sure the TNS_ADMIN system variable is set otherwise you won't be able to use LDAP or tnsnames); Compile your application for Any CPU but create a different set of dll's for x64 and x86 bit (Oracle.DataAcess.dll is compiled for a specific architecture, there is a version for x64 and one for x86); Oracle is working on a managed Oracle driver, no Oracle client is required anymore, most codebases can converted easily but be aware that it's not feature complete yet and only supports Oracle 11+ database

Categories : C#

What is the Best way to see a dataset contents in Vs 2003 IDE
Grab the XML Visualizer 1.0 for Visual Studio 2003 from Google Drive while it's still there. Maybe someone else will also find this link useful in the future.

Categories : C#

How to use InStr function in VBA 2003?
Start index of InStr function is 1-based => 0 is invalid value. See Exceptions section of http://msdn.microsoft.com/en-us/library/8460tsh1%28v=vs.80%29.aspx

Categories : Excel

IFERROR in Excel 2003
The Excel 2003 equivalent of =IFERROR(A1,"") is =IF(ISERROR(A1),""). See =IS. But neither version of that formula is very useful. A little more useful would be something like =IF(ISERROR(A1),0) where an error in A1, perhaps resulting from dividing by zero, is elsewhere (ie in the cell with the formula) displayed as 0. The trouble with the single comma is that if ISERROR() is false (ie A1 is not an error) this returns FALSE - not particularly helpful but relatively confusing! So these formulae are normally used with another formula instead of A1. That is, one formula is wrapped around another. The later Excel version might have =IFERROR(A1/B1,""). Thus, if A1 contained 1 and B1 2, the result would be 0.5 whereas if A1 then were changed to become #REF! the result would be blank (nothing

Categories : Excel

Connect to Sharepoint 2003 in C# WPF
There are 2 ways: a. Using Sharepoint web services Suppose your sharepoint server URL is as follows https://MyDomain/MySite/default.aspx Then replace default.aspx with /_vti_bin/lists.asmx to get list of web services expose by sharepoint. https://MyDomain/MySite/_vti_bin/lists.asmx This will provide you with list of all operations exposed by service. You can use GetList to get calendar list and check if you get desired result. b. Uisng Sharepoint object model and Microsoft.Sharepoint.dll (WPF application can run on same server where sharepoint is installed)

Categories : C#

Access 2003 VBA - Validate XML schema XSD & DOM
instead of : objSchemaCache.Add "http://somewhere.com/root", LoadXmlFile(AwardsXSDPath) did you try something like this : objSchemaCache.Add "http://somewhere.com/root", "C:...PathToMySchemaMySchema.xsd"

Categories : Xml

batch script works on win 7 but not win 2003
The file may be in a different location on the other machine. Try this: @echo off setlocal set "file=C:Documents and Settingsspati41My DocumentsMy Tableau RepositoryDatasourcesOFFR STA Event Trigger Extract.tde" if not exist "%file%" echo "OFFR STA Event Trigger Extract.tde" file is missing & pause set maxbytesize=900 FOR %%A IN ("%file%") DO SET size=%%~zA if %size% LSS %maxbytesize% ( echo.File is ^< %maxbytesize% bytes ) ELSE ( echo.File is ^>= %maxbytesize% bytes )

Categories : Batch File

Excel 2003 not giving me 1 decimal when the
If representing the number as text is acceptable, the following will solve your problem: =IF($E$13>200,ROUND($E$13,0),IF(ROUND($E$13,0)=ROUND($E$13,1),CONCATENATE(ROUND($E$13,0),".0"),ROUND($E$13,1))) If you need to use your number in future calculations, be sure to use the original number, which can be obtained via ROUND($E$13,1).

Categories : Misc

xml to excel 2003 issue with datetime
Why Data ss:Type= "DateTime" when you are converting it to string data type here Convert.ToDateTime(dsReportData.Rows[i]["close_time"]).ToString("M/D/YYYY H:MM") ? Also format you specified must be replaced. Replace "M/D/YYYY H:MM" with "M d yyyy H:MM" or "M/d/yyyy H:MM". As the format is case sensitive To keep DateTime type use: Convert.ToDateTime((Convert.ToDateTime(dsReportData.Rows[i]["close_time"])).ToString("M d yyyy H:MM"));

Categories : C#

Update Query in MS-Access 2003
You could use a SELECT query with a correlated subquery to retrieve the appropriate PersonId for each MachineId. SELECT d.MachineId, ( SELECT TOP 1 v.PersonId FROM Visit AS v INNER JOIN Calls AS c ON v.CallId = c.CallId WHERE c.MachineId = d.MachineId ORDER BY v.Date DESC ) AS person_id FROM Details AS d; The advantages of this approach are that it is fairly simple and the result would always be consistent whenever the data changes in the Visit and/or Calls tables. In other words, you wouldn't need to execute an UPDATE to see the latest result. If you have a need to change stored values in Details.PersonId, you can't simply use the correlated subquery directly because Access will complain "Operation must

Categories : SQL

using ELMAH with visual studio 2003
I have found all the answers for elmah at the following location: Elmah Help for .NET 1.1 applications

Categories : Misc

Printing Excel 2003 sheet using c#
So basically the best way I figured out to do this is using Microsoft.Office.Interop.Excel object misValue = System.Reflection.Missing.Value; Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = excelApp.Workbooks.Open(Form1.excelPath, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue); Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1]; //bring about print dialogue bool userDidntCancel = excelApp.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlDialogPrint].Show(misValue, misValue, misValue, misValue, misValue, misValue, misValue, mis

Categories : C#

Excel 2003 difference between .xlm behaviour
Regional settings play a factor here so my setup may be a bit different than what you have. However in A2 I keyed in 1/11/2012. I set B2 formula = A2 and C2 formula = A2. Notice how the display is different for each of the two results. This is because I have formatted the columns B and C to be in different display (masks) formats. It is possible you have a similar issue on the sheet with "NOVEMBER" being displayed.

Categories : Excel

How to write hex and binary constants in .NET 2003
The closest you might be able to do in C# is define it as a string and use Convert.ToInt (or etc.) var flags = Convert.ToInt32( "00010010", 2 ); Which is functional, but verbose and pretty bleh. You might (if you are crazy) consider an extension method public static class Extensions { public static Int32 toInt(this string me) { return Convert.ToInt32(me, 2); } } (...) var myflags = "00010010".toInt(); (...)

Categories : C#

Excel 2003 copy worksheet
Consider something like: Sub dural() Dim alpha As Workbook, beta As Workbook Workbooks.Open Filename:="C:TestFolderalpha.xlsm" Set alpha = ActiveWorkbook Workbooks.Open Filename:="C:TestFoldereta.xlsm" Set beta = ActiveWorkbook alpha.Sheets(1).Copy Before:=beta.Sheets(1) End Sub

Categories : Excel

Microsoft.ACE.OLEDB.12.0 for MS Access 2003
I would store the available connection strings in a table, along with a Yes/No field called "Active". Then, when the app is launched you can determine which version of Office is installed, set the Active field for that record to "Yes", and have your database pull the connection string out of the table based on which record is active. Easily done with a DLookup command. Bada-Bing! Going forward, you just need to distribute a new version of the table with any additional connection strings you may need. This way, you don't have to keep re-writing or re-editing the code. Making everything table-driven has saved me WEEKS of coding time on projects I've worked on...

Categories : C#

VBA 2003 file search error
Here's a Sub which can do the work of FileSearch (at least as you use it..) 'Fill a Collection with all files matching "Pattern" ' Optionally search subfolders Sub GetFiles(StartFolder As String, Pattern As String, _ DoSubfolders As Boolean, ByRef colFiles As Collection) Dim f As String, sf As String, subF As New Collection, s If Right(StartFolder, 1) <> "" Then StartFolder = StartFolder & "" f = Dir(StartFolder & Pattern) Do While Len(f) > 0 colFiles.Add StartFolder & f f = Dir() Loop sf = Dir(StartFolder, vbDirectory) Do While Len(sf) > 0 If sf <> "." And sf <> ".." Then If (GetAttr(StartFolder & sf) And vbDirectory) <> 0 Then subF.Add Start

Categories : Vba

Nodejs on Windows Server 2003
Your firewall settings blocks incoming requests on port 1337 if its not configured. You may have do chances in firewall settings, you need to add firewall inbound rule on this port to allow access to it. Otherwise you may try changing the port to 8080 or 8000 which firewall mostly allows. (updated as per the suggestions form adam-stanley) If you want to look how to add port to firewall on Windows, here is the link

Categories : Windows

Mysql Error 2003-Ubuntu
1). enable Remote Access 1.nano /etc/mysql/my.cnf 2.comment the quoted content bind-address = 127.0.0.1 use # symbol 3.restart MySQL server 2). create a database create database db_name; 3). Create user and grant PRIVILEGES This assume you put the web server and mysql at the same IP. CREATE USER 'user_name'@'10.9.247.140' IDENTIFIED BY 'pwd'; GRANT ALL ON db_name.* to 'user_name'@'10.9.247.140' IDENTIFIED BY 'pwd'; FLUSH PRIVILEGES; mysql --host=10.9.247.140 --user=user_name --password=pwd db_name If the web server is using another IP, replace the 'user_name'@'10.9.247.140' with the real one.

Categories : PHP

MS Access 2003 Company Report
[table].[CompanyID] & "-" & [table].[LoBID] http://www.techonthenet.com/access/queries/concatenate.php

Categories : Mysql

Outlook 2003 form Macro
This HTML email creater. Insert this into the "Visual Basic Editor in Tools>Macro then run the macro "emailpictures". It will ask for validation. Sub emailpicture() Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) Set objOutlookRecip = objOutlookMsg.Recipients.Add("companyemail@email.com") objOutlookRecip.Type = olTo objOutlookMsg.Subject = "Picture" ' add "C:picture.png as attachment to Outlook message Set colAttach = objOutlookMsg.Attachments Set l_Attach = colAttach.Add("C:pathimage.jpg") ' Dereference the attachment objects before changing their properties via CDO Set colAttach = Nothing Set l_Attach = Nothing 'Set body format to HTML objOutlookMsg.BodyFormat = olFormatHTML objOutlookMsg.HTMLBody = "<HTML><

Categories : Vba

Working with Outlook using MS Access 2003 - VBA
I don't get the fact that you declare an object of type IPM.Note and try to send it, declare a mailitem instead. this should work 'Loop through the records For i = 0 To intNumRecords Set olMailItem = olFolder.Items.Add 'Subject olMailItem.Subject = "Mailing List Test" 'Recipient/s olMailItem.To = fld.Value 'Body of email olMailItem.Body = strBodyText 'Automatically send the email olMailItem.Send 'Release new mailitem Set olMailItem = Nothing 'Move to the next record rcdSet.MoveNext Next Checkout http://msdn.microsoft.com/en-us/library/office/bb220348(v=office.12).aspx for more info on the add method. EDIT: see full loop

Categories : Vba

Write excel 2003 files from python 3.x
Open them with Excel 2007 and save them as Excel 2003. You can do it with a simple VBA macro, or from Python, without even showing the Excel application to the user. The only problem is that you need Excel in your computer. Here is the VBA code: Sub ConvertTo2003(FileName As String) Dim WB As Workbook Set WB = Workbooks.Open(FileName, ReadOnly:=True) WB.SaveAs Replace(FileName, ".xlsx", ".xls"), FileFormat:=xlExcel8 WB.Close End Sub Here is the Python code: xlApp = Excel.ExcelApp(False) xlApp.convertTo2003('FileName.xlsx') class ExcelApp(object): def __init__(self, visible): self.app = win32com.client.Dispatch('Excel.Application') if visible: self.app.Visible = True def __exit__(self): self.app.Quit() def __del__(self):

Categories : Excel

conect to microsoft 2003 database from android
See answers here: Connecting android with MS SQL SERVER 2008 You should really use a webservice, connecting to the database is not the best practice.

Categories : Java

WPF Visibility Issue Windows Server 2003
You are using different versions of .NET (4.5) on you dev machine, which is only impersontating 4.0 version. It turns out there are some incompatibilities between those two versions (errors which were fixed in 4.5 would not occur even if you are downtargetting 4.0). In my work with .NET 4.0 (which you are using on your 2003 server), I've found that sometimes StaticResource malfunctions in DataTemplates. This issue was fixed with 4.5 release, so thats why you do not get those problems. You should change: EDIT: Following is not working because Converter is not a dependency property. Visibility="{Binding ShowSearch, Converter={StaticResource Bvc}}" to Visibility="{Binding ShowSearch, Converter={DynamicResource Bvc}}"

Categories : C#

Import into SQL Server 2003 from a CSV file Error
It might not be that SQLServer is complaining about losing data when importing but when reading. For instance, the DT_DBTIMESTAMP type expects the format yyyy-mm-dd hh:mm:ss[.fff]. If your data is not formatted correct in any dimension (say your mm > 12 or dd > 31) that may be the problem. Like @Pondlife suggested I'd bring everything into a varchar(max) field and then run TSQL to see if all rows can convert to DBTIMESTAMP data type is a simple convert statement.

Categories : Sql Server

Resolve c++ pointer-to-member error in VS 2003
since you have: static BOOL CRrDoc::cFldFilter(LPMFFIELD f); its type is not a member variable but a function: //BOOL CRrDoc::*zcFldFilter = &CRrDoc::cFldFilter; // doesn't work BOOL (*zcFldFilter)(LPMFFIELD) = &CRrDoc::cFldFilter; // works Since dlg.ck is of a correct type, you should do dlg.ck = &CRrDoc::cFldFilter;

Categories : C++

Get-ScheduledTask in PowerShell on Windows Server 2003
You'll find all the informations you need about the missing COM object in Working with scheduled tasks from Windows PowerShell. Using Windows Server 2012 you can use Scheduled Tasks Cmdlets in Windows PowerShell.

Categories : Powershell

access 2003 text display leading zero
Do you really want you users to manually edit that field? I don't like solutions like this, because it's error-prone (unless you check a lot of things to make sure that no one enters invalid data) and feels unelegant to your users. I would just save the following in the table: the vehicle number in a numeric field (22, not 0022) a boolean field which indicates if the vehicle is retired This is much easier for your users to work with: they can just enter new vehicle numbers without having to think about leading zeros to retire a vehicle, they just need to set a checkbox, instead of putting the right letter in front of the vehicle number Plus, showing the desired number R0022 now becomes just a matter of displaying/formatting the data from the table: Public Function GetDisplayNo(Ve

Categories : Ms Access

VBScript Cannot Find file Specified Server 2003
Most likely the Open method of Office 2003 doesn't support wildcards in the path. You'll have to enumerate the files in that folder: Set app = CreateObject("Excel.Application") Set fso = CreateObject("Scripting.FileSystemObject") For Each f In fso.GetFolder("Y:Billing_Commonautoemail").Files If LCase(fso.GetExtensionName(f)) = "xls" Then Set wb = app.Workbooks.Open(f.Path) ... wb.Close End If Next

Categories : Excel

workaround to VB.Net 2003 System.Collections.Generic?
Use ArrayList, like this: Dim BoxList As New ArrayList Dim box = New Box() box.x = 1 box.y = 2 BoxList.Add(box) Note: It is recommended that you add a constructor to the Box class that will accept the x and y values, like this: Public Class Box Public x As Integer Public y As Integer Public Sub New(ByVal _x As Integer, ByVal _y As Integer) x = _x y = _y End Sub End Class Now you can shorten your ArrayList code to this: Dim BoxList As New ArrayList BoxList.Add(New Box(1, 2)) To use the values in the ArrayList you will need to un-box (pun not intended) the value out of the ArrayList, like this: For Each box In BoxList ' Use x value, like this CType(box, Box).x Next OR (as Meta-Knight suggested) For Each box As Box In BoxList ' Now box

Categories : Vb.Net

MySQL Error Number 2003 on windows 8
The server not starting mostly happens with permission issues or installation errors. Please check if there is any permission issues or try to reinstall mysql. Please check the following link for more info Can't connect to [local] MySQL server

Categories : Mysql

How to access ssas cube in excel 2003?
Run excel using credentials for connecting ssas server as: Runas /user:[DOMAIN][USERNAME] "[PATH TO EXCEL.EXE]". Then, use Data->From Other Source->From Analysis Service and Provide servername and use windows authentication.

Categories : Sql Server

WPF:DataGridTemplateColumn on Windows server 2003/2008
Finally tested RelativeSource instead of ElementName. And after a day of time wasting worked fine on Win Server!! Solution !!: <DataGridTemplateColumn CellStyle="{x:Null}" Width="85" Header="{Extentions:DisplayName Type=Type:StandardClass, PropertyName=ProductKind}"> <DataGridTemplateColumn.CellEditingTemplate> <DataTemplate> <ComboBox ItemsSource="{Binding Path=DataContext.ProductKindCollection,RelativeSource={RelativeSource AncestorType=DataGrid}}" DisplayMemberPath="Title" Style="{x:Null}" SelectedValue="{Binding ProductKind, ValidatesOnDataErrors=True, ValidatesOnExceptions=True, Upd

Categories : Wpf

converting 8/17/2003 to boost::gregorian::date
From the boost examples: // The following date is in ISO 8601 extended format (CCYY-MM-DD) std::string s("2001-10-9"); //2001-October-09 date d(from_simple_string(s)); std::cout << to_simple_string(d) << std::endl; You have the format incorrect.

Categories : C++

Detect windows 2003 and XP using batch file
try this: @echo off setlocal EnableDelayedExpansion ::Identify OS for /F "delims=" %%a in ('ver') do set ver=%%a set Version= for %%a in (95=95 98=98 ME=ME NT=NT 2000=2000 5.1.=XP 5.2.=2003 6.0.=Vista 6.1.=7 6.2.=8) do ( if "!Version!" equ "this" ( set Version=Windows %%a ) else if "!ver: %%a=!" neq "%ver%" ( set Version=this ) ) ::Identify bit if exist "%SYSTEMDRIVE%Program Files (x86)" ( set Type=64 bit ) else ( set Type=32 bit ) ::Display result echo %Version% %Type% goto :eof ::Goto right version goto %Version: =_% :Windows_8 echo Windows 8 :Windows_7 echo Windows 7 © Aacini

Categories : Batch File



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.