I WANT TO CREATE A SMALL DATABASE FOR WHICH WE HAVE THE DATA IN EXCEL. DATA WE HAVE IS
-LOCATION (IN WAREHOUSE) NUMBERED
-PRODUCT NAME
-QUANTITY
-CATEGORY
WE NEED TO BE ABLE TO IMPORT DATA FROM EXCEL. THE VISUAL BASIC PROGRAM SHOULD BE ABLE TO:
1. FIND THE LOCATION AND QUANTITY OF THE PRODUCTS WE LOOK FOR (MULTIPLE PRODUCTS AT THE SAME TIME). THE SAME PRODUCT MIGHT BE STORED AT MORE THAN ONE LOCATIONS
2. PRINT A REPORT FOR THE ABOVE
MS Access expert here. We can build the program in either MS Access 2003, 2007 or 2010(depending on what version you have). Let me know if you want to consider. Thanks
Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person you are getting ready to work with. This is extremely insightful with the numerous bids you have received.
This is pretty straight forward. With the importing of Excel I would have the coder you hire have them use Dialog Box open for you to go and select the files you want to import. Also with Importing you will need to delete the data from the table in access. I would have the coder create an Archive as well in case you want to analyze the volume changes in your different locations.
For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create. Please feel free to ask any questions I am always willing to share my experience.
Best of luck with your search.
Michael
Hello
Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample copies if you so desire. U can expect quality work in time.
Thanks
Hi, Ms Access expert having 8+ years of IT experiance. Interested in your project. Please see your PM for more details and a sample access application.
Okay sir, Lets start.
Experienced vb programmer is here. Front end will be developed in vb and back end in ms access.
Please send me message to see my previous developed application.
Thanks
-Russel
Hello -
I have over 15 years experience in MS Access and VBA. I have built inventory systems with similar characteristics to yours several times.
I can get started on your project today.
I look forward to hearing from you soon.
Thanks -
Janet