Search results

  1. S

    Custom Ribbon

    I have created a custom ribbon for my database. The problem is if I replace the default ribbon with my custom ribbon prior to splitting the database, I can't split the database. If I try to add the custom ribbon after the split, the name of the ribbon does not show up in the dropdown list...
  2. S

    Day of Month

    I have several reports that Divisions are supposed to send by the 10th of each month. I would like to set up a tracking matrix to send to my boss to show whether or not the Division has sent the report on time. I don't know how to write the formula so that the day is constant (10th).
  3. S

    User information

    Hello to all. I have a table for security in which the user logs in, is welcomed and goes to the main menu. The form is set up as a tabbed form with one tab for team members. On the tab is an edit button to open up a form to add new team member or edit an existing member. I have been...
  4. S

    method or data member not found

    I have the following code in the open event If User.AccessID = 1 Then Me.cmdAdmin.Enabled = True Else Me.cmdAdmin.Enabled = False End If I get the error "Method or data member not found" when the form opens. I would very much appreciate some insight.
  5. S

    Upgrade to 2007 project is locked

    I have upgraded from Access 2003 to to 2007 in Window XP. When trying to edit code I get the message Project Locked - "Project is unviewable". Sandy
  6. S

    Is Google a god?

    Submitted for your enjoyment The 10 Commandments of Google 1) Thou shalt have no other Search Engine before me, neither Yahoo nor Lycos, AltaVista nor Metacrawler. Thou shalt worship only me, and come to Google only for answers. 2) Thou shalt not build thy own commercial-free Search Engine...
  7. S

    Search form adapted from gromit is not working

    I adapted the seach form example that I found here by Gromit for the database I am working on. When I open the form I get the following error. I checked for missing references, misspelling and anything else that I can think of. Your help would be greatly appreciated.
  8. S

    concatenate not giving needed result

    After searching through 18 pages of search results I have not found the answer. Would someone please tell me why this expression is not working in my query? RCStatement: """&[RootCauseStatement]&""" The result is "&[RootCauseStatement]&"
  9. S

    Link to non-attached subform not working

    Hi super forum gurus I have what I hope is a simple problem. On tab D4 I have 2 subforms. The subforms are summary information and are not editable. When the user clicks on the statement text box, an edit form opens. The top subform performs as expected. The bottom subform does not when I...
  10. S

    Replace default text

    I have a form in which I will have several tabs. Each tab will have 1 or 2 subforms. On one tab I will have a subform called Symptom which is a one line description of the symptom. If no data has been entered, I would like "Symptom information not specified". If the user clicks on the Add...
  11. S

    undefined funtion in expression

    Hi I am using code I found seaching this website to convert fields in all CAPS to proper form. The code I am using is from Dennisk Function proper(strName) As String ' T-SQL by Jens-Michael Lehmann (SQL Server Central) ' Converts McDonalds, O'Brian's, MacPherson's and the Jens-Michael's of...
  12. S

    Subform not linking with master form possibly due to query or relationship

    Good morning all, I hope someone can help me. I stepped away from this database for awhile and now I am able to get back into it. I am building an engineering / part number tracking database. The database has a program which has many part families. Each part family has many assemblies. Each...
  13. S

    linked subform

    I am designing a database for our engineering group. In the database I have the following tables; tProgram, tPartFamily, tAssembly, tSubAssembly, tSub2Assembly, tComponent, tMaterial and tProcess. I have attached a relationship screenshot. Using search I have found a partial answer to my...
Back
Top Bottom