I am using:
LastRow = .Cells(Rows.Count, 3).End(xlUp).Row
However, this finds the first empty row and thinks it is the LastRow.
So I need to find the last row either:
from the b...
I recently used SSMA to migrate the backend of our Access database in SQL Server 2005. I noticed
that in a couple of tables some of the column names had been changed (words deleted or rearran...
dear sir,
i have installed Microsoft ISA server 2006 on windows server 2003 standard edition.
And the there is Trend Micro antivirus is installed on the windows server 2003.
After insta...
kindly suggest
how to check and create the bandwidth report using any monitoring tool on Linux server.
also can you provide me the best practice document for linux server administration
I am new to Sharepoint. How can users configure it to allow users access rights to uers so they can share documents accross different offices over different countires? Will users access the ...
I have created a custom Word 2007 Template (.dotm file) with a macro in there that will ask for a name and save the file to a network location. I would like to:
a. Add a toolbar button that ...
Hi all,
I was looking at the plethra of dynamic flash image galleries. However, all of them are php 4.0.
EG. http://templates.entheosweb.com/Dynamic-flash-photo-galleries.asp
Does any...
Hi,
Any videos or good document on adding DNS for the new forest.
I am stuck i install DNS as normally i do but the clients dont get the DNS and the client entries are not entered in the D...
Hi,
I have a cisco 1750 router, running 12.3 IOS advanced security.
I need to setup a IPSEC remote access vpn so that clients can dial in to the office.
They will be using the cisco vpn...
I have set some default values for my database columns. For example zero for an int data type, GetDate() for a dateTime column etc. However, when I try to add a new row I am informed (with the...
Hi,
I got this working in VB with help from EE:
Public Function getThumbnail() As String
Dim value As String = XPath("thumbnail/@value")
If value = "yes" Then
...
Hi!
I have a 0kB, noname file. In Windows Explorer the name is represented by a small square. I want to delete it because it causes me a lot of trouble. I can not copy the whole directory w...
Hi,
I have SQL Server 2005 and using a database with arabic collation. Certain fields have english and others have arabic (there are no mixed languages, strictly one language per column).
...
We just purchased about 50 Dell pcs. When we switch on each, we need to update the patches. But updating single pc already take hour to do, can't imagine updating for 50 pcs. Is there any way ...
Environment: Exchange 2007 is loaded and running error free in logs. Exchnage sits on internal server (10.20.30.41) and have Firewall which has all rules set right. DNS MX records point to ...
Hi, first time posting a question here so hopefully makes sense.
I am running Windows Vista Ultimate SP1 with an Nvidia GeForce 8600 GTS video card and a Viewsonic VX2245wm monitor.
2 days a...
I have an SQL querty which works great:-
insert into myTable select * from otherTable;
but what Id like to do is insert another column which is constant, so something like
insert into...
Following situation:
Table 1:
Emp_ID
Emp_Name
Table 2:
Trans_ID
Emp_ID
Goal:
I need a report that displays ALL records from Table 1 and displays then number of related record...
I have the following image attached in my services:
what is the name of the tns lister
and I need to create a group name as well as the schema
init_price will be the name of the schem...
I am trying this:
int x = 5;
this->label1->Text = x;
but it displays error,
error C2664: 'void System::Windows::Forms::Control::Text::set(System::String ^)' : cannot convert paramete...
I need help writing a Macro that will open a document such as c:\Important Documents\Target.doc and make Target.doc an active document on which I will then be able to run some other Macros (na...
I'm having problems with certain type of media on webpages not loading. It's for a customer of mine. One example would be www.webkinz.com. The page will load just a blue background, but not...
Hi,
I have a table produced from php and the php code is placed inside a form in html (using dreamweaver) although when viewed the table is produced and placed at the bottom of the page no...
Hello-
This is a pretty simple question but for some reason I am unable to find the answer. I have a multi-column combo box with a reference 3x3 fill range A1:C3. I have the column widths...
Hi, I am looking for most economic phone service to call India from USA using my landphone, could anybody suggest the best one both, less price/call and service. Thanks in advance.
