Search results

I have a procedure where I write a subform to an excel spreadsheet. The procedure works fine but after I have ran it and then try to open the spreadsheet I get a message that is in use. How do I get the lock off of the spreadsheet after my procedure runs? This is what I have: Private Sub...

Hi, I am very new to MS Access and to VBA. I have a field in a table in MS Access that contains data in the format: xx-xxxx.xx , where x is a character. I need to be able to compare this field with another field in a different table with the format as: xxxxxxxx. I would like to know how to...