Search:

Thanks for the reply

You are not at all used Forms.Authenticate method in the sample and you are using Session("Security"). I am pretty new to ASP.Net. Sorry I couldn't understand the example....

Hi,

I have a table contains Username and Password, I have to use this table to implement Forms Authentication. So instead of mentioning each user name and password in the Web.Config I wanted to...

Hello,

I would like to make clear on my previous post that when using null on select statement computation it will show a warning message for using null, but at the mean time it will not take...

Hi,

Since I am busy with the project i couldn't reply.

x is having value of current mouse position and .Colpos(i) will return starting value of i th Column.

If .ColPos(i) <= x Then
...

Yes cjard,

it will return warning message while working with QA, but it will return correct result.

Regards

Sivar

Hi,

you can do it through MouseMove event

Private Sub msfmat_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)

With msfmat
For i = 1 To msfmat.Cols - 1
If...

Hi,

Yes, It is my mistake, I would come soon with same kind of trick.

This could satisfy the criteria I hope.

CONVERT(NVARCHAR, D.Spd_deldateans, 101)
between @date1 AND...

Hi Pankaj,

Just try this. I hope it will work.

add this piece of code in your query for both fields.

avg(case when Time = 0 then null
else Time end)

Hi,

As per your question you can add the conditions in the where clause itself.

or

are you trying to use summarised values in the condition i.e AVG(TIME)? you can go with Having Clause
...

Hi,

Just add From Clause with you statment.

Update OrgMember Set OrgMember.LeftPaid=CopyMember.LeftPaid FROM COPYMEMBER Where OrgMember.UserID=
CopyMember.userID


Regards

Hi,

This is just an alternative idea.

CONVERT(NVARCHAR, D.Spd_deldateans, 101) between @DATE1 AND @DATE2 or CONVERT(NVARCHAR, D.Spd_deldateans, 101) > @DATE1 OR CONVERT(NVARCHAR,...

Hi,

Hope you already created the dll file.

Make the following change in the dll project. In the project properties Dialog box Component Tab set Version Comapatibility to Project...

Hi,

A subquery can refer the column of outer query. This is called as correlated subquery. So for each value of outer query the sub query will be executed.

what you are mentioned is...

Hi,

This is another method, I hope this will be good in performance compare with what you said.

set rowcount 1
SELECT TOP n field FROM table ORDER BY field ASC

Here no two TOP...

Hello

You are wrong here

.Filter "PartNumber LIKE ' strName * '"

change it as the following

.Filter "PartNumber LIKE '" & strName & "%'"

Hi yhung82,

Microsoft Access provides Import function to import data from other databases, through ODBC, etc.,

See File -> Get External Data menu in the Mircorsoft Access.

...

Hi Amarjit,

Set dbs = OpenDatabase("d:\amarjit\access\testdb.mdb")

You change the above statement with the following one

Set dbs = Currentdb


Regards

Hi

Here put filter statement first instead of requery

adodc1.recordset.filter = ""
adodc1.recordset.requery

It will work.

Hi vckiran83,

The description is not clear. As per your statement Non_working working hours should not be considered for downtime calculation.

Your statment is this for same date
...

Hi Laurel

Have you tested the code that you have written?

It is working fine,

I used to do the same method

Sivar

Hi Chandru,

Altered column cannot be text, image, ntext, or timestamp data type
in the ALTER TABLE statement

Enterprise Manager allows you to change the datatype from text to ntext datatype,...