Pos Cash Register Application With Ms Access As The Back-end
Required skills: MS Access, Programming, Visual Basic
Project Description
I am seeking a programmer to create a cash register POS application that uses MS Access as a back end. This will be a POS application, not a business management application. This application will NOT be used to run reports, print barcodes, purchasing, accounting, inventory management, review sales data, etc. All of those functions and many others will be performed in the MS Access database using forms, queries, reports, etc. This application will be a POS to conduct transactions and store data into the MS Access database. All applications, files, work including company name, logo, users, features, etc. must be completely flexible, configurable, and able to be modified easily by myself in the future. This application must support only one POS to start with, but should be designed to support additional POS terminals in the future. This application will be written in VBA, and should have a clear, user-friendly, attractive GUI with the look and feel similar to a real cash register.
The cash register POS application requirements are as follows:
• Support barcode scanner, cash drawer, receipt printer, credit card scanner, LCD touch screen
• Support customer display such as a light pole or LCD screen, and keyboard (although this will be a backup; the primary interface will be a touch-screen)
• Support the calculation of withholding tax such as VAT
• Support printing customer receipts from receipt printer. Printed items included should be able to be configured.
• Support printing of official business VAT receipts on A4. Printed items included should be able to be configured.
• Support lookup all product data such as barcode numbers, descriptions, prices, etc. from an MS Access 2010 database stored on a LAN
• Support storing all transaction data via LAN into an MS Access 2010 database
• Support login of different user levels; staff, manager, owner with multiple user names for each user level
• Support data recovery and auto-restore-on-resume for emergency situation such as loss of power
• Support product returns, refunds, discounts, canceled orders, open orders with partial payment, coupon codes
• Support payments such as cash, credit card, store credit, check, Paypal, bank transfer, gift certificate, etc.
• Support list of ongoing open orders
• Support reconcile cash drawer and reset daily totals to zero
• Support multiple product quantity, subtotal, cash tendered amount, cash change amount, and No Sale function
• Support data input and output via LAN from predefined parameters for future expansion of features
• Support date, time, company logo, transaction data, etc. on receipts
• Support loan at the beginning of the shift
• Support configuration file backup
• Support employee time and attendance
• Support assigning new transaction number and old transaction modify/recall/review/reprint
• Support new customer data and assign number
• Support shipping cost and shipping cost calculation (formula to calculate shipping cost based upon MS Access Database data)
• Support POS identification number
• Support new employee training mode
I prefer to work closely with only one person that can help me with the progression of the complete business database; this means this project and subsequent projects as well. My business is currently operating with manual, separate methods, i.e. Excel for inventory, files and folders for documents, Casio cash register, handwritten customer orders, etc. Eventually the goal is to transform all aspects of the business into one MS Access database. This must be done slowly, piece-by-piece. The process will necessarily require close and constant communication with questions from both sides. The more questions, the better. I can afford to be a bit flexible with time. All files and applications, VBA code, etc. must be well documented, commented, and explained in accompanying .txt files if necessary so I can understand everything clearly and modify it as needed at a later time.
Hardware
• Computer - Acer Aspire 4552 (laptop) with Windows XP Professional
• Barcode Scanner - Honeywell / Metrologic MS9590 Voyager GS, USB, Laser
• Receipt Printer - Epson TM-T88V USB, Thermal
• Display - 17” Benq G702AD LCD Touch-Screen Monitor
• Cash Drawer - Posiflex CR4106, USB
• Customer Display - Pole LED display, USB, Serial
• Keyboard - USB
• Credit Card Scanner - USB, Serial
• Mouse - USB
Note: It will be the responsibility of the programmer to obtain any necessary driver, SDK, etc. If it becomes impossible for the programmer to obtain a needed SDK, driver, etc. it may become necessary to substitute a piece of hardware.
Thank you.
Jeff Beach
I am seeking a programmer to create a cash register POS application that uses MS Access as a back end. This will be a POS application, not a business management application. This application will NOT be used to run reports, print barcodes, purchasing, accounting, inventory management, review sales data, etc. All of those functions and many others will be performed in the MS Access database using forms, queries, reports, etc. This application will be a POS to conduct transactions and store data into the MS Access database. All applications, files, work including company name, logo, users, features, etc. must be completely flexible, configurable, and able to be modified easily by myself in the future. This application must support only one POS to start with, but should be designed to support additional POS terminals in the future. This application will be written in VBA, and should have a clear, user-friendly, attractive GUI with the look and feel similar to a real cash register.
The cash register POS application requirements are as follows:
• Support barcode scanner, cash drawer, receipt printer, credit card scanner, LCD touch screen
• Support customer display such as a light pole or LCD screen, and keyboard (although this will be a backup; the primary interface will be a touch-screen)
• Support the calculation of withholding tax such as VAT
• Support printing customer receipts from receipt printer. Printed items included should be able to be configured.
• Support printing of official business VAT receipts on A4. Printed items included should be able to be configured.
• Support lookup all product data such as barcode numbers, descriptions, prices, etc. from an MS Access 2010 database stored on a LAN
• Support storing all transaction data via LAN into an MS Access 2010 database
• Support login of different user levels; staff, manager, owner with multiple user names for each user level
• Support data recovery and auto-restore-on-resume for emergency situation such as loss of power
• Support product returns, refunds, discounts, canceled orders, open orders with partial payment, coupon codes
• Support payments such as cash, credit card, store credit, check, Paypal, bank transfer, gift certificate, etc.
• Support list of ongoing open orders
• Support reconcile cash drawer and reset daily totals to zero
• Support multiple product quantity, subtotal, cash tendered amount, cash change amount, and No Sale function
• Support data input and output via LAN from predefined parameters for future expansion of features
• Support date, time, company logo, transaction data, etc. on receipts
• Support loan at the beginning of the shift
• Support configuration file backup
• Support employee time and attendance
• Support assigning new transaction number and old transaction modify/recall/review/reprint
• Support new customer data and assign number
• Support shipping cost and shipping cost calculation (formula to calculate shipping cost based upon MS Access Database data)
• Support POS identification number
• Support new employee training mode
I prefer to work closely with only one person that can help me with the progression of the complete business database; this means this project and subsequent projects as well. My business is currently operating with manual, separate methods, i.e. Excel for inventory, files and folders for documents, Casio cash register, handwritten customer orders, etc. Eventually the goal is to transform all aspects of the business into one MS Access database. This must be done slowly, piece-by-piece. The process will necessarily require close and constant communication with questions from both sides. The more questions, the better. I can afford to be a bit flexible with time. All files and applications, VBA code, etc. must be well documented, commented, and explained in accompanying .txt files if necessary so I can understand everything clearly and modify it as needed at a later time.
Hardware
• Computer - Acer Aspire 4552 (laptop) with Windows XP Professional
• Barcode Scanner - Honeywell / Metrologic MS9590 Voyager GS, USB, Laser
• Receipt Printer - Epson TM-T88V USB, Thermal
• Display - 17” Benq G702AD LCD Touch-Screen Monitor
• Cash Drawer - Posiflex CR4106, USB
• Customer Display - Pole LED display, USB, Serial
• Keyboard - USB
• Credit Card Scanner - USB, Serial
• Mouse - USB
Note: It will be the responsibility of the programmer to obtain any necessary driver, SDK, etc. If it becomes impossible for the programmer to obtain a needed SDK, driver, etc. it may become necessary to substitute a piece of hardware.
Thank you.
Jeff Beach
Posted In:MS AccessProgrammingVisual Basic |
Related projects:
POS Cash Register Application with MS Access as the Back-end
require close and constant communication with questions from both sides. The more questions, the better. I can afford to be a bit flexible with time. All files and applications, VBA code, etc. must be well documented, commented, and explained in accompanying .txt files if necessary so I can understand everything clearly and modify it as needed at a later time.
Thank you.
Jeff Beach
Thank you.
Jeff Beach
VB Form designer with MS Access
as a backend data base
5 Form will be there
1. Customer Registration
2. Worker Registration
3. Voucher Entry
4. Money Receipt
and some more, like installment pattern, next due dates etc.
I will send the complete document who will won the bid.
Budget is low. It's a small application only. So bid it accordingly.
5 Form will be there
1. Customer Registration
2. Worker Registration
3. Voucher Entry
4. Money Receipt
and some more, like installment pattern, next due dates etc.
I will send the complete document who will won the bid.
Budget is low. It's a small application only. So bid it accordingly.
VB 2008 app modification with MS Access/xml/export pdf-word
r>Can provide screenshot or even files only to the interesting offers to the freelancers just to have an idea.
This project is urgent and i want at least to show the task1, task2, task3 and task6 by Wednesday (11 January) or at least Thursday morning (12 January) so you can have time to work on save/load (task4) and export (task5) for these later. Will not wait for extra bidding if i see a nice offer and will accept right away.
This project is urgent and i want at least to show the task1, task2, task3 and task6 by Wednesday (11 January) or at least Thursday morning (12 January) so you can have time to work on save/load (task4) and export (task5) for these later. Will not wait for extra bidding if i see a nice offer and will accept right away.
Web form with MS Access DB by gregbul
want this completed in minimal time. I also will want to expand this system in the future so it will probably result in more work very soon.
If you bid on this project, please attach an example of similar work (asp with MS access backend) that you have completed in the past. Generic bids will be ignored.
Additional files submitted:
RegistrationsSystemSpec.pdf
If you bid on this project, please attach an example of similar work (asp with MS access backend) that you have completed in the past. Generic bids will be ignored.
Additional files submitted:
RegistrationsSystemSpec.pdf
Batch Update In Ms Access 2010
:
I have two MS Access 2010 tables in the same database. There is a UPC code in both table A and table B. Table A contains an ingredients column with data in it. I need to access the data in Table A and then find the same UPC code in table B and update the Ingredients field in it. Table A contains several thousand records, so this query needs to be able to loop.
I need to know how to run this update inside MS Access (using the tools in it)
pays US $ 20
I have two MS Access 2010 tables in the same database. There is a UPC code in both table A and table B. Table A contains an ingredients column with data in it. I need to access the data in Table A and then find the same UPC code in table B and update the Ingredients field in it. Table A contains several thousand records, so this query needs to be able to loop.
I need to know how to run this update inside MS Access (using the tools in it)
pays US $ 20
Ms Access System
Build MS Access Database, 3 Data entry forms and 3 reports.
We want the reports to be web-based reports accessing the MS Access Database.
The Access Database will have 3 tables to start with. The data entry forms must keep the integrity in those three tables.
Please present your bid, and any example of user interface for data entry and reports.
We want the reports to be web-based reports accessing the MS Access Database.
The Access Database will have 3 tables to start with. The data entry forms must keep the integrity in those three tables.
Please present your bid, and any example of user interface for data entry and reports.
Create MS Access Form and Queries that Produce HTML Page
alt_project_web_dictionary_A2.doc
alt_project_web_dictionary_form_HTML_page_layout.jpg
alt_project_web_dictionary_form_sketch.jpg
alt_project_web_dictionary_form_HTML_page_layout.jpg
alt_project_web_dictionary_form_sketch.jpg
Paradox Db To Ms Access Db
d to MS Access DB.
The Paradox DB has 6 DB's that store content and 6 forms have co-relational tables etc within them.
We seek to retain all features [and add 2 new tables] from within this Paradox DB and migrate to MS Access.....so we seek an expert who can help us build our existing DB into Access.
Please advise total cost for project, past similar works, your familiarity with Paradox and Access.
Many thanks for your help.
Midi
The Paradox DB has 6 DB's that store content and 6 forms have co-relational tables etc within them.
We seek to retain all features [and add 2 new tables] from within this Paradox DB and migrate to MS Access.....so we seek an expert who can help us build our existing DB into Access.
Please advise total cost for project, past similar works, your familiarity with Paradox and Access.
Many thanks for your help.
Midi
Help With Ms Access Set Up
load my raw files in MS Access (2007) and create queries that will combine A and B.
I need to create 4 different queries and I currently have the formulas in Excel only.
So, the winner of this project will have to guide me how to set-up the database in Access 2007, write the queries and show me how to modify them when/where needed.
How to set up everything, to have Access update the existing database based on the updated A and B files?
Thank you.
I need to create 4 different queries and I currently have the formulas in Excel only.
So, the winner of this project will have to guide me how to set-up the database in Access 2007, write the queries and show me how to modify them when/where needed.
How to set up everything, to have Access update the existing database based on the updated A and B files?
Thank you.
Need Mini ASP application
=========================================
Important points to note:
Though it has more pages ideally it has 2 only 2 pages. Other pages would be copy paste of the code.
This application is for personal use and hence budget is 30$ -50$ MAX. Low bids will be given preference.
The timeline would be 7 days.
No payment will be released unless entire delivery is made, only escrow can be given upon request.
Important points to note:
Though it has more pages ideally it has 2 only 2 pages. Other pages would be copy paste of the code.
This application is for personal use and hence budget is 30$ -50$ MAX. Low bids will be given preference.
The timeline would be 7 days.
No payment will be released unless entire delivery is made, only escrow can be given upon request.
Ms Access Executable Scan
has to:
- scan an hardcoded (fixed) directory and its subdirs looking for a certain file extension (let's say .xxx)
- all .xxx are simple MS Access files
- the program has to scan inside each .xxx file looking for a certain table (table yyy)
- when table yyy is found, the program has to fetch all records inside this table
- the program will send via email these records to an hardcoded email address, smtp server, auth data.
- program ends
- scan an hardcoded (fixed) directory and its subdirs looking for a certain file extension (let's say .xxx)
- all .xxx are simple MS Access files
- the program has to scan inside each .xxx file looking for a certain table (table yyy)
- when table yyy is found, the program has to fetch all records inside this table
- the program will send via email these records to an hardcoded email address, smtp server, auth data.
- program ends
Ms Access Report Until Sunday
I'm looking for someone to write a MS-Access Report (MS-Access 2002). The report is structured in 3 sections and is based on 3 accordant tables. The report has to be finished until sunday
The report is described in the attached PDF
The report is described in the attached PDF
Dsn Connection For Sql Server
Hello,
I have created an application using asp and ms access as the backend and I have now hosted it to windows server with ms sql server. I have finished creating the database and tables and have also created a dsn for sql server and have included it in all my asp files. But I am getting "server 500" error.
can anyone fix this ?
I have created an application using asp and ms access as the backend and I have now hosted it to windows server with ms sql server. I have finished creating the database and tables and have also created a dsn for sql server and have included it in all my asp files. But I am getting "server 500" error.
can anyone fix this ?
Ftp File From Ms Access
e able to FTP a file by clicking a button on a form within MS Access 2003. The file will always be C:OneSchoolStreetCalendar.txt
The upload directory will be /calendar_uploads/84/calendar.txt where 84 is the subfolder and calendar.txt is the upload file.
You must provide a working MDE file before receiving payment.
I would need a "File upload is completed." message when the process finishes.
An example of the file to be uploaded is attached.
The upload directory will be /calendar_uploads/84/calendar.txt where 84 is the subfolder and calendar.txt is the upload file.
You must provide a working MDE file before receiving payment.
I would need a "File upload is completed." message when the process finishes.
An example of the file to be uploaded is attached.
clone - EquineMax by drcadmin
on. Full features of the software are available here - www.equinemax.com/equine-software-overview.asp
Please bid only after downloading the trial software to get a feel of what we need.
Additional information submitted: 07/16/2006 at 12:27 EDT:
We are looking at preferably VB.NET as the target front-end with MS-SQL as the backend. Multi-user support is required.
Please bid only after downloading the trial software to get a feel of what we need.
Additional information submitted: 07/16/2006 at 12:27 EDT:
We are looking at preferably VB.NET as the target front-end with MS-SQL as the backend. Multi-user support is required.
Joomla Website with data gathering for MS access database Featured Projects, i
nd by user) into an MS Access database. The information includes name, location, department, photo etc. The database will be used to generate namecards, event schedules etc
I can provide more infomration and am also open to suggestions if you have other ideas of how to complete this task.
I can provide more infomration and am also open to suggestions if you have other ideas of how to complete this task.
Visual Basic Programming Access Database
ries that allow for detailed analysis. These queries are already designed and functioning.
If possible I would like to be able to give them menu picks that will allow them to provide variables to a group or set queries that will let them select or filter data to their specs. e.g. Select all workshops that where run at a specific campus or all workshops of a certain type or by semester, quarter etc. All of these categories are resident fields in the tables.
Thanks.
If possible I would like to be able to give them menu picks that will allow them to provide variables to a group or set queries that will let them select or filter data to their specs. e.g. Select all workshops that where run at a specific campus or all workshops of a certain type or by semester, quarter etc. All of these categories are resident fields in the tables.
Thanks.
Need Ms Access Programmer ( Vba Coding )
Hi,
I need MS Access - VBA coding programmer with good understanding of manufacturing process.
As part of immediate assignment, i need programmer who can developing program for scheduling machines and resources based on working calendar.
Prefer fixed pricing model.
I need MS Access - VBA coding programmer with good understanding of manufacturing process.
As part of immediate assignment, i need programmer who can developing program for scheduling machines and resources based on working calendar.
Prefer fixed pricing model.
Basic HTML/ASP based report from MS Access DB
sh.
Please let me know if you have any questions or if you need any more information. I will take a backup of the existing database (about 20 MB compressed) and sterilize some of the data. That will be provided for you to use as your dataset. I will also provide what the schedules look like in the 3rdparty software. We can also do a remote demo of the 3rd party application if necessary.
Please let me know if you have any questions or if you need any more information. I will take a backup of the existing database (about 20 MB compressed) and sterilize some of the data. That will be provided for you to use as your dataset. I will also provide what the schedules look like in the 3rdparty software. We can also do a remote demo of the 3rd party application if necessary.
Embed An Ms Access File To Joomla
ontains a picture to be displayed when record name chosen.
- Be able to add, update, modify records in master database.
- Be able to use Unicode fonts (such as Arial, Tomaha, etc...)
- Compatible with Joomla 1.5.20
If Ms Access is NOT a good idea for this task, a suitable program would be OK.
Please tell me what you are planning to handle this task in the first contact, and explain how it would work.
Thanks
Ben
- Be able to add, update, modify records in master database.
- Be able to use Unicode fonts (such as Arial, Tomaha, etc...)
- Compatible with Joomla 1.5.20
If Ms Access is NOT a good idea for this task, a suitable program would be OK.
Please tell me what you are planning to handle this task in the first contact, and explain how it would work.
Thanks
Ben
