Search results for query: *

Interestingly - I am getting the same problem but a different error message appears now. Again, click debug then execute and the code carrys on fine. Run-time error'-2147417859 (80010100)': Method 'CopyFromRecordset' of object 'Range' failed

Hi Genomon, My code has not worked out, so tried DAO-ing but still the same issue. I cant understand why it works perfectly fine in 2010 but in 2003, it has issues, but as soon as you excute the code again it works..

Hi All. Not the best of solutions, but used the Error handler code to rerun the code. Not the correct way to use it I know, but as the script had originally been running for a number of years without issue. The risk is low; Dim Errorsfound As Integer On Error GoTo Errorfound 'Due to the...

This is a strange one I hope someone could help with; The code worked fine, in 2003, the database was open and code was ran in access 2010. Since then the code works fine in 2010 but the following error appears in 2003. "Run-time error '1004': Application-defined or object-defined error. I...

Search Engine - Filtering a datasheet subform from a textbox on main form. Hopefully someone can help, as I am trying to make a search function in one of my databases. I have a Main form (named Main) which has a number of subforms on it. I have put the subforms on different pages. The form I...

Works a treat..... Thank you so much!!!

Hi I need help with setting a date format. I have a number of reports that come in with a file name YYYYMMDD - Unweighted.xls So I wrote the following code (I am very new to VBA) and thought I was on to a winner, but then during testing I realised 'ThisMondate' was just a number ie 20110704 and...