Recent content by ngohil

Thanks Galaxiom. I too am of the opinion that query names and not SQL statements work better in the RecordSource property field of forms and reports. The databases in question are legacy systems that I am required to support as part of my role and I would have done them differently if I had the...

So the code "frmMainForm.txtFromDate.value" should be more like "[frmMainForm]![txtFromDate]![value]" Is that it?

G'day everyone. I hope this is in the right section so here goes. We have a number of MS Access 2003 database applications at work that we are considering migrating to other technologies. So at the moment, I am in the process of testing migration options for one of the smaller Access 2003...

Hi vbaInet, My hope was to find a control that can enable the re-arranging of the query columns. Is there something within MS Access that allow you to do this? Thanks.

Good day Access Gurus! :) I am required to create a report that displays all records between certain start and end dates. At the same time, the report should also display columns based on checkbox selections made on the form. The "Report Parameter Selection" form has start date and end date...