cheers

I 've not explained it properly. They will not add their own password. They will type in the username and pwd I have given them.

What I mean is if...

i've set up a password. But it stll not working properly.

I thought it wqould simple to create some users and when they logn add their pwd and username and then...

Theres no such thing as Workgroup Administrator.

I'm doing it in access

when the database is opened it will ask the user for a name and password. If correct then the database will open. Similar to the password setup.

Is that a bit...

Do you want to link Access table to the sql server table. Not sure what you mean.

If so then in your MS ACCESS. click on tables, right click link tables.

On...

Thanks guys. Can't believe it was that simple . Pulling my hair out over it. Thanks once again.

Got another Question to ask.

I need to set up users and permissions. I...

thanks but i need to have it as a txtbox

access 2000.

I'm trying to use d lookup. But Its not hitting the first if condition even if its true. HELP

If Me.Dirty = True Then

    If Forms![frmPatientCheck]![ClinicianID].Value <> DLookup("ClinicianID", "tblClinician", "ClinicianID...

If Forms![frmPatientCheck]![ClinicianID].Value <> Dlookup(FieldToReturn, TableName, Criteria) Then

msgbox "not correct"

end if

this does not work as well .HELP ME PLEASE

This does not work as there is no such thing as dao.recordset

Thanks Jo. You're a legend. It works fine displaying the correct months left.

Regards

Ritesh

Hi,

Start date and end date was an example.

Ok - i've done it wrong. What I'm tring to do is the following.

In the query builder..         This will get the month from...

thanks very much. Appreciate it