Lookup is a simple yet powerful client for searching Microsoft Access databases. Lookup will open, load and search faster than is possible within Microsoft Access. Set any Access databases just set the database options to shared (under Tools>Security in Access) and multiple users can search simultaneously.
The key to Lookup is it's simplicity. The simple, intuitive interface is designed to put the things you need where you can find them the fastest, and the less menus and buttons the easier it is to learn and use.
Behind this simple interface however are a large number of features that work to make it easier for you from automatically loading the right database when you open the program, to alerting you to opening and closing times, to automatically sizing the grid so that your data is displayed clearly.
Even our database comes setup for easy importing of data from the database and includes Australian postcodes.
Lookup comes with an Access 2000 database which includes forms to enable easy import/export of MYOB export data, SQL servers, spreadsheets or any other information. This means Items and Customers can be searched in Lookup using current or recent data from your existing systems.
This enables fast database searching on a large number of machines simultaneously without slowing down the network, as too many Access users can do with a large data file, for example. Multiple windows of Lookup can be open simultaneously on any machine.
Each version of Lookup is built to suit changes recommended by clients or staff. Modifications can be made to suit your requirements and tailored to include company specific branding or features.
Lookup Launcher and Lookup Browser are my two new additions to the Suite and were designed to complement Lookup as useful small business tools. You will never need to use the start menu again!!
The Browser and Launcher programs follow the simplistic ethos being tiny programs that run fast and have only the features that are necessary.
Lookup Launcher provides a system tray menu that brings the three programs together. Lookup Launcher can check for updates for all Lookup programs. The system tray menu icon (Lookup Launcher) is an easy way to quickly load Lookup.
Here are some key features of "Chris Dunn Lookup":
· Search Access Tables and Queries fast (shows number of results and time taken)
· Uses minimal network bandwidth and only when required by caching current table.
· Flexible search functionality including a filter to narrow down the results of a large search.
· Concise menu system with less menus and more features.
· Analog clock with date, time, day of week and monthly calendar.
· Search logging for analysis or system monitoring (includes results and time taken).
· Auto fit grid spacing will resize the grid to fit your data making it easy to view all fields and saves resizing columns.
· Auto-load function will launch common database automatically for day-to-day use.
· Adjustable grid font size.
· Open/Closed indicator which can be customised to your opening hours (replaces version number on search bar)
· Customisable program menu makes it easy to create shortcuts to your other commonly used applications.
· Automatically generated shortcut keyboard strip (requires Excel) which will line up with the function keys on your keyboard.
· Export results to Excel to generate reports.
· Automatic Last 10 Searches menu enables you to re-load a previous search, much like an undo or back function.
· Command line switches for network or system administrators to restrict access to certain features.
· Stores history of last 2 opened files.
· Can be run off read-only media
· Small enough to fit on a floppy disk
· Web Check for Updates for all Lookup applications
· Dragging and dropping a database on the grid will open a database.
· Windows 'Open with..' interaction for access databases
· SQL Mode allowing partial sql strings for more complicated queries.
· Windows username will now appear below clock.
· Results count and search time in titlebar for performance monitoring.
· Saved Searches menu for saving favourite searches from multiple databases and retrieving them easily.
· Powerful Value box allows pull down retrieval of values, manual value entry or partial entry which will automatically scroll the pull down list to appropriate values which can be disabled for performance gain.
· Tip of the Day full of useful tips to make the most of the many extra features of Lookup not often used to their potential.
· Clear button to reset multiple filter searches to primary search (not shown)
· Debug feature to view raw search SQL
· Table/Query selector based on options
· Terminal Services feature allowing individual users of the same computer (e.g. home computer or terminal server) can have different user settings. Some new command line functions and a terminal services command line feature enable security restrictions to be placed on users.
· Value list maximum to stop the values list populating (if enabled) more than a set number of results to improve performance.
· Read only data file option to ignore changes.
Requirements:
· Microsoft Office 97 or later
· MDAC 2.5 (installed with Office 2000 or later)
Limitations:
· 10 searches per session
The key to Lookup is it's simplicity. The simple, intuitive interface is designed to put the things you need where you can find them the fastest, and the less menus and buttons the easier it is to learn and use.
Behind this simple interface however are a large number of features that work to make it easier for you from automatically loading the right database when you open the program, to alerting you to opening and closing times, to automatically sizing the grid so that your data is displayed clearly.
Even our database comes setup for easy importing of data from the database and includes Australian postcodes.
Lookup comes with an Access 2000 database which includes forms to enable easy import/export of MYOB export data, SQL servers, spreadsheets or any other information. This means Items and Customers can be searched in Lookup using current or recent data from your existing systems.
This enables fast database searching on a large number of machines simultaneously without slowing down the network, as too many Access users can do with a large data file, for example. Multiple windows of Lookup can be open simultaneously on any machine.
Each version of Lookup is built to suit changes recommended by clients or staff. Modifications can be made to suit your requirements and tailored to include company specific branding or features.
Lookup Launcher and Lookup Browser are my two new additions to the Suite and were designed to complement Lookup as useful small business tools. You will never need to use the start menu again!!
The Browser and Launcher programs follow the simplistic ethos being tiny programs that run fast and have only the features that are necessary.
Lookup Launcher provides a system tray menu that brings the three programs together. Lookup Launcher can check for updates for all Lookup programs. The system tray menu icon (Lookup Launcher) is an easy way to quickly load Lookup.
Here are some key features of "Chris Dunn Lookup":
· Search Access Tables and Queries fast (shows number of results and time taken)
· Uses minimal network bandwidth and only when required by caching current table.
· Flexible search functionality including a filter to narrow down the results of a large search.
· Concise menu system with less menus and more features.
· Analog clock with date, time, day of week and monthly calendar.
· Search logging for analysis or system monitoring (includes results and time taken).
· Auto fit grid spacing will resize the grid to fit your data making it easy to view all fields and saves resizing columns.
· Auto-load function will launch common database automatically for day-to-day use.
· Adjustable grid font size.
· Open/Closed indicator which can be customised to your opening hours (replaces version number on search bar)
· Customisable program menu makes it easy to create shortcuts to your other commonly used applications.
· Automatically generated shortcut keyboard strip (requires Excel) which will line up with the function keys on your keyboard.
· Export results to Excel to generate reports.
· Automatic Last 10 Searches menu enables you to re-load a previous search, much like an undo or back function.
· Command line switches for network or system administrators to restrict access to certain features.
· Stores history of last 2 opened files.
· Can be run off read-only media
· Small enough to fit on a floppy disk
· Web Check for Updates for all Lookup applications
· Dragging and dropping a database on the grid will open a database.
· Windows 'Open with..' interaction for access databases
· SQL Mode allowing partial sql strings for more complicated queries.
· Windows username will now appear below clock.
· Results count and search time in titlebar for performance monitoring.
· Saved Searches menu for saving favourite searches from multiple databases and retrieving them easily.
· Powerful Value box allows pull down retrieval of values, manual value entry or partial entry which will automatically scroll the pull down list to appropriate values which can be disabled for performance gain.
· Tip of the Day full of useful tips to make the most of the many extra features of Lookup not often used to their potential.
· Clear button to reset multiple filter searches to primary search (not shown)
· Debug feature to view raw search SQL
· Table/Query selector based on options
· Terminal Services feature allowing individual users of the same computer (e.g. home computer or terminal server) can have different user settings. Some new command line functions and a terminal services command line feature enable security restrictions to be placed on users.
· Value list maximum to stop the values list populating (if enabled) more than a set number of results to improve performance.
· Read only data file option to ignore changes.
Requirements:
· Microsoft Office 97 or later
· MDAC 2.5 (installed with Office 2000 or later)
Limitations:
· 10 searches per session
What's New in This Release: [ read full changelog ]
· Better SQL search capabilities
· Compatibility with newer access databases *.accdb (2007/2010)
· Faster, simpler, more powerful and more flexible search criteria for simple searching
· Improved saved searches and last 10 searches functionality
· New design, no analog clock or opening hours, more search results
· More configuration on grid colors and performance options.
· Improved ability to add files or programs to the program list and automatically open them in the default program type in windows
· Updated menus and Access options
· Better configuration file, easier for administrators to modify, better management for performance and application development. Plenty of new options. Remembers window location and size.
· A new style help file.
· A new installer which manages upgrades without affecting your settings.
· Better SQL search capabilities
· Compatibility with newer access databases *.accdb (2007/2010)
· Faster, simpler, more powerful and more flexible search criteria for simple searching
· Improved saved searches and last 10 searches functionality
· New design, no analog clock or opening hours, more search results
· More configuration on grid colors and performance options.
· Improved ability to add files or programs to the program list and automatically open them in the default program type in windows
· Updated menus and Access options
· Better configuration file, easier for administrators to modify, better management for performance and application development. Plenty of new options. Remembers window location and size.
· A new style help file.
· A new installer which manages upgrades without affecting your settings.
0 comments:
Post a Comment