OWA permission attribute in AD
First you need to tell us what version of exchange you are using. Please provide those details. Thanks.
View Answer
| May 21, 2008 3:06 PM
Active Directory, Outlook, Outlook Web Access, OWA, Scripting, VBScript, Windows scripting
First you need to tell us what version of exchange you are using. Please provide those details. Thanks.
I Put a HEX on youuuuuuuu……
Here’s a starting <a href=”http://www.cs.tut.fi/~jkorpela/chars.html”>tutorial</a>. Another good resource can be found <a href=”http://www.i18nguy.com/unicode/codepages.html”>here</a>.
View Answer
| May 21, 2008 3:02 PM
Binary, CL, CLLE, CLP, EBCDIC, Hex, RPG, RPGLE
Here’s a starting <a href=”http://www.cs.tut.fi/~jkorpela/chars.html”>tutorial</a>. Another good resource can be found <a href=”http://www.i18nguy.com/unicode/codepages.html”>here</a>.
Excel 2007 Macros problem
Go to tools/security and set a correct protection level, this may solve your problems, <a href=”http://office.microsoft.com/en-us/excel/HA100310711033.aspx”>this</a> explains the process.
View Answer
| May 21, 2008 1:12 PM
Excel 2007, Excel macros, Microsoft Excel
Go to tools/security and set a correct protection level, this may solve your problems, <a href=”http://office.microsoft.com/en-us/excel/HA100310711033.aspx”>this</a> explains the process.
replace field with count variable in foxpro
Hello, I’m not sure I understood what you mean exactly but I suppose you are using SQL queries to read your data. So I suggest you using a query as the following: <pre>SELECT (ROW_NUMBER() OVER (ORDER BY YourField ASC)) as MyCounter , FieldA, Fieldb FROM YourTable</pre> That will number the returned rows with increments. E.g. [...]
View Answer
| May 21, 2008 7:18 AM
Database programming, FoxPro, SQL, VB, Visual Basic
Hello, I’m not sure I understood what you mean exactly but I suppose you are using SQL queries to read your data. So I suggest you using a query as the following: <pre>SELECT (ROW_NUMBER() OVER (ORDER BY YourField ASC)) as MyCounter , FieldA, Fieldb FROM YourTable</pre> That will number the returned rows with increments. E.g. [...]
vb.net
you can download your project by setp project in another computer but you musat have .net framwork in other computer no important to have vs.net
View Answer
| May 21, 2008 6:48 AM
VB.NET, Visual Basic .NET, Visual Studio, Visual Studio 2003
you can download your project by setp project in another computer but you musat have .net framwork in other computer no important to have vs.net
whate a differance between ado.net and sql and datadapter
Hello B.rashed, as for my experience the main difference is in how data are manipulated in your programs. With SQL you tend to work <i>live</i> with data while with Ado.Net you may have datasets that retreive data, manipulate it and then send back to the source, this would solve lots of issues related to delays, [...]
View Answer
| May 21, 2008 6:47 AM
ADO.NET, datAdapter, VB.NET, Visual Basic .NET
Hello B.rashed, as for my experience the main difference is in how data are manipulated in your programs. With SQL you tend to work <i>live</i> with data while with Ado.Net you may have datasets that retreive data, manipulate it and then send back to the source, this would solve lots of issues related to delays, [...]
Working with Excel in ActiveX DLL
Men Your problem has a silent m
View Answer
| May 20, 2008 9:06 PM
ActiveX, DLL, Microsoft Excel, OCX, VB, Visual Basic
Men Your problem has a silent m
eJabber IM Service
Hello, have a <a href=”http://www.process-one.net/docs/ejabberd/guide_en.html#htoc44″>look at this </a>that explains how to log to HTML. Bye
View Answer
| May 20, 2008 4:33 PM
eJabber, Instant Messaging, Linux, Open source Web services
Hello, have a <a href=”http://www.process-one.net/docs/ejabberd/guide_en.html#htoc44″>look at this </a>that explains how to log to HTML. Bye
2D arrays
The following Code snippet creates a two dimentional array of integers that contains five columns of ten digits. The digits in each column are set equal to the column index by the procedure named FillArray (The first column contains 0′s, the second contains 1′s and so on). The procedure named Sum demonstrates only one of [...]
View Answer
| May 20, 2008 1:57 PM
2D arrays, VB.NET, Visual Basic .NET
The following Code snippet creates a two dimentional array of integers that contains five columns of ten digits. The digits in each column are set equal to the column index by the procedure named FillArray (The first column contains 0′s, the second contains 1′s and so on). The procedure named Sum demonstrates only one of [...]
Return zero when there’s no data
Hello DenM, you can use the SQL function <i>IsNull</i>, that’s to say: <pre> SELECT ISNULL(MYFIELD,0) AS MYVALUE FROM MY TABLE</pre> Bye
View Answer
| May 20, 2008 5:37 AM
Excel 2003, Microsoft Excel, SQL, SQL Query
Hello DenM, you can use the SQL function <i>IsNull</i>, that’s to say: <pre> SELECT ISNULL(MYFIELD,0) AS MYVALUE FROM MY TABLE</pre> Bye
how to fetch data from notepad in vb6?
I don’t know if VBA has specific hooks for Notepad, but Notepad docs are just plain text, which is fairly easy to retrieve in VBA. Microsoft has a page on using <a href=”http://msdn.microsoft.com/en-us/library/czxefwt8(VS.85).aspx”>FileSystemObject to open text files</a> that contains instructions and sample code that will probably set you on your path. HTH. Hi Morfs, Same [...]
View Answer
| May 19, 2008 6:57 PM
Data, Notepad, VB, Visual Basic, Visual Basic 6
I don’t know if VBA has specific hooks for Notepad, but Notepad docs are just plain text, which is fairly easy to retrieve in VBA. Microsoft has a page on using <a href=”http://msdn.microsoft.com/en-us/library/czxefwt8(VS.85).aspx”>FileSystemObject to open text files</a> that contains instructions and sample code that will probably set you on your path. HTH. Hi Morfs, Same [...]
How can I display an attachment as an object in a Lotus Notes field?
You should just be able to do this using a rich text field and attaching it there…. has always worked for me.
View Answer
| May 19, 2008 2:37 PM
Lotus development, Lotus Notes, Web development
You should just be able to do this using a rich text field and attaching it there…. has always worked for me.
Random number generation
Hello, hereafter an example code: <pre> Dim numbers Dim letters Dim ID Randomize numbers=”0123456789″ letters=”abcdefghijklmnopqrstuvwxyz” for i=1 to 10 if i mod 2 <> 0 Then ID = ID & mid(letters,Int((26*Rnd) +1),1) Else ID = ID & mid(numbers,Int((10*Rnd) +1),1) end If Next wscript.echo ID </pre>
View Answer
| May 19, 2008 6:45 AM
Random Number Generator, SQL, SQL Server
Hello, hereafter an example code: <pre> Dim numbers Dim letters Dim ID Randomize numbers=”0123456789″ letters=”abcdefghijklmnopqrstuvwxyz” for i=1 to 10 if i mod 2 <> 0 Then ID = ID & mid(letters,Int((26*Rnd) +1),1) Else ID = ID & mid(numbers,Int((10*Rnd) +1),1) end If Next wscript.echo ID </pre>
coloring rows “if” true
If you are using Excel you have the conditional format where you can define 3 rules to change the visual format of the data when the conditions are satisfied. Example: In the AMOUNT columns you define that : <ol> if cell value is greater than 0 it will be colored green if cell value is [...]
View Answer
| May 17, 2008 5:57 PM
Conditional expressions, Conditional formatting, Excel 2003, Microsoft Excel
If you are using Excel you have the conditional format where you can define 3 rules to change the visual format of the data when the conditions are satisfied. Example: In the AMOUNT columns you define that : <ol> if cell value is greater than 0 it will be colored green if cell value is [...]
how to open media fils?
You can do this in two ways: <ol> You add the Media Components and then pass the file name to the component You perform a <i>shell</i> command that will open <i>Windows Media Player</i> and passing the file path and name as argument </ol> Example <pre> Private Sub Command1_Click() Dim path As String Dim runExe As [...]
View Answer
| May 17, 2008 5:43 PM
DialogBox, VB, Visual Basic 6
You can do this in two ways: <ol> You add the Media Components and then pass the file name to the component You perform a <i>shell</i> command that will open <i>Windows Media Player</i> and passing the file path and name as argument </ol> Example <pre> Private Sub Command1_Click() Dim path As String Dim runExe As [...]
DataGrid
Hello, adjust and use the following queries to match your needs (change the YOURFILED to match your own). <pre> SELECT COUNT(YOURFIELD) AS COUNTPs WHERE YOURFIELD=”P” SELECT COUNT(YOURFIELD) AS COUNTAs WHERE YOURFIELD=”A” </pre> Bye
View Answer
| May 17, 2008 5:35 PM
DataGrid, Web development
Hello, adjust and use the following queries to match your needs (change the YOURFILED to match your own). <pre> SELECT COUNT(YOURFIELD) AS COUNTPs WHERE YOURFIELD=”P” SELECT COUNT(YOURFIELD) AS COUNTAs WHERE YOURFIELD=”A” </pre> Bye
How to get the PID if you know the Image Name
Hello, in <b>VBScript+WMI</b> you can do this with the following code: <pre>Function FindPID(MyProcess) Set objWMIService = GetObject(“winmgmts:{impersonationLevel=impersonate}!\.rootcimv2″) Set colProcessList = objWMIService.ExecQuery(“Select * from Win32_Process”) For Each objProcess in colProcessList If objProcess.Name = MyProcess Then Result = objProcess.ProcessID End if Next End Function </pre> I hope this helps.
View Answer
| May 16, 2008 4:42 PM
Batch, PID, Product ID, VB.NET 2005 Express Edition, Visual Basic 2005
Hello, in <b>VBScript+WMI</b> you can do this with the following code: <pre>Function FindPID(MyProcess) Set objWMIService = GetObject(“winmgmts:{impersonationLevel=impersonate}!\.rootcimv2″) Set colProcessList = objWMIService.ExecQuery(“Select * from Win32_Process”) For Each objProcess in colProcessList If objProcess.Name = MyProcess Then Result = objProcess.ProcessID End if Next End Function </pre> I hope this helps.
Using xp_cmdshell
This will be because the Windows Account which the SQL Server runs under doesn’t have access to the network share. You will need to grant access to the network share and then your command should run.
View Answer
| May 15, 2008 8:02 PM
DataCenter, Desktops, Development, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
This will be because the Windows Account which the SQL Server runs under doesn’t have access to the network share. You will need to grant access to the network share and then your command should run.
sql server reporting server
Make sure that you have the SSRS web server setup for anonymous access.
View Answer
| May 15, 2008 7:59 PM
ASP.NET, Reporting Services, SQL Server 2000
Make sure that you have the SSRS web server setup for anonymous access.
API information
Hi, I assume from your other questions that you mean API’s on iSeries/AS400? In that case here’s a good place to start :- <a href=”http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/apiref/api.htm”>I5 API’s</a> Regards, Martin Gilbert.
View Answer
| May 15, 2008 3:38 PM
API, Application Programming Interface, Development, Software development
Hi, I assume from your other questions that you mean API’s on iSeries/AS400? In that case here’s a good place to start :- <a href=”http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/apiref/api.htm”>I5 API’s</a> Regards, Martin Gilbert.





