15,867,870 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by archies_gall (Top 39 by date)
archies_gall
16-Aug-14 1:31am
View
Any help on this?
archies_gall
13-Aug-14 13:54pm
View
This is what i have done. The code works only for 1st value but i guess some for loop issue because of which it is not working for other values. Code is:
Sub findvalue()
Dim a As String
Dim b As String
Dim someSheet As Worksheet
Dim i As Integer
Dim cell As Range
a = ActiveCell.Value
Dim LastRow As Long
With ActiveWorkbook.Sheets("Sheet2")
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With
MsgBox LastRow
For i = 2 To LastRow
b = Sheet2.Range("A" & i).Value
If a = b Then
Set someSheet = ActiveWorkbook.Sheets("Sheet2")
someSheet.Activate
ActiveWorkbook.Sheets("Sheet2").Activate
someSheet.Range("A" & i).Select
End If
Exit For
Next i
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A2")) Is Nothing Then
findvalue
End If
End Sub
archies_gall
14-Feb-14 13:50pm
View
Issue i dont know... i am not getting any output only.
and sorry but i dont know how to debug javascript code :(
and also,what else I can use instead of ActiveXObject so that it is supported by other browsers too?
archies_gall
14-Feb-14 13:33pm
View
i tried below code:
<script language="javascript">
var fso,txt;
fso=new ActiveXObject("Scripting.FileSystemObject");
txt=fso.OpenTextFile("Test1.txt",1);
function table_maker(txt){
var rows=txt.split(','), r, cells, c, j, i=0;
var table='<table>';
while(r=rows[i++]){
table+='<tr>';
cells=r.split(',');
j=0;
while(c=cells[j++]){
table+=('<td>'+c+'</td>');
}
table+='</tr>';
}
table+='</table>';
return table;
document.getElementById("T1").innerHTML=table;
}
</script>
<body önLoad="table_maker()">
archies_gall
14-Feb-14 12:11pm
View
Thank you :)
archies_gall
14-Jan-14 13:49pm
View
i wanted to develop a tool and not just compare databases using tools.
archies_gall
14-Jan-14 13:48pm
View
I want to develop a tool which will compare 3 databases
archies_gall
5-Jan-14 1:04am
View
check this:
public void addKeyListener() {
// get edittext component
edittext = (EditText) findViewById(R.id.editText);
edittext1 = (EditText) findViewById(R.id.editText1);
// add a keylistener to keep track user input
edittext.setOnEditorActionListener(new TextView.OnEditorActionListener() {
@Override
public boolean onEditorAction(TextView v, int keyCode, KeyEvent event) {
// if keydown and "enter" is pressed
if(keyCode == EditorInfo.IME_ACTION_GO)
{
edittext1.requestFocus();
return true;
}
return false;
} });
edittext1.addTextChangedListener(new TextWatcher() {
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
// TODO Auto-generated method stub
// if keydown and "enter" is pressed
if(b == EditorInfo.IME_ACTION_GO) {
//hide the keyboard
InputMethodManager imm = (InputMethodManager)getSystemService(Context.INPUT_METHOD_SERVICE);
imm.hideSoftInputFromWindow(edittext.getWindowToken(), 0);
imm.hideSoftInputFromWindow(edittext1.getWindowToken(), 0);
// display a floating message
Toast.makeText(MyAndroidAppActivity.this, edittext.getText().toString() + " " + edittext1.getText().toString(), Toast.LENGTH_SHORT).show();
return true;
}
return false;
}
@Override
public void beforeTextChanged(CharSequence s, int start, int count,
int after) {
// TODO Auto-generated method stub
}
@Override
public void afterTextChanged(Editable s) {
// TODO Auto-generated method stub
}
});
}
archies_gall
5-Jan-14 1:01am
View
Hi,
In your first input type you have mentioned width="250em", if you add same width for all input types then the text boxes will be aligned. As far HTML is concerned if you don't specify the width attribute then the text boxes are in aligned format only.
Let me know if this is only your query. OR i have missed something.
Regards,
archies_gall
5-Jan-14 0:54am
View
Thank you.. this will help me.
http://www.getaheadofthegames.com/best-boxing-games
archies_gall
19-Oct-13 1:54am
View
Database will have:
1. Tables
2. Functions
3. Triggers
4. Procedures
5. Views
6. Indexes
7. Synonyms
etc.
Suppose Database1 has 5 table and Database2 has 6 table then the difference should be the 6th table.
If no. of tables in both Databases are same then it will check each table in both databases and will give difference between them like difference in column name or the type(similarly for other objects. it has to check line by line and find the difference. In case of trigger suppose, if there is a difference of semi-colon or comma then that should be highlighted)
Regards,
archies_gall
19-Oct-13 0:30am
View
Hi,
I will compare two databases on same or different platforms (ie. both databases can be on sqlserver or one can be on sql and other will be on oracle) and will give the difference between them in a window. The differences will be highlighted in red to give more clear picture.
Regards,
archies_gall
8-Sep-13 1:41am
View
This is the code in my html file:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="mr">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p lang="mr">
hey maza first
</p>
</body>
</html>
I try to write the text in marathi but while saving it changes the format.
archies_gall
27-Aug-13 4:28am
View
Any clue on this??
archies_gall
26-Aug-13 11:26am
View
Css file:
.imgCustom
{
width:110px;
height:70px;
padding: none !important;
border: none !important;
background: none !important;
-moz-box-shadow: 0px 0px 0px transparent !important;
-webkit-box-shadow: 0px 0px 0px transparent !important;
box-shadow: 0px 0px 0px transparent !important;
}
.imgCustom1
{
width:90px;
height:50px;
padding: none !important;
border: none !important;
background: none !important;
-moz-box-shadow: 0px 0px 0px transparent !important;
-webkit-box-shadow: 0px 0px 0px transparent !important;
box-shadow: 0px 0px 0px transparent !important;
}
tr
{
cellpadding:0px;
cellspacing:0px;
}
a img {
border:none;
}
#header {
position: fixed;
margin:0;
padding:0;
height:70px;
width:100%;
}
html {
overflow:hidden;
}
body{
background-color:rgb(204,252,215);
}
iframe
{
frameborder:none !important;
height:300px;
width: 100%;
border:none;
}
iframe[seamless]{
background-color: transparent;
border: 0px none transparent;
padding: 0px;
overflow: hidden;
}
#tdColor
{
background-color:rgb(79,129,189);
}
#font1
{
position:fixed;
right: 0;
top: 50%;
overflow:hidden;
}
#font2
{
font-family: serif;
font-size: 20px;
color: white;
}
#myimg
{
width:100%;
height:80px;
position:relative;
}
/*Initialize*/
ul#menu, ul#menu ul.sub-menu {
padding:0;
margin: 0;
display: inline;
}
ul#menu li, ul#menu ul.sub-menu li {
list-style-type: none;
display: inline-block;
list-style: none;
line-height: 1;
}
/*Link Appearance*/
ul#menu li a, ul#menu li ul.sub-menu li a {
text-decoration: none;
padding: 0px;
display:inline-block;
}
/*Make the parent of sub-menu relative*/
ul#menu li {
position: relative;
}
/*sub menu*/
ul#menu li ul.sub-menu {
display:none;
position: absolute;
top: 10px;
left: 0;
width: 30px;
}
ul#menu li:hover ul.sub-menu {
display:block;
position: relative;
width: 40px;
height:30px;
}
archies_gall
26-Aug-13 11:25am
View
Html flie has:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 4.01 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html><head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="../CSS/myfile.css">
</head><body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top"> <td colspan="8">
<img id="myimg" src="../logos/Mainlogo.bmp"> </td></tr>
<tr bgcolor="red" style="height:15px;"> <td colspan="8">
<div id="font2"> <marquee>Some text</marquee>
</div> </td></tr><tr> <td align="center">
<img class="imgCustom" src="../Images/history.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/Geo.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/co.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/math.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/sub.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/Test.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/awards.png">
</td> <td align="center">
<img class="imgCustom" src="../Images/Papers.png">
</td></tr></table>
<table width="100%" border="0" height="100%">
<tr cellspacing="0px" cellpadding="0px">
<td align="center" width="20%"> <ul id="menu"> <li>
<img class="imgCustom" src="../Images1/photo.png">
<ul class="sub-menu"> <li>
<img class="imgCustom" src="../Images/Topper.png">
</li> <li>
<img class="imgCustom" src="../Images/Merit.png">
</li> <li>
<img class="imgCustom" src="../Images/photo.png">
</li> </ul> </li> </ul>
<br>
<img class="imgCustom" src="../Images1/event.png">
<br>
<img class="imgCustom" src="../Images1/upcomingevent.png">
<br> <img class="imgCustom" src="../Images/Blue.png"><br>
<marquee direction="up" scrolldelay="120">Some text</marquee>
</td> <td width="60%" align="center">
<img src="../Images/Blue.png" height="50px" width="50px">
<br><br><br><br><br><br>
<img src="../Images/welcome.png" align="bottom" height="50%" width="50%">
<br><br><br><br><br><br><br><br>
</td> <td width="20%" align="center">
<br><br><br><br><br><br>
<br><br><br><br><br>
<img class="imgCustom" src="../Images/Blue.png"> <BR>
<marquee direction="up" scrolldelay="120">Some text</marquee>
</td></tr></table></body></html>
archies_gall
24-Aug-13 14:08pm
View
Hi Zoltan,
Thanks for helping. I Have customized iframe in CSS file and my issue is solved :)
archies_gall
24-Aug-13 8:16am
View
text[0]='../awards/Page1.html';
will take "../awards/Page1.html" this as text and will display it as it is.
archies_gall
24-Aug-13 8:10am
View
Hi,
I am not aware of AJAX at all :(
my "Page1.html"has whole html structure.
I will try by removing the iframe.
do Page1.html require only the contents and not the whole html structure??
archies_gall
24-Aug-13 6:55am
View
https://docs.google.com/file/d/0B8x7KQUPwp1KeGFFU184RHpZaWM/edit?usp=sharing
archies_gall
24-Aug-13 6:47am
View
Please see the below link:
https://docs.google.com/file/d/0B8x7KQUPwp1KVTAzUDFfOU43Wms/edit
archies_gall
24-Aug-13 4:01am
View
I am not able to attach the file here.
archies_gall
24-Aug-13 1:47am
View
eg: i have this line included in my html page
<td align="center">
<img class="imgCustom" src="../Images/awards.png">
</td>
this image doesnt have any background effect in mozilla and chrome but gets blue kind of background in IE
archies_gall
24-Aug-13 1:34am
View
Right so why do i get blue kind of background in IE in the buttons which i have used?
archies_gall
23-Aug-13 0:00am
View
Hi,
I am not able to debug the code. When i press F8 or try to click Debug in outlook nothing happens :(
so wanted to whats wrong in the code
archies_gall
21-Jun-13 22:48pm
View
Thanks Mike for the quick solution. It worked
archies_gall
21-Jun-13 22:46pm
View
when viewed in notepad
archies_gall
18-Jan-13 3:45am
View
I used while like this:
Console.Write("Password :");
ConsoleKeyInfo key;
while (key.Key != ConsoleKey.Enter)
{
key = Console.ReadKey(true);
if (key.Key != ConsoleKey.Backspace)
{
pwd += key.KeyChar;
Console.Write("*");
}
}
pwd = Console.ReadLine();
while building i am getting error as "Use of unassigned local variable 'key'"
what value should be assigned to key? it doesnt accept null value.
archies_gall
17-Aug-12 0:19am
View
Run-time error '424':
Object required
This information box i am getting when it reaches the line:
Set oImg = Picture.Add
in Export_Range_Images() macro.
I am not sure how to attach a screen shot here....
Hope this helps you to understand my problem.
archies_gall
15-Aug-12 5:05am
View
Hello,
I have written the below code for capturing the excel content as image, adding new sheet in excel and pasting the image in added new sheet.
Earlier my code for capturing the image was working but now its giving some error. Please let me know the error as i am unable to identify it.
Also the code is creating chart in the image but i dont want it.
' To copy content as image
Sub Export_Range_Images()
Dim oRange As Range
Dim oCht As Chart
Dim oImg As Picture
Set oRange = Range("A1:I84")
Set oCht = Charts.Add
Set oImg = Picture.Add
oCht.Paste
oCht.Export Filename:="E:\img\SavedRange.jpg", Filtername:="JPG"
End Sub
' To add new sheet
Sub AddSheet()
Dim ActNm As String
With ActiveWorkbook.Sheets
.Add after:=Worksheets(Worksheets.Count)
End With
ActNm = ActiveSheet.Name
On Error Resume Next
ActiveSheet.Name = "Jul 16 2012"
NoName: If Err.Number = 1004 Then ActiveSheet.Name = InputBox("Give name.")
If ActiveSheet.Name = ActNm Then GoTo NoName
On Error GoTo 0
End Sub
'Code to paste image in newly added sheet
Sub TestInsertPictureInRange()
InsertPictureInRange "E:\img\SavedRange.jpg", _
Range("A1:I84")
End Sub
Sub InsertPictureInRange(PictureFileName As String, TargetCells As Range)
' inserts a picture and resizes it to fit the TargetCells range
Dim p As Object, t As Double, l As Double, w As Double, h As Double
If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub
If Dir(PictureFileName) = "" Then Exit Sub
' import picture
Set p = ActiveSheet.Pictures.Insert(PictureFileName)
' determine positions
With TargetCells
t = .Top
l = .Left
w = .Offset(0, .Columns.Count).Left - .Left
h = .Offset(.Rows.Count, 0).Top - .Top
End With
' position picture
With p
.Top = t
.Left = l
.Width = w
.Height = h
End With
Set p = Nothing
End Sub
/*Calling all macros*/
Sub All_codes()
Export_Range_Images
AddSheet
TestInsertPictureInRange
End Sub
Thanks!
Archie
archies_gall
12-Aug-12 0:46am
View
Hi Kenneth,
Thanks for your reply.
I am not sure of macros as i am using them for the first time.
Suppose i have one button in my excel sheet..
On VBA editor i have two macros defined
Eg:
Sub OpenProcessCloseFile()
Dim MonthlyWB As Variant
Dim FileName As String
MonthlyWB = Application.GetOpenFilename( _
FileFilter:="Microsoft Excel Workbooks, *.xls; *.xlsx", Title:="Open Workbook")
Workbooks.Open MonthlyWB
FileName = ActiveWorkbook.Name
' INSERT YOUR ADDITIONAL CODE HERE
' Note: to run a macro in the other file, use code like this
' Application.Run ("'" + FileName + "'!MyMacro")
' -- or Applicion.Run ("'My Workbook.xls'!MyMacro")
Workbooks(FileName).Close
End Sub
--------------------------------------------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub
The button which i added in my excel when i try to assign a macro it gives me two options to select: "OpenProcessCloseFile" and "Workbook_BeforeClose"
but i want to use only one button in my excel sheet which will perform both actions on a single click.
Hope this clarifies.
if not I will try to explain it in more clear way.
Thanks once again for your help.
Thanks!
Archie
archies_gall
11-Aug-12 1:41am
View
Hi,
I dont have much idea about linked lists. Hence i wanted an algorithm that can help me to understand it so that i can implement the program on my own. I dont want readymade program. I wanted to try that my self. I just need th e understanding behind it.
archies_gall
26-Jul-12 5:43am
View
In minutes??
that means u have only data as
SpentTime
----------
45
30
25
59
like this only right?
archies_gall
25-Jul-12 11:34am
View
What data you have in the SpentTime column?
Can you give me example data in your table?
archies_gall
25-Jul-12 11:29am
View
Did you try this?
select e.ID, e.Name, e.EmailID, p.Date, p.ProjectName, d.Desc, Sum(d.SpentTime - CAST('0:0:0' as TIME)) as SpentTime from employee as e inner join project as p on e.ID = p.EmpID
Join Detail as d on e.ID = d.EmpID where e.ID = 1002 and Month(p.Date) = 7 group by p.Date, e.ID, e.Name, e.EmailID, p.ProjectName, d.Desc
archies_gall
24-Jul-12 13:57pm
View
This is for simple text box.
What if i have below scenario:
Web page is divided into 4 frames. Each frame has a text box,image and button. When i click on button in frame1 then information about the frame no. and image should be displayed in the text box.
I am able to get the frame no. in text box but dont know how to display image in textbox on click of button using frames.
Thanks
archies_gall
24-Jul-12 12:07pm
View
I have developed a code that will read the data from excel and dispaly it in the html table format in the email body.
But now i want to create a copy of a main excel and edit the copied excel.
In copied excel i want to delete one column and add one column.
After that i want the content of excel to be displayed in the email body.
Please let me know if you require any more information on this.
Thanks :)
archies_gall
24-Jul-12 7:38am
View
How can i specify image height and width?
archies_gall
24-Jul-12 6:11am
View
Thank you for the solution. I implemented the same.
Show More