Search results for query: *

I have used the User-Level Security Wizard to protect my database and set up to users, myself as a member of Admin, and another person as a member of Read-Only Users. I need to add some more people to the Read-Only Users group. Does anyone know how I can do this? Where do I go to add more...

I never did set up a workgroup file. How do I go about setting one up? Angie W.

I am rather confused in regards to setting up security for a database. I have three separate databases that will be on our network. I have set persmissions so the users can only read and open the objects. This works fine, and I can log on under Admins with a password, but it askes me to log...

Just wanted to let everyone know that I was able to modify a toolbar button to meet my needs.  Thanks for all of your help and ideas.  Though they didn't meet my needs this time, I learned a lot and may be able to apply them in the future.  Thanks to you...

I appreciate your idea, but my database is huge and it would be rather tedious to change it at this point.&nbsp;&nbsp;I really just need something to fix this one problem.&nbsp;&nbsp;Can you think of anything else?<br><br>Angie<br>

Thanks for the idea, but it didn't change anything.&nbsp;&nbsp;Any other ideas?<br><br>Angie<br>

The Record Source for the form is the underlying query.&nbsp;&nbsp;I will explain the database a little more and maybe this will help.&nbsp;&nbsp;The database contains sales information for my company.&nbsp;&nbsp;The sales managers will open the form, allowing them to select filter criteria for...

I wish I could, but it has sensitive material regarding the company I work for.&nbsp;&nbsp;Besides, I really need to learn how to do this kind of stuff.<br><br>Thanks for all your help!<br><br>Angie<br>

This took care of the error problems, but now it hasn't changed anything.&nbsp;&nbsp;I still get a blank form and have to completely close it if the selections do not match any records in the query.&nbsp;&nbsp;What am I doing wrong?<br><br>Angie <br>

Yes, I am using Access 2000.&nbsp;&nbsp;Sorry I didn't specifiy that earlier.&nbsp;&nbsp;I tried the new line of code you posted and got a different error:<br><br>Compile error:<br>User-defined type not defined.<br><br>The debugger highlights the new line of code:<br>MyRs as...

Doug,<br><br>I tried your line of code and got the same error with that line still highlighted by the debugger.&nbsp;&nbsp;Any other ideas?<br><br>Angie<br>

Thanks for your response!<br><br>I tried your code and got the following error:<br><br>Run-time error '13':<br>Type mismatch<br><br>Then it gave me the option to debug, and the line highlighted by the debugger was:<br><br>set MyRs = Me.RecordsetClone<br><br>Any ideas?<br><br>Angie Wenzel<br>

I have a form with multiple combo boxes that allows the user to filter a query.&nbsp;&nbsp;&nbsp;&nbsp;Currently, the users click a button labeled &quot;Selections&quot; that takes them to the Filter by Form window where they make their selections.&nbsp;&nbsp;After the selections are made, they...

The query is used to allow managers to filter our sales information based on various criteria that they choose from combo boxes.&nbsp;&nbsp;These combo boxes are on the form.&nbsp;&nbsp;What I am trying to do is also include two text boxes so they can filter by sales date, for example, all sales...

I have a form that is bound to a query.&nbsp;&nbsp;The form allows for filtering the results of the query.&nbsp;&nbsp;Currently, the action of opening the form cause the query to run.&nbsp;&nbsp;I would like to cancel that if possible and only run the query after the filter criteria has been...

I have a database that contains all of my company's sales information for the last two years. I am making a form that will be used by managers to filter the information and produce a corresponding report. The managers will filter the information by choosing criteria in combo boxes. The form is...

I hava form that will be used to filter a query.&nbsp;&nbsp;I would like the users to only use buttons on the form, not on a toolbar.&nbsp;&nbsp;There is an &quot;Edit Filter&quot; button on the form that takes the user to the Filter by Form window to make the criteria choices.&nbsp;&nbsp;In...

Does anyone know the code for the Filter by Form window?&nbsp;&nbsp;I would like to put it behind a button on a form to access that window without using the toolbar.&nbsp;&nbsp;Thanks!<br><br>Angie Wenzel<br>

I tried what you mentioned, but it brings up the Help Menu, not the Filter by Form window.&nbsp;&nbsp;Any other ideas?&nbsp;&nbsp;Thanks for the quick response!<br><br>Angie Wenzel<br>

Is there a way to put the Filter by Form button on a form so that the user doesn't have to use the toolbar?<br><br>Angie Wenzel<br>