Filter Report based-on selection from Combo box in Access 2007
Filter Report based-on selection from Combo box in Access 2007 Hi all! I'm still learning VBA programming and Access Databases. I've been designing a database for Membership Tracking and have several tables in my database which I have tried to normalize. I'm stuck at a particular place in my design when I need to generate a report for a memberID and list all of his payments made month-wise and payment dues. I have a table called tblSubscriptions which has a date field column showing the date at which a particular payment was made by a member. What I would like to do, is to place 2 combo boxes on a form , one to select the MemberID and the other for the month (Jan to Dec). The user would select the MemberID from one combo box and a month from the other combo box to filter a report for payments made for the selected month of the particular memberID in question. I tried to do this by the Macro Builder, but could not go beyond a particular step and don't know how I would achieve this functionality. I tried to understand how to do this from a lot of resources on the net, but got confused as there are several methods to achieve this. Could anyone guide me how to achieve this functionality either on the After Update event of the combo box ? Any help is greatly appreciated. Thanks a lot!
Leaving Design Mode
I have worked on Access for many year ... and love it ... BUT i am currently very frustrated. If i try and execute an query from design mode it takes f o r e v e r ... even if i just want to design another query, it takes ages for the new query to initialise. Has anybody else had this problem ? I am also concerned with the "(Not Responding)" message in the title bar which appears all to frequently, even when Access is performing menial tasks. Does this happen to anybody else ... even better if someone is aware of a solution to my current misery. i would really appreciate it.Using Date() works in Access 2007, but not with Access 2007 Runtime. Gives #Name?
I have an unbound text box on a report using: =Format(Date(),"Medium Date") or =Format(Date(),"dd/mm/yyyy") as the control source. This works fine in a Win 7 PC having Access 2007, but when these reports are created on a certain Win 10 PC using Access 2007 Runtime, it displays #Name?. Another Win 10 PC using Access 2007 runtime displays the correct date format. There are no table fields in the record source named Date. The Region settings in all PCs are identical. Any advice greatly appreciated.