# 2002

Some communications of 2002

TAGS: Communications, Cyber Life, georgehernandez.com

Here is correspondence for 2002.

## 2002-03-19

From: Ivan Serkiz [metadata]
Subject: how to determinate the number of the week

Dear Sir,
I'm looking for a formula that can determinate the number of
the week for given data (ex. 31.01.2001 - 5th week).

I hope you can help me.

Sincerely,
Ivan Serkiz
Ivan:

It depends on which language you are dealing with: Java, JS, VB, VBS, C#, TSQL?

For VB, it would be DatePart(ww, yourDateVariable).

For TSQL, it would be DateName(ww, yourDateVariable).

For JS, check out http://www.webreference.com/js/tips/010217.html.

-George Hernandez
2002 Mar 19 Tue17:33 +0200
Thank you George
Ivan

## 2002-04-15

From: James T. Moss [metadata]
Subject : Can you help me?

Hello
My name is James Moss, I am working on a project for my home business. I
created a database in Access2000 but when I try to connect to that db in VB6
I am unable to plus I get errors saying that the file is either missing or in
use by another person. What am I doing wrong, I am using an ADODC control.

James T. Moss
James:

I'm assuming that you are creating a VB exe. Is your ADODC control connecting
via an ODBC DSN, a connection string, or some other method? If you don't know
then try connecting via the connection string. If you don't know how to do
that then right click on your control, select ADODC Properties, click on
Use Connection String, and then click on Build. Make sure that the provider
you select is Microsoft.Jet.OLEDB.4.0

You may want to check out Microsoft's online documentation for the ADODC
control at:

I hope this has been helpful.

-George Hernandez
Hey George
I will try it out, sounds like it should work. I also wanted to ask you if it
would be too much of a burden for me to consult with you on further issues.
I am learning VB on my own and I really get frustrated when I run into errors
in my apps. and I don't know what to start with when debugging. I guess I am
going the route of "hard knocks". I have finished a book and a half and a six
cd course from learn2.com, but I feel that I need someone that can tell me what
I am doing wrong, and how to correct my mistakes. I thank you for your
response.
Terry

## 2002-09-18

From: Curt Armstrong [metadata]

I just thought I would drop you a little message that I have found the
Your web site was easy to use and right to the point.
I am taking a class in VB.Net right and find it is not to far from the VBA I
have been doing for several years.

Curt
Glendale Az


## 2002-11-26

From: James Gluba [metadata]

I used the www.askjeeves.com search engine to search for storage
terminology referring to capacity greater than Terabyte. Your site was
first on the list. I thoroughly enjoyed the w-i-d-e variety of content
on your site, most of which I found very informative. A good
technical resource of sorts.

Now for the real reason of my writing; I had a few additions that you

You reference a variety of terms/definitions in your zVoc section which
while very useful, are now becoming outdated, thanks largely to Moore's

Here are a few I felt you should add:
ATA 100, ATA133 on the the ATA section and here:
http://www.georgehernandez.com/h/xComputers/zVoc/B.asp
USB 2.0 in the USB section and here:
http://www.georgehernandez.com/h/xComputers/zVoc/B.asp
Gigabit speed Ethernet (1000 BaseT) on the page here:
http://www.georgehernandez.com/h/xComputers/zVoc/B.asp
V.92 here: http://www.georgehernandez.com/h/xComputers/zVoc/V.asp

I'm sure there are others, such as the proposed enhanced IEEE-1394 standard.

Thanks for the devotion to this site, I for one have book marked it and will
share with my friends.

James Gluba A+ 
James:

Thank you very much for your compliments. There are so many things to explore
and I like to share my explorations.

Yes, it is hard to document even the basic changes in technology. I will
however make an effort to implement your suggestions.

Thanks once again for the pat on the back: it is sincerely appreciated.

-George


## 2002-12-04

From: Santhosh Krishnamurthy [metadata]

Hi,

Can you have your own global variable declared in SQL 2000?

Something like "Declare @@gbl_info varchar(100)" and access the same...?

Thanks & Regards

Santhosh K
Santosh:

As far as I know you can't declare new "global variables" like @@IDENTITY.
Local variables via something like "DECLARE @LOCAL_INFO varchar(30)" will
have to do.

-George

GeorgeHernandez.comSome rights reserved