Search results

If that doesn't work try putting this into the On Timer event: me.requery

Slap this into the On Timer Event. Edit your form name in Forms("MainFormName").SubformControlName.Form.Requery

Yup... In Design View on the form in question you should see the property sheet on the right of the screen. Under the event tab, look for Timer Interval, set it to 10000(which is 10 seconds in milliseconds)

Have you tried setting the Timer Interval in the form properties?? You would have to set it to 300000 for 5 minutes since it is in milliseconds. You can also add an On Timer Event, so it would say "Refreshing.." or "Updating" when the interval fires. Just put msgbox("WhateverYouWant")

For example.. on my form I have around six combo boxes and a checkbox. On the side I have a clear button that resets the filters in all the combo boxes. I did this with this code: Private Sub Command36_Click() Me.cboUserType = Null Me.cboSSAAR = Null Me.cboLastName = Null Me.cboLastLogin =...

I've seen code similar to below that clears all filters, but is it possible that instead of clearing all filters, I can clear just a specific one? Private Sub cbGroup_Click() Me.cboUnitName = Null Me.cboGroup = Null Me.tbl_users_subform.Form.Filter = ""...

Thank you for your response. To avoid the back and forth.. the file I'm working with is here: yooperonline.c**/User_Dashboard2.accdb The second part.. yes 'Today - 365'. Or essentially: Greater than Today-365/Less than Today-365/No date. Hope I'm not being too vague, still learning so my...

Run into a bit of an issue with a combo box that has dates. When I click on a date I receive: Run-time error '3464': 'Data type mismatch in criteria expression' Am I receiving this because I have declared it a string when I should declare it something else? My other question for whenever I...