Search results

Just check what u are sending in where contional ..frmlogin!login

Thanks, I saw that link and tried to use it but the problem is that it displays red color for null values and the values which are not in list i specified the control source as- switch(<col> like '%A%',1,<col> like '%B%',-1,<col> like '%C%',0,<col> like '%D%',NUll) But the col have values...

Can anyone help me on this??

Conditional formatting gives me only 3 options and also i have to give the exact match.thats why i dont want to use it Thanks

Yes its a continous form.Is there any solution for this?? Thanks

Thanks for ur reply.I tried that also but its not working. Actually it only formats the first row after that it renders the form.

hi all I dont want to use the conditional formatting ..so is there any solution for this..its setting the format of the first record to all the records. Thanks a lot

hi all i have a continous form which is bind to a datatable.I want to show a particular coloumn with different background cols depending on its values. On the page load i m doing this like- If txtprodtype.Value Like "*atm*" Then txtprodtype.BackColor = 255 End If but the...

hi all, i have a appication that uses ms access as a front end and sql server 2000 as backend. Actually i have added references to excel and other things and suppose if it doesnt find that references on the client machine the appliaction gives a error.so i have to manually remove these...

ctrl space was also not showing anything except the value property. There was some problem with that control i put a new one but still dont know the reason. Thanks a lot for ur quick replies

yes by screen i mean form but the control is not on any other form its on the same form,dont know why its not shoing its properties there? thanks

hi all, i m referencing a control like me!<controlname> in my code. but in 1 screen its not giving me option after me!<ctrlname>.(only value property). but in other screen i m able to access the properties. So what could be the reason for this.I particularly want to access the enabled...

hi all, i m trying to insert the data from the xml file to the sql server using msxml2 and ado.but i m stuck here- i have loaded the xml document and also called the recordset using ado.now i m trying to insert data in this recordset like this- For Each objxmlbooknode In objxmlnodes...

thanks guys, yes no code is required on the click event as it is bind to the datatable. i just made its default value to 0 in the VBA code though i can make the same in the properties window also. thanks all for ur help

Thanks but is there any way that i can show the background as white. i have other checkbox on the same form which is dispalying the background as white. thanks

hi all i m new to access.whenever i use a checkbox or radio button control button it shows them blurr untill i clicks on them. i m looking for what property makes it like that.can anyone tell me that. lot of thanks

thanks a lot .actually i checked these properties but they were set to yes.i had other problem .the table to which i had bound the form didnt have a primary key thats why it was not showing any controls. I didnt know abt this thing thanks

hi all, i m new to access.I need a help.i m binding a form directly to the table.I also want to insert data through this form. but the problem is suppose if i dont have any data .then it doesnt display me anything and so i cant enter the records. is there any way so that i can enter data.i...

hi i m also having this problem.actually i have a main form.i m using a subform in it .i also want to use another subform so i copied this subform and changed the table from which its fething the values. but the problem is that it dont shows any controls on the subform.the control are in the...