Posts Tagged access database numbering

Access Table

Here is what happens:

I generate a coupon with a bar code on it.

I have a computer with a bar code scanner – it scans the coupon directly into the access database as a simply number or text. If the number is there, it marks the record as true.
Then next time someone tries to redeem same barcode the database provides a dialog box stating already redeemed.

This time I need to mail the coupons out and when they are redeemed, I want the database to CREATE a RECORD with a field (simple ascii) for the number and a field marked TRUE.

Can you do that? Yes or NO – I need to do it right away.

Tags: , , , , , , , , , , , , , , , ,

Repair or rebuild access DB system

This will need to be done via remote access. Here are described issues by user.

System does not populate "Name, Address, City, State, Postal Code" Fields with information entered. Instead, it automatically plugged in "Name (or a two digit number) , Address, City, State, Postal Code". This did not effect all the database just certain members.
If I need to search for a particular member, the database doesn’t recognize it by name because it plugged in a number (i.e. if you enter a #10 it brings up all the members affected).

Cannot send out membership cards because the information in the Contact Info. Screen formation also populates the letters that are to be mailed with membership cards.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Online website database portal with fedex tracking integration

This project requires modification to existing website. The mod will allow user to sign up for account on our website and at the same time create fedex shipping label to be printed at their station. (Integration will be done with Fedex API.)

Customer at login to website will be able to track fedex shipping status as well as internal project management after package is received by us.

Database will be created to store customers information and will be accessible to admin users as well as employees with rights. Project status will be editable and customer will be searchable by fedex tracking number. Admin will also communicate with customer to discuss final stage of internal project where customer will confirm or reject project amount.

There are several more details, but this is the basis for the size of this project. We have an entire proposal prepared for serious programmers. Please do not respond with generic information about your company, those requests will be ignored.

We are looking to roughly complete this project in one month or less. The budget for this project is approximately $3000. Thank you for your time.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,