Hi Guys
In the table ScanDate has number data type and NewBatchNo has Text data type. The following code is meant to copy data from the table where scandate is between two dates and NewBatchNo is null. but when I run it then it stops responding. What could be the error in the following code.
Please Login or Register to view this content.
rs.Open strsql, cn
is this on its own line?
Also, why not put the null in the query to?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
The following code works. Thanks
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks