The line that seems to be causing me the issue is emboldened in the code below but here it is anywayĬurrentDb.Execute “”INSERT INTO nm_inc_batch_test_numbers(subbatchcode,batchcode) VALUES (‘”” & TEMPstring & “”‘, ‘”” & Me.Batch_code & “”‘)”” This was working fine purely in access, but now i am using access and sql i am having the “”Error 91 – Object variable or With block variable not set”” fault Thanks to people that have been helping with other parts of my database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |