Search results

You're passing a recordset to the sub but then you're re-defining the recordset by using strsql. then you're setting the recordset "rst" to strsql but without the dbopendynaset argument set rst = currentdb,openrecordset(strsql, dbopendynaset) or whichever type of recordset you wish. if you just...

Thanks for the welcome Uncle Gizmo

Thanks vbaInet That worked, I'm not sure exactly what it was that I did with getobject() but it worked so I'm grateful

Hi I've tried numerous ways of doing this which are mostly copied from this forum and nothing seems to work. My problem is that I want to delete an excel file from within access vba. problem is that if the file is open, it obviously cannot be deleted. so I need to check to see if that specific...

Hi My name is Pen and I've been using Access for a few years now but can't call myself proficient. Lots of questions about vba. I live in Luxembourg and am retired.