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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: cani
  • Content: Threads
  • Order by date
  1. cani

    Enable Shift ByPass Remotely

    I locked myself out of the design view of my database, and need to be able to get back With my limited Access Project knowledge, I believe my options are (1) bypass startup options to turn on full menus so I can get to the design view or (2)create another database and import the forms and...
  2. cani

    Send Password to VBE from another DB

    Does anyone know how to send a password to the VBE of another Access Project? I mistakenly locked the design through the startup properties. I have also disabled the shift bypass. To get around it, I've created a new Access Project and wish to import the forms. If another method would...
  3. cani

    Preventing Changes to Tool/Menu Bars

    I want to prevent users from getting to the database Window in an ADP file. I'm hiding the Window, disabling the toolbars, etc., and disabling the shift key; however, (although no user has figured it out yet) the main weakness is with reports. I am displaying a custom tool bar to enable...
  4. cani

    Newbie-open a user defined function recordset in an Access Project

    Help! I need to assign a recordset to an MS Access Project form. The recordset is based on a SQL function that seeks an input parameter to return one record. The objective is to return a record from SQL Srv 2000 that has a company name (key field) that is equivalent to a value selected from a...
  5. cani

    Hiding tables using SQL or DAO, or all new tables with hide default

    Good day! Does anyone know how to do one of the following: 1) Use SQL to hide a table so that it does not appear in the database window 2) Use DAO to hide a table; or 3) Adjust a database setting so that all forms, tables, macros, reports, etc., that are created have the hide property...
  6. cani

    Programming Security Permissions using VBA

    Hello, I had an access (mdb file) 97 database that used code to assign security permissions to a table for a particular group. It worked fine (the code is below). I then upgraded to Office XP and the file was converted into 2000 file format. The procedure stopped working. Now I get the...
  7. cani

    How many indexes can a table have?

    I have a database that holds information concerning several companies. Each company has several company-specific tables plus there are common tables. When a company is set up the database automatically creates all company specific tables, primary keys, indexes, etc., plus relationships with...

Part and Inventory Search

Back
Top