Logo Freelancer Bagaimana ia berfungsiLayari Pekerjaan
Log Masuk Daftar
Siarkan Projek
MENJELAJAH
.NET
Excel
Microsoft Access
Transcription
VB.NET
Gambar muka depan profil
Anda kini mengikuti
Ralat mengikuti pengguna.
Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.
Anda telah mengikuti pengguna ini.
Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.
Berjaya menyahikut
Ralat tidak mengikuti pengguna.
Anda berjaya mengesyorkan
Ralat mengesyorkan pengguna.
Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.
E-mel berjaya disahkan.
Avatar Pengguna
$20 USD / jam
Bendera HONG KONG
mui wo, lantau, hong kong
$20 USD / jam
Sekarang jam 9:04 PTG di sini
Menyertai Mac 7, 2016
1 Cadangan

Timothy H.

@TimHudspith

 5.0 (15 ulasan)
5.0
5.0
94%
94%
$20 USD / jam
Bendera HONG KONG
mui wo, lantau, hong kong
$20 USD / jam
100%
Pekerjaan Disiapkan
100%
Mengikut Bajet
100%
Tepat Pada Masa
19%
Kadar Upah Semula

SQL, VB, VBA, Access, Excel, ASP.Net Programmer

I am an experienced .Net, SQL Server, Access/Excel programmer and ASP.NET web developer. For ten years I worked as an accountant, financial analyst and programmer in investment banks in London, Singapore and Hong Kong. I am thorough in everything I do and take pains to deliver work of high quality. FYI, I am a British national.
Freelancer Excel Experts Hong Kong
Lihat semua Excel Experts dalam Hong Kong

Hubungi Timothy H. tentang pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Portfolio

3267717
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
3218831
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
2974916
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
2944332
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
2851117
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
2852096
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator
3267717
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
Used by a commercial property agent in Australia to match investors with opportunities in the commercial property market. This Access-based application has dedicated tabs to store property, investor and transaction records, with a navigable list show in the bottom half of the page, and data entry in the top half. Its most useful feature is its ability to match properties with suitable investors based on the investor's investment criteria. Each investor has a required rate of return, maximum and minimum price bracket, and a set of preferred property types and locations. As you tab between property records in the Properties tab, a dynamic query runs in the background to present a list of potential investors underneath - and vice versa in the Investors tab. Clicking column headers sorts the data, and making combo selections filters the data (wildcard searches also). The visual layout of each tab can be toggled up to five times, lengthening, shortening or hiding sections as required.
Commercial Property Investment Tool - Access & Excel
3218831
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
This system is a stock-keeping and rental tracking system for a Norwegian highways construction company, to be used in a multi-user setting. The Equipment page holds records of all items of equipment in-stock and on-loan to construction workers, recording parameters such as ID, purchase cost and date, replacement cost, rental and return date. Items are categorised according to a 5-tier hierarchy, presented to the user in a series of parent-child lists in the top half of the screen, with all related stock items shown underneath. A history of rentals is displayed next to the selected item. Different levels of the hierarchy can be printed off in PDF format. Staff records have their own page, with equipment rentals per employee shown at a summary and item level. The user can send employees reminder emails listing items due for return at the click of a button. Maintenance of static data and user accounts is also provided for, and controls and constraints abound to ensure data integrity.
Equipment Rental System, Access + Excel VBA
2974916
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
This is a VB.Net DLL integrated with a SQL Server database, used by a professional wedding photography company to generate customer invoices. Once the DLL has been loaded into SQL Server, the database starts the process by calling the class with four parameters: @invoiceID, @printerName, @invoiceFormat, @applicationPath. The VB class in turn runs four stored procedures in SQL Server to obtain the various pieces of data required to populate the invoice (an Excel template). The data is inserted into named ranges and formatting applied as required. The Excel file is transformed into a PDF file, which is saved to the server. It can be sent directly to a printer if the relevant parameter was supplied in the calling procedure. The user has the choice of two invoice formats, plain and ''fancy', shown in the screenshots on the left. They illustrate the versatility and power of Excel in combining both graphic design and database reporting functions in a single task.
VB.Net - SQL Server - Excel : InvoiceGenerator DLL
2944332
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
An MS Access-based system (s split-database configuration) for a Freelancer customer. This system manages student and teacher accounts, and creates teaching rosters and timetables for a private Mathematics school. It tracks student class attendance, one-off item expenditure (registration fees, textbooks, merchandise), calculates a running balance and flags those students with low balances. Student account statements can be printed to Excel PDF and emailed to any number of students in a single action. Class attendance and subject taught are recorded in the roster page, automatically calculating teacher wages payable at the month-end and updating student accounts. Class timetables and student attendance are printed to Excel PDF for reference by reception and the teacher staff room. This system allows the administrator to create any number of additional users, each with their own username and password, to access the system and control which pages they have access to.
MS Access and Excel : Class Management System
2851117
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
A combined MS Access-Excel application for a Freelancer client. This application is used by a freight consultancy to prepare a quote for corporate customers looking to reduce their freight costs. The consultant inputs the parameters of all the company's deliveries, imports and exports into an MS Access database application, and from that produces an Excel report that presents the data at line-by-line and summary levels, with the main KPI's graphed. Using this information the consultant obtains more competitive quotes for each route, inputs them into the application and produces a final comparison report that is used as a basis for discussion with, and decision-making by, the client.
MS Access and Excel : Freight Profiler
2852096
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator
A project for a Freelancer client. This VB.Net DLL is integrated with the purchase order system of a mail order company to produce barcode labels for warehouse dispatch. The DLL receives name, address and barcode parameters from the calling procedure and passes them to an Excel template to produce the final label in PDF format.
VB.Net DLL with MS Excel : Barcode Label Generator

