Search results

Hi all, I tried to delete a form using VBA in Access2010. The code is like this DoCmd.DeleteObject acForm, strFromName But I got runtime error 29068 "cannot complete this operation. You must stop the code and try again" The same code works well in Access97. I don't know what happened. Could...

Hi all, I tried to delete a form using VBA in Access2010. The code is like this DoCmd.DeleteObject acForm, strFromName But I got runtime error 29068 "cannot complete this operation. You must stop the code and try again" The same code works well in Access97. I don't know what...

The value of combo box is used as a criteria in query. Therefore it may be more natural to put it in FormFooter along with orther controls. I have thought there should be no differenc. But it turned out not. Here is the what I do with the combo box: Input the vaule in combo box; then click on...

How can I post the db here?

The value of combo box is input by user. The a query is run using that value in WHERE clause to give the records in the Detail section. Does this matter? If so, how can I sovle it?

By the way, I am using Access 97.

Hi, I have form containing a combo box in FormFooter. I noticed than after I open and close the "Filter by Fom" window that combo box is always set as Null, which is not I want. I want to keep the value. So I tried to ApplyFilter to reset the vaule. Here is my code: Private Sub...