DAO Properties

[mcgilla]

I think I need to go and introduce myself as I've noticed there's a place for that..

I've found this to be a great place to ask a question and get a good answer. I've tried searching but I think I'm possibly not searching the forum or Google with the right keywords.

I found in here where you can run a little code to disable some of the DAO properties such as AllowByPassKey. Is there a list of such properties so I can see what properties can be changed?

If it's here, I've not used the right keywords/tags to find it. Found a lot of interesting ideas in the process however..

Thanks,
Ed

 

[the_net_2.0]

what do you mean, mc?

I don't think there is really a concept called 'dao properties'. There is code here to disable the SHIFT bypass, yes, but what else are you looking for? DAO is not really related to Access as a program, per se. It's a library and a technology developed by MS by which you can manipulate data and data objects.

 

[mcgilla]

I figured I probably asked the question wrong.. My guess by your response is these are embeded more in Access and DAO allows you to manipulate the objects.

Let me use a snip from some code I found while searching for a potential list.. This may clarify a bit better.

Credit to Gemma for this copy and paste..

ChangeProperty "AllowBreakIntoCode", dbBoolean, False 'show code after error
ChangeProperty "AllowSpecialKeys", dbBoolean, False 'special keys
ChangeProperty "AllowBypassKey", dbBoolean, False 'bypass key
ChangeProperty "StartupShowStatusBar", dbBoolean, True 'status bar
ChangeProperty "AllowFullMenus", dbBoolean, False 'full menus
ChangeProperty "AllowShortCutMenus", dbBoolean, True 'fullmenus
ChangeProperty "AllowBuiltinToolbars",

etc.

These are all properties (and maybe property is the wrong word) that have to be added and then you can make them true or false and maniuplate the functionality and layout of access. They are already embeded somewhere and have a quick and useful meaning behind them but for instance I couldn't just make a "MakeAccessPurple" line at the bottom of this and expect everything to turn purple.

Not that I want purple, I'd like to see the list of things available to manipulate..

Thanks,
Ed

 

[the_net_2.0]

very nice, mc.

