Search results

I am applying security to the 2003 version of Ms access. If any one who has 2007 access open the database does it gonna change any security settings. Please need some information regarding that.

Hi Gudson, Thanks for replying in such short time . The security is working properly but the shortcut path which you have posted where do i have to paste that or what to do with that. Please Help me regarding that. Please explain that step ( target field)

Hi I read all the posts regarding the workgroup file. The problem i am facing is i applied security to the database and it has work group file too. But when i paste the database andworkgroup file on to a server ( its a network drive) where all the users would have access to the database...

Hi VBA, THank YOu. I think i annoyed you. Sorry for that. A quickie , i need to disable the special keys like f11 depending up on the user login. Do you know how to do that programmatically in vba

HI VBanet, there is nothing wrong with the data, there are duplicate records in the table. I need to increment them up so thats why i am using the date as another criteria. Do you think the code is fine .

HI , I modified the code a little bit, i am considering start date also in the criteria. As i said if there are 2 duplicate records in the table . The counter should be incremented . In the example . the bolded records duplicate but the counter has to be incremented so , i pasted the code...

Yes when the region changes , the counter is starting at 1 but as i said if two CINs lets take AA12345A and AA12346A belong to the same region . the counter starts at 1 just one time where it should start at 1 twice because of different CINs. Region is of Number data type

the CIN , and rate are the strings. everything else is a number .

yes it should be i wrote that line because the code you have sent to me increments to 3 instead of starting at 1 because the code is looking at the region, region is same for previous record as well.

Reg CIN ID Rate Counter 01 XX12345X 1 9222 1 01 XX12345X 1 9223 2 01 XX12346X 1 9221 3 3 should be 1 but your code criteria looks at region

Hi VBAINET, its not gonna work because you are looking at the region . if the region is not equal to old region u r setting counter 1 but what if 2 CINs belong to the same region , So the counter does not start 1 for both of them , it just increments by 1 .

pointing at IIF statements its saying argument optional compile error

wait for like 10 mins

I guess this is working Dim yRow As Long, rstClone As Recordset Dim oldRegion As Long, oldCIN As String, oldID As Long, oldRate As Long, tempCounter As Long Set rstClone = CurrentDb.OpenRecordset("Table").Clone tempCounter = 1 With rstClone If .BOF = False...

Exactly......

HI VBA inet, actually in my reply under criteria first 2 points are working . but when either CIN or region or plan changes it is not working

OK. i need the counter field to increment based on four fields (Region,CIN, ID, Rate) which are primary keys . Region = number data type CIn=text ID=NUmber Rate=NUmber Criteria: 1)So the lets take CIN(AA12345A)belongs to region 1 with ID 1 and rate 9221. the counter should store 1 in the...

Hi VBA Inet, I guess the increment part is not working.i guess because the increment code comes after updating the field in the code. it is storing 1's becasue of rs.edit !counter = tempCounter .update but the increment code is not working tempCounter = tempCounter+1

Hi i cannot do that because it contains all the confidential information . But i will try to figure out the code. so give me some time. if i can't , then i will come back to you.

Hi VBAinet. it is storing all 1's in the table .