Ulasan

Perubahan disimpan
Menunjukkan 1 - 5 daripada 15 ulasan
 Tapis ulasan mengikut:
5.0
€30.00 EUR
Troubleshoot my MS Access program
Very professional and passionate about the project. Highly recommended.
Microsoft Access
Database Programming
Avatar Pengguna
Bendera Mohammad A.
@aminjo71
•
7 tahun yang lalu
5.0
$700.00 USD
Project for TimHudspith -- 2
Great - very good freelancer
.NET
Excel
Transcription
Microsoft Access
+1 lagi
M
Bendera Mark H.
@markymark4523
•
7 tahun yang lalu
5.0
$110.00 USD
Project for TimHudspith -- 2
Great work as always - on time and perfect standard
.NET
Excel
Transcription
Microsoft Access
+1 lagi
J
Bendera John A.
@john409
•
7 tahun yang lalu
5.0
$40.00 USD
Excel Timesheet and Project KPI Dashboard
Fantastic guy to work with! :-)
Excel
A
Bendera Alex V.
@alex824
•
7 tahun yang lalu
5.0
¥61,750 JPY
Develop recruiting commission software or click and use spreadsheet
Tim is very diligent and responds quickly to enquiries and requests. Very nice person to work with and really, really knows what he is doing. I will recommend Tim to anyone who needs quality work from a very honest person.
Data Entry
Excel
Software Development
J
Bendera Joseph P.
@joepeters47
•
7 tahun yang lalu

Hubungi Timothy H. tentang pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Pengesahan

Pekerja Bebas Pilihan
Identiti Disahkan
Pembayaran Disahkan
Telefon Disahkan
E-mel Disahkan
Facebook Dihubungkan

Pensijilan

us_eng_1.png US English 1 98%

Kemahiran Teratas

Excel 8
.NET 6
Transcription 6
Microsoft Access 6
VB.NET 6

Layari Pekerja Bebas Serupa

Excel Experts in Hong Kong
Excel Experts
.NET Developers
Transcribers

Layari Pameran Serupa

Excel
.NET
Transcription
Microsoft Access
Pengguna Sebelumnya Pengguna Seterusnya
Jemputan berjaya dihantar!
Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Logo Freelancer Malaysia / Bahasa Malaysia Bantuan & Sokongan Pekerja bebas Kategori ProjekPeraduanPekerja BebasEnterprise KeahlianProgram Pekerja Bebas PilihanPengurusan ProjekPekerjaan TempatanPhoto AnywherePameranAPI untuk PembangunDisahkanAplikasi Desktop TentangTentang kamiBagaimana ia BerfungsiKeselamatanPelaburPeta LamanKisahDalam BeritaPasukanAnugerahSiaran AkhbarKerjaya Terma Dasar PrivasiTerma dan SyaratDasar HakciptaTatakelakuanYuran dan Caj Rakan KongsiEscrow.comLoadshiftWarrior Forum AplikasiLogo Apple App StoreLogo Mainan Google
Salin ke papan keratan gagal, sila cuba lagi selepas melaraskan kebenaran anda.
Disalin ke papan keratan.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.