I'm trying to run some VBA code to update some Access tables from a form, everything seems to be working except for the Memo, and Hyperlink fields i'm trying to update. the code just skips those fields, and then the user has to go back in and update via another form pointed towards the table i was trying to update originally. Here's a chunk of what i'm using:
The Synopsis and Notes fields are the Memo fields in Access, and they just come through blank after the code runs. i don't get any errors or anything, it seems to complete just fine.
is there some kind of special code i am missing here? i'm not too well versed on VBA. The hyperlink comes in later in the code, there are a few more tables being updated as well.
Code:
Dim sqlAddBill As String
sqlAddBill = "INSERT INTO tblBills ([BillNum], [Sorter], [Sponsor], [FileCode], [Title], [Synopsis], [Type], [Priors], [PriorPosition], [Notes], [CFBillNum], [Week] ) " _
& "VALUES (Forms![frmInputBills]![BillNum], Forms![frmInputBills]![Sorter], Forms![frmInputBills]![Sponsor], Forms![frmInputBills]![FileCode], Forms![frmInputBills]![Title], Forms![frmInputBills]![Synopsis], Forms![frmInputBills]![Type], Forms![frmInputBills]![Priors], Forms![frmInputBills]![PriorPosition], Forms![frmInputBills]![Notes], Forms![frmInputBills]![CFBillNum], Forms![frmInputBills]![Week])"
DoCmd.RunSQL sqlAddBill
The Synopsis and Notes fields are the Memo fields in Access, and they just come through blank after the code runs. i don't get any errors or anything, it seems to complete just fine.
is there some kind of special code i am missing here? i'm not too well versed on VBA. The hyperlink comes in later in the code, there are a few more tables being updated as well.