Search results

  1. P

    stLinkCriteria

    Hi, I can't seem to combine these to one button. I need to open a form based on the values in two fields. Seperatly they work, when i try to combine them using the AND function it comes up with the error data mismatch. Private Sub cmdEvidenceSummary_Click() On Error GoTo...
  2. P

    Q&a

    Hi, I'm trying to create a database that holds data on people and some questions. I have created two tables one for the people and one for the questions. Is there a way that i can link the two tables so that when one of the people answers the questions the answers are linked to that person? I...
  3. P

    Outlook Wont Start

    Hello, After using the Beta Version of Office 2007 i uninstalled it and tried to use out look but get the message. "Cannot start Microsoft Office Outlook. MAPI32.DLL is corrupt or the wrong version. This could have been caused by installing other messaging software. Please reinstall Outlook."...
  4. P

    Open Windows Exporer

    Hello, I'm using the following code to create folders, which seems to work fine. Private Sub CmdCreateAreas_Click() strDirectoryPath1 = DLookup("Centre_DataLocation", "T_CentreDetails") & "\Files\Students Files\Stored Assessments\" & [MainFolder] MkDir (strDirectoryPath1) End Sub What i...
  5. P

    IF Statement help

    Help!! I'm having real problems with forms in word... I have a drop down list named Dropdown1. I have a text box called Text1 with the function: {if Dropdown1="A" "Y" "N"} Whatever i try to do with this it will not display the correct result. Can anyone help or point me in the direction of a...
    • *Pete*
    • Thread
    • Replies: 5
    • Forum: Word
  6. P

    Trap Error

    Hi, I have a button that creates a folder, but if the folder already exists it comes up with a Run Time Error 75. I have the following code to try to stop this but it does not seem to work. Does anyone have any sugestions on how i can fix this. If DataErr = 75 Then MsgBox " Already Exists"...
  7. P

    Update Unbound TextBox

    Hello, I'm having a problem with one of my forms, i have created an unbound text box called Hours. In it i will type a number. Then click on a button to create a report based on this number. what is happening though is that when i click the report button the report is blank, if i close the...
Top Bottom