Search results

Anybody tell me how to delete spaces from drop down list . i did code like this: with sh1.range("A2").validation .delete .Add type:xlvalidateList, AlertStyle:=xlValidAlertStop, operator:xlBetween, Formula:"=sheet2!AH2:AH1000" .IgnoreBlank=True .IncellDropDown=True .InputTitle="" .InputMessage=...

Could you tell me how to delete spaces from drop down list . i did code like this: with sh1.range("A2").validatio .delete .Add type:xlvalidateList, AlertStyle:=xlValidAlertStop, operator:xlBetween, Formula:"=sheet2!AH2:AH1000" .IgnoreBlank=True .IncellDropDown=True...

Thank you :)

Thanks a lot, i got an idea to work on.

thanks a lot :)

thanks :)

Hi, I am facing issues with data validation property. I have one column data in second sheet and want to take those data from second sheet to first sheet in drop down list using vba code in access. Could you please help me with that. thank u in advance

thank you so much :)

thank u :)

thank u :)

No, actually in second sheet only one columns data is there. i have to do drop down in first sheet in range "A2". It should capture unique values like data validation. is there any such property to do data validation for drop down list in access using vba. help me please. Thank you

Thanks , i was doing from other logic but now its done :)

HI team , please help me to get vba code on below: i have data on second sheet and i want to do validation on first sheet on the basis of second sheet.

no, i have not tried how to copy from query to directly paste to active sheet

yes, i have created another sheet too. let me brief u again i have query where one columns data is there. I want to take distinct data from query 1 to sheet2. something i am doing code like set qd= currentDb.queryDefs("query1") after that how to do ?

i am working on access, and open workbook using below query set oXL= Createobject("excel.application") oXL.visible = tRue set wkbk=oXl.Workbooks.add set sht = wkbk.sheets(1) after that i set field value and now i want to take data from query to another sheet could you tell me how to take...

Hey no, using macros i need to do, check once again my post

I have opened workbook using macros in access and want to do below steps 1) I have workbook open with some specific columns, i need validation on first column and it should take data from another sheet(distinct value) 2)how to take data in another sheet from query

thank you :) :)

its working thank you so much :)