|
|
|
Menu
Content
Resources
To Do
Toolbox
|
Menu Bar
TRY-WIKI-TOOLBAR->>> (Menu Bar VBE) , Menu Bar: >Top.?<, File, Edit, View, Insert, Tools, Window, Help, Bottom
[edit] AC.2002/2003Menu Bar VBE ( VBE = Visual Basic Editor ) [edit] Menu BarWiki-link: [[Menu Bar#Menu Bar|Ac_Menu,Menu Bar]] [edit] FileWiki-link: [[Menu Bar#File|Ac_Menu,File]] [edit] File,New...Wiki-link: [[Menu Bar#File,New...|Ac_Menu,New...]] [edit] File,Open...Wiki-link: [[Menu Bar#File,Open...|Ac_Menu,Open...]]
[edit] File,Get External DataWiki-link: [[Menu Bar#File,Get External Data|Ac_Menu,Get External Data]] [edit] File,Get External Data,Import...Wiki-link: [[Menu Bar#File,Get External Data,Import...|Ac_Menu,Import...]]
CODE Application.SetOption "Show Hidden Objects", True
CODE DoCmd.RunCommand acCmdImport
VBE_Menu,Microsoft Visual Basic Help , Answer wizard=TransferDatabase, or in VBE_Menu,Immediate Window type.. CODE ' go with Cursor *inside-of-word* TransferDatabase , and press F1 Docmd.TransferDatabase
SQL ' Connect (Without Import / Link) SELECT * FROM [tbl_Name] IN [MS ACCESS;Database=D:\_Your_Path\Your_DatabaseName.MDB;PWD=YourDatabasePassword_Or_Blank;]
[edit] File,Get External Data,Link Tables...Wiki-link: [[Menu Bar#File,Get External Data,Link Tables...|Ac_Menu,Link Tables...]] [edit] File,CloseWiki-link: [[Menu Bar#File,Close|Ac_Menu,Close]] [edit] File,SaveWiki-link: [[Menu Bar#File,Save|Ac_Menu,Save]] [edit] File,Save As...Wiki-link: [[Menu Bar#File,Save As...|Ac_Menu,Save As...]]
[edit] File,Back Up Database...Wiki-link: [[Menu Bar#File,Back Up Database...|Ac_Menu,Back Up Database...]] [edit] File,Export...Wiki-link: [[Menu Bar#File,Export...|Ac_Menu,Export...]]
[edit] File,Search...Wiki-link: [[Menu Bar#File,Search...|Ac_Menu,Search...]] [edit] File,Page Setup...Wiki-link: [[Menu Bar#File,Page Setup...|Ac_Menu,Page Setup...]] [edit] File,Print PreviewWiki-link: [[Menu Bar#File,Print Preview|Ac_Menu,Print Preview]] [edit] File,Print...Wiki-link: [[Menu Bar#File,Print...|Ac_Menu,Print...]] [edit] File,Send ToWiki-link: [[Menu Bar#File,Send To|Ac_Menu,Send To]] [edit] File,Send To,Mail RecipientWiki-link: [[Menu Bar#File,Send To,Mail Recipient|Ac_Menu,Mail Recipient]] [edit] File,Send To,Mail Recipient (as Attachment)...Wiki-link: [[Menu Bar#File,Send To,Mail Recipient (as Attachment)...|Ac_Menu,Mail Recipient (as Attachment)...]] [edit] File,Database PropertiesWiki-link: [[Menu Bar#File,Database Properties|Ac_Menu,Database Properties]]
CODE debug.Print "##,Name,Type of DB-Property":for i = 0 to CurrentDb.Properties.Count-1: debug.Print i & "," & CurrentDb.Properties(i).Name & "," & CurrentDb.Properties(i).type:next i debug.Print "##,Name--------------------------,Type,Value of DB-Property":for i = 0 to CurrentDb.Properties.Count-1: lc1= format(i,"00") & "," & LEFT$(CurrentDb.Properties(i).Name & SPACE$(100),30):select case CurrentDb.Properties(i).Type:case 15,0:lc1=lc1 & "......skip":case else:lc1=lc1 & "," & format(CurrentDb.Properties(i).type,"00") & " ," & CurrentDb.Properties(i).Value:end select:debug.Print lc1:next i [edit] File,ExitWiki-link: [[Menu Bar#File,Exit|Ac_Menu,Exit]]
CODE Quit docmd.RunCommand acCmdExit [edit] EditWiki-link: [[Menu Bar#Edit|Ac_Menu,Edit]] [edit] Edit,Can`t UndoWiki-link: [[Menu Bar#Edit,Can`t Undo|Ac_Menu,Can`t Undo]] [edit] Edit,CutWiki-link: [[Menu Bar#Edit,Cut|Ac_Menu,Cut]] [edit] Edit,CopyWiki-link: [[Menu Bar#Edit,Copy|Ac_Menu,Copy]] [edit] Edit,Office Clipboard...Wiki-link: [[Menu Bar#Edit,Office Clipboard...|Ac_Menu,Office Clipboard...]] [edit] Edit,PasteWiki-link: [[Menu Bar#Edit,Paste|Ac_Menu,Paste]] [edit] Edit,Create Shortcut...Wiki-link: [[Menu Bar#Edit,Create Shortcut...|Ac_Menu,Create Shortcut...]] [edit] Edit,DeleteWiki-link: [[Menu Bar#Edit,Delete|Ac_Menu,Delete]] [edit] Edit,RenameWiki-link: [[Menu Bar#Edit,Rename|Ac_Menu,Rename]] [edit] Edit,GroupsWiki-link: [[Menu Bar#Edit,Groups|Ac_Menu,Groups]] [edit] Edit,Groups,New Group...Wiki-link: [[Menu Bar#Edit,Groups,New Group...|Ac_Menu,New Group...]] [edit] Edit,Groups,Rename Group...Wiki-link: [[Menu Bar#Edit,Groups,Rename Group...|Ac_Menu,Rename Group...]] [edit] Edit,Groups,Delete GroupWiki-link: [[Menu Bar#Edit,Groups,Delete Group|Ac_Menu,Delete Group]] [edit] Edit,Add to GroupWiki-link: [[Menu Bar#Edit,Add to Group|Ac_Menu,Add to Group]] [edit] Edit,Add to Group,New Group...Wiki-link: [[Menu Bar#Edit,Add to Group,New Group...|Ac_Menu,New Group...]] [edit] ViewWiki-link: [[Menu Bar#View|Ac_Menu,View]] [edit] View,Database ObjectsWiki-link: [[Menu Bar#View,Database Objects|Ac_Menu,Database Objects]] [edit] View,Database Objects,TablesWiki-link: [[Menu Bar#View,Database Objects,Tables|Ac_Menu,Tables]] [edit] View,Database Objects,QueriesWiki-link: [[Menu Bar#View,Database Objects,Queries|Ac_Menu,Queries]] [edit] View,Database Objects,FormsWiki-link: [[Menu Bar#View,Database Objects,Forms|Ac_Menu,Forms]] [edit] View,Database Objects,ReportsWiki-link: [[Menu Bar#View,Database Objects,Reports|Ac_Menu,Reports]] [edit] View,Database Objects,PagesWiki-link: [[Menu Bar#View,Database Objects,Pages|Ac_Menu,Pages]] [edit] View,Database Objects,MacrosWiki-link: [[Menu Bar#View,Database Objects,Macros|Ac_Menu,Macros]] [edit] View,Database Objects,ModulesWiki-link: [[Menu Bar#View,Database Objects,Modules|Ac_Menu,Modules]] [edit] View,Large IconsWiki-link: [[Menu Bar#View,Large Icons|Ac_Menu,Large Icons]] [edit] View,Small IconsWiki-link: [[Menu Bar#View,Small Icons|Ac_Menu,Small Icons]] [edit] View,ListWiki-link: [[Menu Bar#View,List|Ac_Menu,List]] [edit] View,DetailsWiki-link: [[Menu Bar#View,Details|Ac_Menu,Details]] [edit] View,Arrange IconsWiki-link: [[Menu Bar#View,Arrange Icons|Ac_Menu,Arrange Icons]] [edit] View,Arrange Icons,By NameWiki-link: [[Menu Bar#View,Arrange Icons,By Name|Ac_Menu,By Name]] [edit] View,Arrange Icons,By TypeWiki-link: [[Menu Bar#View,Arrange Icons,By Type|Ac_Menu,By Type]] [edit] View,Arrange Icons,By CreatedWiki-link: [[Menu Bar#View,Arrange Icons,By Created|Ac_Menu,By Created]] [edit] View,Arrange Icons,By ModifiedWiki-link: [[Menu Bar#View,Arrange Icons,By Modified|Ac_Menu,By Modified]] [edit] View,Arrange Icons,Auto ArrangeWiki-link: [[Menu Bar#View,Arrange Icons,Auto Arrange|Ac_Menu,Auto Arrange]] [edit] View,Line Up IconsWiki-link: [[Menu Bar#View,Line Up Icons|Ac_Menu,Line Up Icons]] [edit] View,PropertiesWiki-link: [[Menu Bar#View,Properties|Ac_Menu,Properties]] [edit] View,CodeWiki-link: [[Menu Bar#View,Code|Ac_Menu,Code]] [edit] View,ToolbarsWiki-link: [[Menu Bar#View,Toolbars|Ac_Menu,Toolbars]] [edit] View,Toolbars,DatabaseWiki-link: [[Menu Bar#View,Toolbars,Database|Ac_Menu,Database]] [edit] View,Toolbars,Task PaneWiki-link: [[Menu Bar#View,Toolbars,Task Pane|Ac_Menu,Task Pane]] [edit] View,Toolbars,WebWiki-link: [[Menu Bar#View,Toolbars,Web|Ac_Menu,Web]] [edit] View,Toolbars,Customize...Wiki-link: [[Menu Bar#View,Toolbars,Customize...|Ac_Menu,Customize...]] [edit] View,RefreshWiki-link: [[Menu Bar#View,Refresh|Ac_Menu,Refresh]] [edit] InsertWiki-link: [[Menu Bar#Insert|Ac_Menu,Insert]]
[edit] Insert,TableWiki-link: [[Menu Bar#Insert,Table|Ac_Menu,Table]]
[edit] Insert,QueryWiki-link: [[Menu Bar#Insert,Query|Ac_Menu,Query]] SQL ' see link above SELECT ColumnName1,Column_Name_2,[Column Name with Space] FROM tblTableName WHERE (ColumnName1=6) AND ([Column Name with Space] = 'ABCD');
[edit] Insert,FormWiki-link: [[Menu Bar#Insert,Form|Ac_Menu,Form]]
[edit] Insert,ReportWiki-link: [[Menu Bar#Insert,Report|Ac_Menu,Report]] [edit] Insert,PageWiki-link: [[Menu Bar#Insert,Page|Ac_Menu,Page]]
[edit] Insert,MacroWiki-link: [[Menu Bar#Insert,Macro|Ac_Menu,Macro]]
[edit] Insert,ModuleWiki-link: [[Menu Bar#Insert,Module|Ac_Menu,Module]]
CODE lnx = 0: For I2 = 1 To Application.VBE.VBProjects.Count: For I = 1 To Application.VBE.VBProjects(I2).VBComponents.Count: ln1 = Application.VBE.VBProjects(I2).VBComponents(Application.VBE.VBProjects(I2).VBComponents(I).Name).CodeModule.CountOfLines: lnx = lnx + ln1: Debug.Print I & "," & Left$(Application.VBE.VBProjects(I2).VBComponents(I).Name & Space$(50), 25); "," & ln1: Next I: Debug.Print "Project-" & I2 & ": " & Application.VBE.VBProjects(I2).Name & ", TOTAL-LINES: " & lnx: Debug.Print "------ END-OF-PROJECT-" & I2 & " ------": Next I2 [edit] Insert,Class ModuleWiki-link: [[Menu Bar#Insert,Class Module|Ac_Menu,Class Module]] [edit] Insert,AutoFormWiki-link: [[Menu Bar#Insert,AutoForm|Ac_Menu,AutoForm]] [edit] Insert,AutoReportWiki-link: [[Menu Bar#Insert,AutoReport|Ac_Menu,AutoReport]] [edit] ToolsWiki-link: [[Menu Bar#Tools|Ac_Menu,Tools]] [edit] Tools,Spelling...Wiki-link: [[Menu Bar#Tools,Spelling...|Ac_Menu,Spelling...]] [edit] Tools,Office LinksWiki-link: [[Menu Bar#Tools,Office Links|Ac_Menu,Office Links]] [edit] Tools,Office Links,Merge It with Microsoft WordWiki-link: [[Menu Bar#Tools,Office Links,Merge It with Microsoft Word|Ac_Menu,Merge It with Microsoft Word]] [edit] Tools,Office Links,Publish It with Microsoft WordWiki-link: [[Menu Bar#Tools,Office Links,Publish It with Microsoft Word|Ac_Menu,Publish It with Microsoft Word]] [edit] Tools,Office Links,Analyze It with Microsoft ExcelWiki-link: [[Menu Bar#Tools,Office Links,Analyze It with Microsoft Excel|Ac_Menu,Analyze It with Microsoft Excel]] [edit] Tools,SpeechWiki-link: [[Menu Bar#Tools,Speech|Ac_Menu,Speech]] [edit] Tools,Online CollaborationWiki-link: [[Menu Bar#Tools,Online Collaboration|Ac_Menu,Online Collaboration]] [edit] Tools,Online Collaboration,Meet NowWiki-link: [[Menu Bar#Tools,Online Collaboration,Meet Now|Ac_Menu,Meet Now]] [edit] Tools,Relationships...Wiki-link: [[Menu Bar#Tools,Relationships...|Ac_Menu,Relationships...]] [edit] Tools,AnalyzeWiki-link: [[Menu Bar#Tools,Analyze|Ac_Menu,Analyze]] [edit] Tools,Analyze,TableWiki-link: [[Menu Bar#Tools,Analyze,Table|Ac_Menu,Table]] [edit] Tools,Analyze,PerformanceWiki-link: [[Menu Bar#Tools,Analyze,Performance|Ac_Menu,Performance]]
[edit] Tools,Analyze,DocumenterWiki-link: [[Menu Bar#Tools,Analyze,Documenter|Ac_Menu,Documenter]] [edit] Tools,Database UtilitiesWiki-link: [[Menu Bar#Tools,Database Utilities|Ac_Menu,Database Utilities]] [edit] Tools,Database Utilities,Convert DatabaseWiki-link: [[Menu Bar#Tools,Database Utilities,Convert Database|Ac_Menu,Convert Database]] [edit] Tools,Database Utilities,Convert Database,To Access 97 File Format...Wiki-link: [[Menu Bar#Tools,Database Utilities,Convert Database,To Access 97 File Format...|Ac_Menu,To Access 97 File Format...]] [edit] Tools,Database Utilities,Convert Database,To Access 2000 File Format...Wiki-link: [[Menu Bar#Tools,Database Utilities,Convert Database,To Access 2000 File Format...|Ac_Menu,To Access 2000 File Format...]] [edit] Tools,Database Utilities,Convert Database,To Access 2002 File Format...Wiki-link: [[Menu Bar#Tools,Database Utilities,Convert Database,To Access 2002 File Format...|Ac_Menu,To Access 2002 File Format...]] [edit] Tools,Database Utilities,Compact and Repair Database...Wiki-link: [[Menu Bar#Tools,Database Utilities,Compact and Repair Database...|Ac_Menu,Compact and Repair Database...]]
[edit] Tools,Database Utilities,Back Up Database...Wiki-link: [[Menu Bar#Tools,Database Utilities,Back Up Database...|Ac_Menu,Back Up Database...]] [edit] Tools,Database Utilities,Linked Table ManagerWiki-link: [[Menu Bar#Tools,Database Utilities,Linked Table Manager|Ac_Menu,Linked Table Manager]] [edit] Tools,Database Utilities,Database SplitterWiki-link: [[Menu Bar#Tools,Database Utilities,Database Splitter|Ac_Menu,Database Splitter]]
[edit] Tools,Database Utilities,Switchboard ManagerWiki-link: [[Menu Bar#Tools,Database Utilities,Switchboard Manager|Ac_Menu,Switchboard Manager]] [edit] Tools,Database Utilities,Upsizing WizardWiki-link: [[Menu Bar#Tools,Database Utilities,Upsizing Wizard|Ac_Menu,Upsizing Wizard]] [edit] Tools,Database Utilities,Make MDE File...Wiki-link: [[Menu Bar#Tools,Database Utilities,Make MDE File...|Ac_Menu,Make MDE File...]]
CODE SysCmd 603, Your_Application_Path_MDB, Your_Application_Path_MDE [edit] Tools,SecurityWiki-link: [[Menu Bar#Tools,Security|Ac_Menu,Security]]
[edit] Tools,Security,Set Database Password...Wiki-link: [[Menu Bar#Tools,Security,Set Database Password...|Ac_Menu,Set Database Password...]] [edit] Tools,Security,Workgroup Administrator...Wiki-link: [[Menu Bar#Tools,Security,Workgroup Administrator...|Ac_Menu,Workgroup Administrator...]] [edit] Tools,Security,User and Group Permissions...Wiki-link: [[Menu Bar#Tools,Security,User and Group Permissions...|Ac_Menu,User and Group Permissions...]] [edit] Tools,Security,User and Group Accounts...Wiki-link: [[Menu Bar#Tools,Security,User and Group Accounts...|Ac_Menu,User and Group Accounts...]] [edit] Tools,Security,User-Level Security Wizard...Wiki-link: [[Menu Bar#Tools,Security,User-Level Security Wizard...|Ac_Menu,User-Level Security Wizard...]] [edit] Tools,Security,Encrypt/Decrypt Database...Wiki-link: [[Menu Bar#Tools,Security,Encrypt/Decrypt Database...|Ac_Menu,Encrypt/Decrypt Database...]] [edit] Tools,ReplicationWiki-link: [[Menu Bar#Tools,Replication|Ac_Menu,Replication]] [edit] Tools,Replication,Synchronize Now...Wiki-link: [[Menu Bar#Tools,Replication,Synchronize Now...|Ac_Menu,Synchronize Now...]] [edit] Tools,Replication,Create Replica...Wiki-link: [[Menu Bar#Tools,Replication,Create Replica...|Ac_Menu,Create Replica...]] [edit] Tools,Replication,Partial Replica WizardWiki-link: [[Menu Bar#Tools,Replication,Partial Replica Wizard|Ac_Menu,Partial Replica Wizard]] [edit] Tools,Replication,Recover Design Master...Wiki-link: [[Menu Bar#Tools,Replication,Recover Design Master...|Ac_Menu,Recover Design Master...]] [edit] Tools,Replication,Resolve Conflicts...Wiki-link: [[Menu Bar#Tools,Replication,Resolve Conflicts...|Ac_Menu,Resolve Conflicts...]] [edit] Tools,Startup...Wiki-link: [[Menu Bar#Tools,Startup...|Ac_Menu,Startup...]]
[edit] Tools,MacroWiki-link: [[Menu Bar#Tools,Macro|Ac_Menu,Macro]] [edit] Tools,Macro,Visual Basic EditorWiki-link: [[Menu Bar#Tools,Macro,Visual Basic Editor|Ac_Menu,Visual Basic Editor]]
[edit] Tools,Macro,Microsoft Script EditorWiki-link: [[Menu Bar#Tools,Macro,Microsoft Script Editor|Ac_Menu,Microsoft Script Editor]] [edit] Tools,Macro,Security...Wiki-link: [[Menu Bar#Tools,Macro,Security...|Ac_Menu,Security...]]
[edit] Tools,Macro,Run Macro...Wiki-link: [[Menu Bar#Tools,Macro,Run Macro...|Ac_Menu,Run Macro...]]
[edit] Tools,Macro,Convert Macros to Visual BasicWiki-link: [[Menu Bar#Tools,Macro,Convert Macros to Visual Basic|Ac_Menu,Convert Macros to Visual Basic]] [edit] Tools,Macro,Create Menu from MacroWiki-link: [[Menu Bar#Tools,Macro,Create Menu from Macro|Ac_Menu,Create Menu from Macro]] [edit] Tools,Macro,Create Toolbar from MacroWiki-link: [[Menu Bar#Tools,Macro,Create Toolbar from Macro|Ac_Menu,Create Toolbar from Macro]] [edit] Tools,Macro,Create Shortcut Menu from MacroWiki-link: [[Menu Bar#Tools,Macro,Create Shortcut Menu from Macro|Ac_Menu,Create Shortcut Menu from Macro]] [edit] Tools,Tools on the Web...Wiki-link: [[Menu Bar#Tools,Tools on the Web...|Ac_Menu,Tools on the Web...]] [edit] Tools,ActiveX Controls...Wiki-link: [[Menu Bar#Tools,ActiveX Controls...|Ac_Menu,ActiveX Controls...]] [edit] Tools,Add-InsWiki-link: [[Menu Bar#Tools,Add-Ins|Ac_Menu,Add-Ins]] [edit] Tools,Add-Ins,Add-In ManagerWiki-link: [[Menu Bar#Tools,Add-Ins,Add-In Manager|Ac_Menu,Add-In Manager]] [edit] Tools,AutoCorrect Options...Wiki-link: [[Menu Bar#Tools,AutoCorrect Options...|Ac_Menu,AutoCorrect Options...]] [edit] Tools,Customize...Wiki-link: [[Menu Bar#Tools,Customize...|Ac_Menu,Customize...]] [edit] Tools,Options...Wiki-link: [[Menu Bar#Tools,Options...|Ac_Menu,Options...]]
[edit] WindowWiki-link: [[Menu Bar#Window|Ac_Menu,Window]]
CODE Application.hWndAccessApp
[edit] Window,Tile HorizontallyWiki-link: [[Menu Bar#Window,Tile Horizontally|Ac_Menu,Tile Horizontally]] [edit] Window,Tile VerticallyWiki-link: [[Menu Bar#Window,Tile Vertically|Ac_Menu,Tile Vertically]] [edit] Window,CascadeWiki-link: [[Menu Bar#Window,Cascade|Ac_Menu,Cascade]] [edit] Window,Arrange IconsWiki-link: [[Menu Bar#Window,Arrange Icons|Ac_Menu,Arrange Icons]] [edit] Window,HideWiki-link: [[Menu Bar#Window,Hide|Ac_Menu,Hide]] [edit] Window,Unhide...Wiki-link: [[Menu Bar#Window,Unhide...|Ac_Menu,Unhide...]] [edit] HelpWiki-link: [[Menu Bar#Help|Ac_Menu,Help]]
[edit] Help,Microsoft Access HelpWiki-link: [[Menu Bar#Help,Microsoft Access Help|Ac_Menu,Microsoft Access Help]]
[edit] Help,Show the Office AssistantWiki-link: [[Menu Bar#Help,Show the Office Assistant|Ac_Menu,Show the Office Assistant]] [edit] Help,What`s This?Wiki-link: [[Menu Bar#Help,What`s This?|Ac_Menu,What`s This?]] [edit] Help,Office on the WebWiki-link: [[Menu Bar#Help,Office on the Web|Ac_Menu,Office on the Web]] [edit] Help,Activate Product...Wiki-link: [[Menu Bar#Help,Activate Product...|Ac_Menu,Activate Product...]] [edit] Help,Sample Databases...Wiki-link: [[Menu Bar#Help,Sample Databases...|Ac_Menu,Sample Databases...]] [edit] Help,Detect and Repair...Wiki-link: [[Menu Bar#Help,Detect and Repair...|Ac_Menu,Detect and Repair...]] [edit] Help,About Microsoft AccessWiki-link: [[Menu Bar#Help,About Microsoft Access|Ac_Menu,About Microsoft Access]] [edit] Bottom of Menu Bar
|
Menu Bar
| This page was last modified 15:30, 3 April 2012. This page has been accessed 18,944 times. Disclaimers |