![]() VBA code to document hyperlinks in the Active Workbook. Cool way to change other things too - perhaps a procedure you want to run depending on what field it is and what else was chosen (that you added in)? Change what you like to suit what you need leave attributions in the code, and keep it open.ĭocument Hyperlinks from Pasted Text with Excel There is also code to create an Excel Workbook with the results and format it.įorm to view Data Dictionary for tables, and modify Display Control - for example,Ĭombobox/listbox to textbox, or integer to checkbox. ![]() In addition to the SQL statement to see all your equations and fields with aliases, Better yet, get theĭo you have calculated fields in queries of your database? You can also create a query that lists the main object names and types in your database. You can also document the source for FORMS and REPORTS. Launcher and code to DOCUMENT the SQL stored for each QUERY. and moreįor VBA in Access, Excel, Word, & PowerPointĭocument Query SQL, Form and Report RecordSource The Table Summary (list of tables and how many records each has), and theĭeep Analysis (data dictionary with fieldname, data type, size, and statistics about the values in each field).įree tool to Document VBA in Modules, Procedures, Lines of Code. If its not on the more than 50 built-in reports - or you want to use the data somewhere else. So you can make queries to get exactly what you need to know, Ramp up learning VBA and writing useful programs with this handy guide.įree tool to document information about structure and objects in Microsoft Access. To make your own CSV file for a different CPK, use CpkFilelistDumper.exe (also found in the thread).Add-ins Analyzer Books Calendars Charts & Graphs Clock Contacts Dates Development Excel Automation Files Mainform + Subforms QAT Shortcut Keys Reference Data Video Tutorials Donate Categoryįavorite Shortcut Keys for Microsoft Accessįree 100-page book on getting started becoming a master power-user and developer with Microsoft Access. Use the commandline tool provided in the program's folder (cpkmakec.exe) to make a new CPK using the CSV file from the thread.Ĭpkmakec.exe data.csv data.cpk -dir=UNPACKEDFILESDIRECTORY -align=2048 -mode=FILENAME -view While the Mod Compendium is an easier to use alternative, CRI Packed File Maker creates CPK files from an extracted directory and can be used to view file information such as data alignment, number of files, and compression modes. ![]() It will automatically extract the contents to the directory of your choosing. Run quickbms.exe, select cpk.bms, and then select your CPK file. You can download it from here.Īluigi's file extractor QuickBMS has scripts in. You can download it here and read this guide ( or this one) on how to use it.ĬriPakGUI can open and extract most CPK files easily with its very user friendly interface. TGE's Mod Compendium can automatically merge multiple mods into a new CPK file. Usually, most game data except for executables is stored in compressed CPK archives. It was developed by CRI Middleware and is the successor of CVM. Persona 3 Portable, Persona 4 Golden, Persona Q, Persona 4 Dancing All Night, Persona 5, Persona 3 Dancing Moon Night, Persona 5 Dancing Star Night, Persona Q2ĬPK is an archive format used in the Persona series from Persona 3 Portable onwards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |