Search results

  1. M

    Wrapping up an app

    For showing prototype screens, I use a screen capture app, like SnagIt. That way I can crop the image to just what I want them to see. Later on, I also use the screen images in the instructions that guide the users through my app.
  2. M

    Best way to connect to BE database

    Code I found to kill the ribbon: DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.SelectObject acForm, "frmResp", True DoCmd.RunCommand acCmdWindowHide Throw that into your AutoExec module.
  3. M

    How to connect to a BE database?

    Access 2007, split database, 9 users. I have been able to link the BE tables with the Linked Table Manager. I use the DNS name path because everyone has different drive mappings. I can open my linked tables as a RecordSet and AddNew and Update records. However, I cannot Seek and Edit the...
  4. M

    Append and update query with vba

    Mischa - For this type of situation, I use a checkbox instead of a combo box. That will give you a boolean value for your Yes/No field. Only drawback is that you need a default value (usually "No" or unchecked) and you cannot allow a Null, or undecided, option.
  5. M

    Vertical scroll bar won't scroll worksheet

    Since this is only affecting one worksheet in one workbook, this is how I would deal with it. Create a new workbook (in Excel 2007). Copy the data from the misbehaving worksheet. Paste it into the new workbook. Move all the other sheets to the new workbook. Delete the old 2003 workbook with the...
Back
Top Bottom