Archive for category Microsoft Access

Editing An Already Made DB Using Access (reposted)

Hi

I have a billing system made using MS Access. It is a very simple billing system. I want to make a few changes to fit the requirements. The changes would be:
1. All coding is done using embedded macro, I want atleast some of the coding to be in embedded procedure using VBA.
2. A few changes in the bill form and some of the other forms.
3. I want the tables to be normalized and validated. Some of the fields are validated but some have to be validated.

These are the major problems to be fixed. There will be other monor changes while the changes are being done. So you have to agree to correct all those minor changes.

Budget – $20

Deadline – URGENT so fast as possible.

All payments will be made only after completion and checked. You can see my reviews, I do pay for what I get.

Thanks

PS: Time wasters and companies please dont waste your time as I want someone to be online for 5 hours atleast and fix everything for me.

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

A2billing ANI Call Back

I am looking for some one to setup my A2billing ANI Callback. Server is alraedy in Production Mode

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

VB Application To Edit Data From Excel File

Project Description

Bring data from Input file, edit information in fields and save back to Output file.

Have search option to call data from input file. Search value will be only use for to find from "ProductNo" column. So we will call the data using ProductNo.
Once we hit the search, system will bring all the information for that line, column headers are as field name and editable text boxes where the data from input brought. We will edit the information in text fields and then click on save and system will save the new information to next available row in "output" file in the same column header order in input file.

Why we need this?

We often change the information about products and we have to do it on this input excel file. It is very confusing and tiring to do it with scrolling up and down , right and left through rows. So we need this application where it will show all the information orginized in 1 page where we can edit the data from cells.

There are 90 column headers for each product, so for this application it will be hard for to make all column headers visible in 1 page. So lets make most important column headers data at the top side of the page.

Most common used fields / column headers data from input file;

-ProductNo
-Product
-SKU
-Oem
-Price
-Quantity
-Weight
-Brief
-Description
-Thumbnail
-Photo
-ExtText1
-ExtText2
-ExtText3
-ExtText4
-ExtText5
-ExtText6
-Active
-Mpn
-NaturalSearchKeywords
-NaturalSearchDescription
-Keywords
-Category

All the rest of column headers data less used so they can be bottom of the page.

Please remember, application will not make any changes on input file. It will only read data from input file. Adjusted data will be saved to next available row in output file.

Input file is CSV ( comma separated ) output file must be also same CSV format.

Sorry for my poor english. If you have any questions please feel free to ask.

Attachments are sample files. In real input file there are much more products but all column headers are always same.

**When you bid please explain how you want to do the application otherwise your bid will be disregarded.
**Full payment will be done only after final delivery.

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

Billing System Using VB And Access

Hi

I want a simple billing system using MS access and Visual Basic. It will be very simple.Just a few tables and a few forms and reports. I will explain more on PM.

PS: All coding should be in VB (embedded procedure) not embedded macro.

I will see the whole coding and the whole system and then only make payment. You can see my reviews, I do pay if i take it.

Budget – $20

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

Easy Copy/Paste Data Entry From Website To Access Database

We are looking for help to compile our database from many webpages to a single database. We are looking for somebody who can work quickly and enter the data efficiently, with an eye for detail.

If you are our person, you will need to:

1. Visit a website (usually the contact us page), and fill in a database entry based on the information available on that website.

The information needed includes:

Company Name
Name
Street Address
Postal Address
Phone
Cell Phone (if Available)
Fax
webURL
email
twitter? (if Available)
facebook? (if Available)

1. We will provide you with our list of directory sites, as well as the database (access) that you will need to fill in.
2. We are not sure exactly how many listings there are, but we suspect about 400-500, excluding duplicate listings.
3. Once you are completed, you will need to send us the database and we will verify a small sample to confirm it is real contacts, before final payment.
4. We will retain ANY and ALL Copyright on the database, and you will not be able to sell it elsewhere

We will be awarding this to bidders to $30. PLUS will offer an additional $10 if the project is completed on time.

Happy Bidding.

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

Data Entry Project

This is a Manual Data entry project to enter data into an MS Access Database.

The Access DB and pdf files will be provided. There are about 65 fields in db row. There are 367 pdf files. Each is file is about 2 pages (small)

Delivery date is Apr 7th. This is a hard deadline.
– We also need to review the entered database in stages so that we can monitor how the project is going.

Quality:
– Accuracy of data entered into the database is extremely important.
– We do not have any time for testing. So, the delivered database should be 100% tested by you.

Payment: 100% of payment will be released only after complete delivery with satisfactory quality.

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

Aircraft Statistics

I have been working on an Access database but I run into a snag. I need someone to complete or redo another one for me. I have daily/weekly/monthly Aircraft statistics that I manually update in a spreadsheet. I have to have the daily stats and monthly stats separate, but the monthly one has to be updated with the daily one. I update the daily one everytime an aircraft lands and at the end of every month I have to have totals of aircraft type; equipment used; type of pilot; block in/out; country of origin; pilot type (Military/Civillian); destination and arrival from. Its alot of information and I just cant get it all together in one database. Any help would be nice. It has to have monthly totals of everything on that spreadsheet, statistics of aircraft types and pilot types, and daily averages of planes.

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

Small VB.NET Project To Complete

Very Small VB.NET project to complete overnight. Required within the next 10 hours after bid acceptance. Bidding will run for a few hours until right programmer is selected. Do not bid if you can complete within 10hours of accepting the bid.

=> Database provided
=> VB.NET Code samples provided
=> VB.NET Forms Design provided

Software will have a maximum of 4 forms. About 5-8 fields per form.

Four Database Tables:
Customers, Products, Orders, Order Details->search add edit delete update

Printable Report for Order-Order Detail only

Flow of operation:

Main Form:

Create New Order-> Search Existing Customer -> Add New Customer if not exist -> Create Order for Customer -> Add ptoducts to order(order details) -> Take payment -> print report

Product Form: search add edit delete update
Order: search edit update

The flow is pretty simple and straight forward. No formatting or esthetics needed.

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