Hey All,
I'm trying to use an insert into statement to log an action in my system, I am looking to show the record with Printed on MMMM YYYY, however the date format is the issue at the end (I always seem to have an issue with date format, I just cannot get it.
Please can you tell me what my statement would need to be to do this, I'm using:
the problem is with:
Thank you
I'm trying to use an insert into statement to log an action in my system, I am looking to show the record with Printed on MMMM YYYY, however the date format is the issue at the end (I always seem to have an issue with date format, I just cannot get it.
Please can you tell me what my statement would need to be to do this, I'm using:
Code:
DoCmd.RunSQL "INSERT INTO tbl_Net_UserLog (Computer, UserName, SystemDate, Action) SELECT Forms.frmBackground.txtComputer & ' (' & Forms.frmBackground.txtComputerUser & ')', Forms.frmBackground.txtUserName, Forms.frmBackground.txtLocalSystemDate, 'Printed ' & forms!frmbackground!subfrmBuyingList!cboBuyingList & ' Buying List for ' & Format(forms!frmbackground!subfrmBuyingList!cboBuyingListDate, "\#mmmm yyyy\#")"
the problem is with:
Code:
Format(forms!frmbackground!subfrmBuyingList!cboBuyingListDate, "\#mmmm yyyy\#")
Thank you