Recent content by fritz.panganiban

I got it, error occurs under DayLabel since i have misspelled it.

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] & "") =...

I tried, but it doesn't work. What's actually in the subform (frmData) is a preview of tblDataSheet (as the control source) shown as table in a subform and I'm directly doing changes in the table.

I have pasted the code to subform's BeforeUpdate event but still no record of changes was recorded

Just to clarify, Do you mean I have to change Private Sub Form_BeforeUpdate(cancel As Integer) Call AuditChanges("ID") End Subto Private Sub Form_BeforeUpdate(cancel As Integer) Call AuditChanges("ID","Edit", Me) End SubIf I got it correct, changes were still not recorded

Hi Arnel, Thanks for all the help and i hope you could check this out. http://www.access-programmers.co.uk/forums/showthread.php?t=288737

Hi andigirlsc I'm humbly asking your favor if you could check out this thread and help me figure out the error on the code which will supposedly track changes made on a table shown in a subform. http://www.access-programmers.co.uk/forums/showthread.php?t=288737 Thanks in advance

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 Arnel, I replaced the SQL code to ">=" and "<=" to "Between" and "And", and now it works. You're the man :)

Using this code produces no record since the format in my date picker is mm/dd/yyyy

Yeah, it shows all and nothing is missing. I could not figure out the issue if I set an end date to limit the data which query produces.

Hi sneuberg I'm just choosing the first day of the month and the end day of the month using a date picker

Hi Minty, Yeah i removed the criteria to test and nothing is missing.

Bu that produces records beginning that certain day and onward but i just have to view records for certain date range

The only criteria im using is the beginning of the month and the end of the month