Search results for query: *

Do I need to declare something? Because how does this "strFilter = (build the string as shown in the example above)" get populate with other values.

I have a form(bound to a query)that has a multiselect listbox(gets it's values from a table called states). I have a field named states in the table that the query is based on. I would like to populate this field with several selections from the listbox. My first question is it okay to have...

Sorry, I didn't post all of the code. Private Sub Form_Close() Docmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide End Sub

Did you try importing objects into a new database? I seriously doubt this will work.

You would need to implement user-level security. This is not for the faint of heart. Microsoft has a FAQ on this subject. You will need to read it, read it, and read it. One other option would be to have different screens for different users. You could password protect the forms...

Have you tried this code behind your switchboard? Private Sub Form_Close() DoCmd.RunCommand acCmdWindowHide End Sub

I have a form that I would like to hide when i have a query open, but open once i close the query? Is this possible? I know how to do it with 2 forms or reports. But how do you pass code to make it recognize that the query is closed? I prefer not to make the query a form in datasheet view...

I am using SendObject to email reports to different regions. I have been using RTF to send the reports. I would like to use the Adobe Writer. Is there something special I need to do? What do I use? A print to file or report format pdf?