| Clearer error message given when SMOG is unable to create a related object for a table, query, form or report, e.g. when the user has renamed the item. | 1.051
| |
More SMOGOptions added in the "POPULAR" section.
| 1.050
| |
| Added Close button on Options tab. | 1.049
| |
Tidied up error-handling.
| 1.048
| |
Now supplies default values for PPVs in order to avoid errors when no value has been entered in the USysPPVs or USysPPVsRemote tables.
Defaults are:
Boolean = False
String = ""
Everything else = 0
as suggested by Juan Soto.
|
1.047 |
|
| Creates new menu in VB Editor to get round internationalisation problem. |
1.046 |
Was causing problems in German when trying to find "Menu bar" and its "Tools" submenu to add the SMOG items to. |
| Now use same USysRegInfo info for all versions of Access following suggestion by André Minhorst. |
1.046 |
|
| Tidying up of documentation |
1.045 |
|
| Now creates a form or report module for the selected forms and reports thereby allowing the use of Form_MyFormName and Report_MyFormName-type syntax, e.g. Form_MyFormName.AllowEdits = True. |
1.044 |
|
| Added reminder to delete unwanted local PPVs when they have been used to create remote PPVs. |
1.043 |
|
| When frmSMOG is opened, the focus is put into txtSearch for easy seaching from the start. |
1.042 |
|
| Set up for Windows 2003 Server. |
1.041 |
|
| Set up for Access 2010 (CTP) and Windows 7. |
1.040 |
|
| Added ability to create shortcut on user's desktop to the relevant Access add-ins folder for ease of updating of SMOG. |
1.039 |
|
| Correction to DatabaseApplicationTitle and DatabaseApplicationIcon properties based on info from Stefan Schmeling. Also found error in DefaultMaxRecords. |
1.039 |
|
| LetterToUNC function was not returning correct value if user's database was not running from their system drive. Changed 'LetterToUNC = "Drive Letter Not Found"' to 'LetterToUNC = DriveLetter'. |
1.038 |
|
| Added line numbers back into procedures for easier error-handling. |
1.037 |
|
| Object names table (USysObjectNames) was not being made visible on main form (frmSMOG) when that form was opened for the very first time due to the table being created after the form was created and it not being requeried. Table now created before form is opened. |
1.036 |
|
| Added notes specific to the OS and the version of Access selected in the USysRegInfo form alerting user to need to use "Run as administrator" mode in Vista and to set add-ins folder as a Trusted Location for Access 2007. |
1.035 |
|
| No longer remove SMOG buttons on Tools menu in VB Editor window when frmSMOG closes. frmSMOG used to be just hidden when not in use, but is actually closed nowadays. The Form_Close code was thus removing the SMOG buttons on the Tools menu in the VB Editor. Have now removed the Form_Close code altogether. Note that closing Access causes the Tools menu to then reset automatically so nothing is left hanging. |
1.034 |
|
Split Persisted Private Variables into a table in the user's front-end and, if so desired, into their back-end database as well.
Moved Modifications History button to a separate tab. |
1.033 |
|
| Decided to actually close SMOG form whenever not in use despite it then removing the ability to open it or to run object generation directly from the Tools menu option in the VB Editor. Reason for this is that having a form open yet hidden in a user's application might cause them problems. |
1.032 |
|
| Create PPV table before SMOG form is opened for the very first time as it is used as the recordsource for fsubPPVs when that form opens. |
1.031 |
|
| Corrected insertion point for module headers in AddModuleHeader. Was adding at line 1 when it should have been at end of module. |
1.031 |
|
| Can set or disable AllowBypassKey in code using application options objects. |
1.030 |
|
Added ability to create objects from application options, e.g. can now use:
?AlwaysUseEventProcedures
and
AlwaysUseEventProcedures = True
instead of
?GetOption("Always Use Event Procedures")
and
SetOption "Always Use Event Procedures", True |
1.030 |
Have included some items that don't mean much in Access 2007. There are a small no. of items that are not settable or retrievable except through the UI. These have not been included.
Have created the items that are available in Access 2007. These may not always be the same as for previous versions.
Currently does not include items which are setting for the current database, e.g. "Display Form" except "Show Status Bar". |
| Query field names, table field names, form names and report names now require the full syntax of frmMyForm.Name rather than frmMyForm, qselMyQuery.Query.MyField.Name rather than qselMyQuery.Query.MyField. Done for greater clarity and consistency. |
1.029 |
|
| Modules now not deleted prior to generating text, but just delete their text. Access was sometimes having problem in deleting a module then adding it back in all in the same procedure which was sometimes generating error 32813 (and then error 17). |
1.028 |
Error No. 32813 (Method 'Name' of object '_VBComponent' failed) occurred in procedure 'AddModule' in module 'SMOGMain' in line no. 40.
Renamed DeleteModule as DeleteModuleText. |
| Details of known issues added to Help form. |
1.027 |
|
| USysDatabaseConstants table renamed as USysPPVs (Persisted Public Variables) and its field names modified to better reflect the use of its contents. Code modified to match. |
1.026 |
|
| Simplified seach function to use only one search box to cover searching in both used and unused objects lists. |
1.025 |
|
| Error handling tidied up and line numbers added. |
1.024 |
|
| Helper functions and constants modules no longer Private Module (though option for this left in as a comment). |
1.023 |
|
| Added "SMOG" function so that, once SMOG has been run just one time ever in a particular database, the developer can type in "SMOG" (no quotes) in the Immediate Window and press Enter to bring up the SMOG window. |
1.022 |
Gives the developer access to SMOG even if there is no ribbon/commandbar access to the Add-Ins. |
Added forms and reports into system so that their names can be used in an OO manner.
IMPORTANT - SEE NOTES==> |
1.021 |
* UsysObjectNames needs ObjectType field length changed from 5 to 6.
* Module names of Forms and Reports not allowed by VBA, so now use QueryObjects, TableObjects, FormObjects and ReportObjects. Remember to delete old Queries and Tables modules. |
| Tables which can be made into objects now include any Usys tables. |
1.020 |
|
| Module converting names of tables and queries (SuitableObjectName) extended to handle objects with "\" and "/" in their name. |
1.019 |
|
| Now sets recordsource of fsubDatabaseConstants in the Open event of that form rather than during Open event of frmSMOG. Also CheckConstantType uses txtConstantValue rather than the field ConstantValue. |
1.018 |
|
| Changed AddModuleProcedures so that it works for queries that contain a user-defined VBA function. |
1.017 |
When a module is deleted the Fields count for CurrentDb.QueryDefs(QueryName) gets set to 0 and for a query variable based on DBEngine(0)(0), but for DBEngine(0)(0).QueryDefs(QueryName) used directly! |
| "Usermaintainable" field was not correctly set up in constants form. |
1.016 |
|
Still faffing around with DBEngine. Now changed to:
' DBEngine(0)(0).TableDefs.Refresh
DBEngine(0)(0).Containers.Refresh
DBEngine(0)(0).QueryDefs.Refresh
as was not allowing creation of object for a newly created query. |
1.015 |
|
| Now allows a value to be a zero-length string. |
1.014 |
|
| Reverted to DBEngine(0)(0) from CurrentDb() as was not working with tables. Have now called a DBEngine(0).Databases.Refresh prior to creation of any modules. |
1.013 |
|
| Reverted to using CurrentDb() rather than DBEngine(0)(0) since queries being added during a session were not being found. Not sure how it got back to DBEngine(0)(0) in the first place. |
1.012 |
|
| Can now be used in situations where currentdb is on a UNC driver, e.g. running under Terminal Services. |
1.011 |
|
| It seems that only Access 2007 has a commanbar called "Status Bar") which needs to be made visible when using the built-in progress meter. |
1.010 |
|
| Added UserMaintainable field to USysConstants so that a developer can decide whether to expose some records to an end user. |
1.009 |
|
| Database constants now show in alphabetical order. |
1.008 |
|
| Can now remove unused objects. |
1.007 |
|
| When searching for an object using the search text boxes, the first found object is made visible in the listbox along with as many others as can fit. |
1.007 |
|
| Added details of where to download SMOG from into each SMOG-generated module. |
1.006 |
|
| Reverted to using CurrentDb() rather than DBEngine(0)(0). |
1.005 |
|
| Now includes ODBC-linked tables (type 4). |
1.004 |
|
| Tidied up closure of form used to set up add-in for the various Windows and Access versions. |
1.003 |
|
| Search facility added for the lists of tables and queries. |
1.002 |
|
| Added Constant Description field in USysDatabaseConstants |
1.001 |
|
| Initial creation of project to enable tables and queries to be used as objects. All query objects are now accessed from one standard module rather than two modules for the original version of SMOG. Ditto for tables. |
1.000 |
|