Link to home
Create AccountLog in
Avatar of mytfein
mytfein

asked on

new to Access 2010.... converted mdb to accdb ... startup properties

Hi EE,

Under A2003:

Many years ago,  a colleague, who i lost touch with
      gave me logic to set up application properites

Although a user can break into a mdb using shift + f11
    he showed me how to use application properties
             to hide menu bars etc.  when want the screen to operate in prod mode
             to show menu bars etc   when want to test.

He taught me to create 2 transparent buttons.
        alt+p   - would set the screen to prod mode
        alt+t    - would set the screen to test mode

Uploaded a sample mdb that converted to accdb.
Made the 2 command buttons described above visible.

When i do alt+p, am getting an error when creating the start up form property....
              "type mismatch"

Could you pls help me fix this error,
tx, sandra
2013-05-21a-error.bmp
2013-05-21b-error.bmp
2013-05-21c-error.bmp
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Alt+P is the Print command, so I assume your colleague has included custom code to "set the screen to prod mode" and such. You'd have to find that code (most likely it's in a macro named AutoKeys).
<Uploaded a sample mdb that converted to accdb.>

there is nothing uploaded.. try again
Avatar of mytfein
mytfein

ASKER

Avatar of mytfein

ASKER

Hi Gentlemen,

tx for responding,

just uploaced accdb file.

tx so much, s
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of mytfein

ASKER

tx Cap!

will get back to you...    s
Avatar of mytfein

ASKER

Hi Cap,

when i open accdb on my machine this is what shows:
2013-05-22a-error.bmp
Avatar of mytfein

ASKER

User generated image
use the ARROWS UP- DOWN to position the references
DO NOT Delete them
Avatar of mytfein

ASKER

Hi Cap,

when i compare my image to your image, i reversed the last 2 checked items

to put extensibility  before object library

is this what you mean? bec. i still get the error.....

tx, s
upload a new image of your references
Avatar of mytfein

ASKER

User generated image
Look at the image i posted above, and follow the ARRANGEMENT (from the TOP) of the references.
Avatar of mytfein

ASKER

Hi Cap,

your're right.... i fixed the references and it works...

i still have more questions, so will create new posts,

tx for your help, s