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.
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.
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...
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.
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...