that looks like options that are in the 'options' section of the program. again, you can get a list of these, like other props and methods, by enumerating in code. I found this code once too:

   With Application
      'DELETE OPTIONS NOT BEING ALTERED
      .SetOption "Always Use Event Procedures", False / True
      .SetOption "ANSI Query Mode Default", False / True
      .SetOption "ANSI Query Mode", False / True
      .SetOption "Arrow Key Behavior", False / True
      .SetOption "Auto Compact", False / True
      .SetOption "AutoIndex on Import/Create", ENUMERATED
      .SetOption "Behavior Entering Field", False / True
      .SetOption "Bottom Margin", ENUMERATED
      .SetOption "Command-Line Arguments", ENUMERATED
      .SetOption "Common Report Errors Error Checking", False / True
      .SetOption "Confirm Action Queries", False / True
      .SetOption "Confirm Document Deletions", False / True
      .SetOption "Confirm Record Changes", False / True
      .SetOption "Cursor movement", False / True
      .SetOption "Cursor Stops at First/Last Field", False / True
      .SetOption "Database Explorer Click Behavior", ENUMERATED
      .SetOption "Datasheet Ime Control", False / True
      .SetOption "Default Background Color", False / True
      .SetOption "Default Cell Effect", False / True
      .SetOption "Default Column Width", ENUMERATED
      .SetOption "Default Database Directory", ENUMERATED
      .SetOption "Default direction", False / True
      .SetOption "Default Field Type", False / True
      .SetOption "Default File Format", ENUMERATED
      .SetOption "Default Find/Replace Behavior", False / True
      .SetOption "Default Font Color", False / True
      .SetOption "Default Font Italic", False / True
      .SetOption "Default Font Name", ENUMERATED
      .SetOption "Default Font Size", ENUMERATED
      .SetOption "Default Font Underline", False / True
      .SetOption "Default Font Weight", ENUMERATED
      .SetOption "Default Gridlines Color", False / True
      .SetOption "Default Gridlines Horizontal", False / True
      .SetOption "Default Gridlines Vertical", False / True
      .SetOption "Default Number Field Size", ENUMERATED
      .SetOption "Default Open Mode for Databases", False / True
      .SetOption "Default Record Locking", False / True
      .SetOption "Default Text Field Size", ENUMERATED
      .SetOption "Enable AutoJoin", False / True
      .SetOption "Enable DDE Refresh", False / True
      .SetOption "Enable Error Checking", False / True
      .SetOption "Enable MRU File List", False / True
      .SetOption "Error Checking Indicator Color", ENUMERATED
      .SetOption "Form Template", ENUMERATED
      .SetOption "Four-Digit Year Formatting All Databases", False / True
      .SetOption "Four-Digit Year Formatting", False / True
      .SetOption "General alignment", False / True
      .SetOption "Ignore DDE Requests", False / True
      .SetOption "Ime Autocommit", False / True
      .SetOption "Invalid Control Properties Error Checking", False / True
      .SetOption "Keyboard Shortcut Errors Error Checking", False / True
      .SetOption "Left Margin", ENUMERATED
      .SetOption "Log Name AutoCorrect Changes", False / True
      .SetOption "Move After Enter", ENUMERATED
      .SetOption "New Database Sort Order", ENUMERATED
      .SetOption "New Unassociated Labels Error Checking", False / True
      .SetOption "Number of Update Retries", ENUMERATED
      .SetOption "ODBC Refresh Interval (sec)", ENUMERATED
      .SetOption "OLE/DDE Timeout (sec)", ENUMERATED
      .SetOption "Output All Fields", False / True
      .SetOption "Perform Name AutoCorrect", False / True
      .SetOption "Provide Feedback with Sound", False / True
      .SetOption "Query Design Font Name", ENUMERATED
      .SetOption "Query Design Font Size", ENUMERATED
      .SetOption "Refresh Interval (sec)", ENUMERATED
      .SetOption "Remove Personal Information", False / True
      .SetOption "Report Template", ENUMERATED
      .SetOption "Right Margin", ENUMERATED
      .SetOption "Run Permissions", ENUMERATED
      .SetOption "Selection Behavior", False / True
      .SetOption "Show Animations", False / True
      .SetOption "Show Conditions Column", False / True
      .SetOption "Show Hidden Objects", False / True
      .SetOption "Show Macro Names Column", False / True
      .SetOption "Show New Object Shortcuts", False / True
      .SetOption "Show Property Update Options buttons", False / True
      .SetOption "Show Smart Tags on Datasheets", False / True
      .SetOption "Show Startup Dialog Box", False / True
      .SetOption "Show Status Bar", False / True
      .SetOption "Show System Objects", False / True
      .SetOption "Show Table Names", False / True
      .SetOption "Show Values in Indexed", False / True
      .SetOption "Show Values in Non-Indexed", False / True
      .SetOption "Show Values in Remote", False / True
      .SetOption "Show Values in Server", False / True
      .SetOption "Show Values in Snapshot", False / True
      .SetOption "Show Values Limit", ENUMERATED
      .SetOption "ShowWindowsInTaskbar", False / True
      .SetOption "Size of MRU File List", ENUMERATED
      .SetOption "Spelling add words to", False / True
      .SetOption "Spelling Arabic modes", ENUMERATED
      .SetOption "Spelling combine aux verb/adj", False / True
      .SetOption "Spelling dictionary language", False / True
      .SetOption "Spelling Hebrew modes", False / True
      .SetOption "Spelling ignore Internet and file addresses", False / True
      .SetOption "Spelling ignore words in UPPERCASE", False / True
      .SetOption "Spelling ignore words with number", False / True
      .SetOption "Spelling process compound nouns False / True"
      .SetOption "Spelling suggest from main dictionary only", False / True
      .SetOption "Spelling use auto-change list", False / True
      .SetOption "Spelling use German post-reform rules", False / True
      .SetOption "Themed Form Controls", False / True
      .SetOption "Top Margin", ENUMERATED
      .SetOption "Track Name AutoCorrect Info", False / True
      .SetOption "Unassociated Label and Control Error Checking", False / True
      .SetOption "Update Retry Interval (msec)", ENUMERATED
      .SetOption "Use Hijri Calendar", False / True
      .SetOption "Use Row Level Locking", False / True
   End With

it looks like that shows the possiblities of changing these types of things in code as well.

Personally, I've browsed the net looking for good references on libraries, structures, constants, etc. But I haven't found much that you can produce a readable structure from. e.g. - copy/paste code lists into a database and manipulate them into a 3-dimensional, readable structure.

The best thing I've seen for decompiling libraries and DLL files into useable code is MS's API viewer. It's extremely good for gathering information about these files and such. And they're exportable to text files, which can be queried into readable lists, etc...

That's off subject though, sorry! At any rate, the best bet you have to gather knowledge about property/methods lists is the enumeration in code, or DISASM programs like api viewer (if you're interested in external libraries).