Recent content by hotmalepiyush

i am using this code as of now..to update status of each person i want to use vba.. and get the last status of all records in the sense.. suppose for person1 i have status1,status2 and status3.. but rest are null.. text in status3 must be shown as latest status for person1.. i knw that above...

thanx a lot both of you..

here's what i wish to do: i have fields named status1,status2,...,status5 abd caller1... caller5 (i know this kind of field names are a lil absrd but i wanna keep them like this cuz the end users want them to be so) when i add record i fill status1 and caller1. thats fine i need to build...

hey nigel.. thanx for coming for my rescue.. actually by removing control source from the combo box.. my problem got solevd

for every unique person i need to have at max last five status. for example.. if we call a new person.. he says call me on wednesday--- his staus1 is "call on wed" on wed we call hom again and he says call on thursday----status2 is "call on thur" something like that.. i dunno how to normalize a...

i have table with fields name,phone and status1,status2... status5 i have a form to add records which uses status1. now i want to build a form to update status... it should how many fields for status i have used.. and allow me to fill the new one... how can i do so. plz help..

thsnx a lot banana,, ur link did help me and now i am getting what i wanted

hello, i am having a strange problem i have table with PK: name+phone number. i have a form which has a combo box and a subform combo box is used to select a name... on updation of this combo box the subform finds related details.. when i click on any textbox to update etc.. i get an error...

am using office 2000 premium. i am using two files.. front end and back end.. i tried setting the default value of the table in the back end as currentuser() and got "invalid function" as error. i added your code to my Private Sub AddRecord_Click() and changed "mycontrol" to "called_by" as the...

i am not very clear here... i locked the textbox so that the user cannot edit it.. and no matter what he does.. his name goes into the reocrd... is that not what lock is use for??? then what is teh right way to do so.. also i am dunno what ur code does.. it will be kind of u 2 explain it to me..

actually its not much of a problem.. i asked only for future use.. as of now even if it doesnt shows the record no. its ok.. thanx for ur guidance,

i tried setting CurrentUser() as default. while trying to save i got error message that this is an invalid function.. so i wasnt allowed to save.. :(

thanx a lot.. using the CurrentUser() function i am able to get the desired result.. but only in the form... when i click the "add record" button all the fields get filled up.. but the one having CurrentUser() remains blank... i have locked the control having user name so that the user can not...

i wud ike to clarify that i used user-level wizard.. nd have formed mny different user accounts.. an i want to idntify these users and not the user acount through which i hav logged on in the OS....

i have some forms having subforms.. the linked tables are loacted on another PC.. these foms work fine when the linke tbles ar on the same PC but when the linked tables on another PC.. the foms are blank!!! please hlp..