Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. breaker11

    Menu Bar Security...

    I know I probably am rehashing this a bit, but how would you go about getting rid of all menus within the database besides going to tools => startup?
  2. breaker11

    Menu Bar Security...

    There is no VBA for the menu bars, the main thing I want to do is to somehow get rid of "delete record" from all Edit menu bars within the database. I was thinking that there was a somewhat straight forward way of doing this... maybe I'm confusing myself. Do you know of a way to get...
  3. breaker11

    Menu Bar Security...

    Junior, I've already disabled the menu bars on the login screen, but once the users enter the database and pass the login screen, they are able to use the menu bars. Is there a way to customize or disable the menu bars on other forms? Thanks.
  4. breaker11

    Menu Bar Security...

    Is there a way to limit the options available to users of a database, ie delete record, within the pull down menus. As it stands, users are able to go to Edit, then delete the entire record. Any help is greatly appreciated.
  5. breaker11

    database access on network...

    I have a small problem with my database. I have it on a network, but it cannot be accessed by anyone if it is being used by another person. I was wondering if there was something simple I was missing. Any help is appreciated, thanks.
  6. breaker11

    Ambiguous name error...

    I have an Open Form command button that when clicked gives me an error stating: The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: cmdOpenRDOP013_Click. I'm not exactly sure why this error is tormenting me. :) Any help is...
  7. breaker11

    form not appearing...

    Aivers, The Allow Additions Property is set to yes, and my recordsource is my query. Everything should work out, but the screen I get is a blank gray screen, not even the outline of the form shows up. Let me know if you have any more ideas, thanks again.
  8. breaker11

    form not appearing...

    Hi All, I created a form from a query and have a command button to open it within my database. The problem is that when opened, none of the fields are displayed, instead, a blank screen is shown. I am wondering if there is something simple I am missing here. Any help is appreciated.
  9. breaker11

    pulling data from two tables into the same form...

    I created two tables, both with a lot of fields, and wanted to be able to use the two tables to create one form. I can only select one table per form to pull information from, can anyone help me alleviate this issue?
  10. breaker11

    Error: DoMenuItem action was cancelled...

    Aivars, What does the "err.number = XXXX" do? What goes in the XXXX portion of the code? Thanks.
  11. breaker11

    Error: DoMenuItem action was cancelled...

    Hi All, I have a recurring error message that states "The DoMenuItem action was cancelled..." after I exit a new record. I am trying to save the record to a list, but can't without this error. Any suggestions as to a resolution are appreciated, here is the code I currently have for...
  12. breaker11

    user adds new record, only one who can make future changes

    I was wondering if anyone had any ideas on how to setup a system of logging into a db, the user creates a new record and is the only who can make any changes to it in the future. I know this will probably be a lengthy process, but any suggestions are appreciated. Thanks for your help.
  13. breaker11

    Search any part of field query...

    Joe, I just don't think I have the magic touch! I tried taking out all fields, tried with and without the string, and still all I have is my nice little error message to work with. I don't want to keep burdening you with this problem, so let me know if you have time to look at my db, and if...
  14. breaker11

    Having picture(s) in a database

    Ellie, She is going to have to point to where the picture is being stored, and she will have to click the "link" option in the insert object dialog box. I don't think there is a way around it. :( HTH
  15. breaker11

    Search any part of field query...

    Joe, I have a main menu list which displays all records. I created a command button that I want to perform this search, here is the sql code for the button: "SELECT DISTINCTROW Table1.Record, Table1.Product, Table1.ProjectName, CStr([ProductBulkNumber]) AS strProductBulkNumber...
  16. breaker11

    Search any part of field query...

    Joe, I am trying to build a search query to search a number field, and when I entered: strField1: CStr([Field1]) as the field name within the query, it still returned "Type mismatch." Without taking too much of your time, please let me know if you have any more ideas that could help...
  17. breaker11

    Search any part of field query...

    Cosmo, Thanks for the tip, it seems like it should work, but I keep getting and error saying, "Type Mismatch." I am not sure what I am doing wrong, I entered everything you suggested. Your help is greatly appreciated.
  18. breaker11

    Search any part of field query...

    Cosmo, I am only needing to query one field of all my records, is there a way to call up a dialog box, input some of the info, and have it display all fields with matching criteria? Thanks again.
  19. breaker11

    Search any part of field query...

    I am trying to set up a query where typing a value into a dialog box will query out all fields that contain that partial value. For example, say I want to search for all fields that have 9 as the first number, how do I query it out rather than only the exact value? I hope this is clear enough...
  20. breaker11

    Printing multiple pages of a linked OLE...

    I have a bound OLE within a form, and linked to it is a multiple page excel spreadsheet. I am wondering if there is a way to hit print once, and print the record, including all of the pages of the spreadsheet, rather than just the first page shown. Is this feasible? If anyone has any ideas...

Part and Inventory Search

Back
Top