I am building a new website that sells perfume.
I use a sql database. I use Access to odbc to the Sql Database for data changes etc.
All the products will have defined fields such as product ,brand, retail price,discount,site price,upc number,size,breift description as well as a large description etc.
What I want to do is make a visual basic form that connects to my sql database and display these defined fields along with the image.
Here is a screen shot.
I had this before and it looks like this. I have access to the old form if you wish to take on this job want to use it as a template.
I am open to other web applications if someone has a better idea.
Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
5)The form shall display similar items as displayed in the screen shot.
6)In addition to this simple form I would like to have the ability to print three defined fields text fields, Model Number ProductID and retail to a dymo 330 lable maker printer.The product id will need to also appear as a 3 of 9 bar code.
Note the lbl button. When pressed it creates the require label.
7)Very important to the sucess of this form is the ability to send a "special deal to a customer"
Here we entered the product and could specify the deal type.
Here is how it works.
I enter the product.
I specify the deal type. I pull a predefined template.
The form creates a unique shopping cart link.
I enter the customers email address and send the link to the customer.The customer receives the email with a link to buy it on the website for the discounted price.
Again I have the old form for you to review if you need assistance.
Windows 2000 ,Windows 2000 SERVER WINDOWS 2003 SERVER
I prefer Access 2000 but can upgrade to Access 2003 if necessary. THe current form is in access 200