Search results

Hi guys Please help me figure out what's causing the error (Run-time error '3061' to few parameters. expected 1) on below code Note that frmEditHere is a subform Dim strSQL As String strSQL = "UPDATE tblDatasheet " & _ " SET DateLabel=" & IIf(Trim([frmEditHere]![txtDateLabel] & "") =...

Hi MS Access Experts, Please spare me a piece of your time to help me with this brain cracking code which will supposedly track the changes made in the table shown in a subform. Note that the table in a subform is not locked and enabled so as to allow user to make changes although user has to...

Hi guys, I'm humbly asking your help on my project My code goes this way under criteria in query, but it produces incomplete data. Based on my initial finding, it excludes the first week of every month. Between [Forms]![frmDateRange]![txtFrom] And [Forms]![frmDateRange]![txtTo] The reason...

Hi, Could someone help me out what to input in a module page if I have to insert a blank whole row right after the rows which contains a negative amount. This will be repeatedly done on all items within the sheet. Please refer to the attached image for your reference on what should be the...