Recent content by jasmeetsingh89

Thanks for the reply.. But i get the same error even if i use only me.recordsource ... and infact ive used me.recordsource.value in another form ... there it works correctly .. and .. if i just write the tablename in the DB.OpenRecordset(STR_SQL, , dbOpenDynaset, dbReadOnly) instead of...

Hi, I am cracking my brains on something that most of you'll must be finding very trivial ... As far as i know .. my code is fine but i keep getting this error "Compile Error: Invalid Qualifier". The error is on the underlined line .... please help ! ! my code is :

thanks a lot for helping me ... the code that i originally wrote .. tht works ... it was some access glitch .. i changed the form and did everythg frm the start ... now it works ... can u tell me how should i take the value from combo_sid.Value instead of the inputbox ?

I have a similar code that i am using .... But i on the button click i get an error saying "a problem occurred while microsoft access was communicating with the ole server or activex control"

Hi, Thank You for the reply. This is correct code and even i did this in case of a single record ... But i have a key associated wid multiple records .. so essentially, i have to check i there are more records for tht key push them in the excell too ...

Hi bob ... I am getting a similar error on trying to assign values to excel from access ... the error says " A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control" ... reading your above comments, I added Microsoft activex controls in the...

Hi Delikedi ... I have a very similar situation ... and I have used the code that u posted on 07-09-2012 09:57 AM after modifyin it a lil .... I have multiple records for a single student ID and want to assign them to an Excel template .... I want this to happen on a button click .... But on...

Hi, I am a newbie ... please help! On a button click i am trying to open an excel sheet and assign values of all the text boxes in the form to specific cells in the excel sheets. Now, the above part that i mentioned, I somewhat have an idea of how to do it. But, the tricky part is that I...