ResourcefulDB
asked on
MS ACCESS Switchboard manager question
Experts,
I have a question that can either be solved in switchboard manager or form design. Basically, when we go to tools -> database utilities -> switchboard manager to edit a switchboard, the drawdown menu for the command only let us to choose from Open form in edit mode and open form in add mode. So, is there a way to open form in view mode only?
A related question, is there a way to get rid of record scroll bar the usually appear at the bottom left of the form whenever we open it? So that one can not scroll all the way to the end and add more records.
Thanks,
RDB
I have a question that can either be solved in switchboard manager or form design. Basically, when we go to tools -> database utilities -> switchboard manager to edit a switchboard, the drawdown menu for the command only let us to choose from Open form in edit mode and open form in add mode. So, is there a way to open form in view mode only?
A related question, is there a way to get rid of record scroll bar the usually appear at the bottom left of the form whenever we open it? So that one can not scroll all the way to the end and add more records.
Thanks,
RDB
Version of Access??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Never mind, I think I got it. need to write VBA code as
DoCmd.OpenForm rs![Argument], , , , acReadOnly
to open form in read only mode.
DoCmd.OpenForm rs![Argument], , , , acReadOnly
to open form in read only mode.
Ahh, so that's what you wanted! Well, I hope I at least gave you some useful information.
Thanks for the grade :)
Thanks for the grade :)