Airdate Mangement System - Check number & Invoice Number Addtions

已完成 已发布的 Apr 17, 2013 货到付款
已完成 货到付款

Overall Description to the Data Base

1) This is a live database and in full use

2) There is a front end Access DB linked to a backend Access data base.

3) 48 Tables on the backend

4) 185 different queries

5) 126 different forms

6) 29 different reports

7) 14 different macros

8) 14 different modules

As you can see by the above, this is not a simple data base and anyone that is not an advanced coder and understands Microsoft Access could quickly have a mess on their hands if they aren’t very sure what they are doing.

The good news is that we test extensively before going live because of the obvious problem it would cause if there were errors in the live data base.

Item 1: See the two screen shots [Air Dates Search - highlight selected [url removed, login to view] and Air Dates Search - Move the [url removed, login to view]] for the change on the “Air Dates” form. It is two points:

a) move three columns to the left so it is next to the “local date” column

b) when a person selects a row it needs to highlight so as to identify the row all the way across

Item 2: Append an “Invoice” field and a “Check Number” field to the “Airdate” table OR create a new table hold those two fields. If it is a separate table it would have to be set up as a relation to the “tblAirdate” table. It will more likely be best to append the table. NOTE: there will have to be way to auto-advance the Check number. This will be used in a later addition to this database.

Item 3: When on the Air Dates Search form query a station “KDOC” and then “alt-E” to edit a record. The “Edit Airdate” Form comes up. The two fields added to “Item 2” above will be put in this form, see [Air Dates Search - Move the [url removed, login to view]] for example. If the two fields end up being in a separate table then a relationship would have to be established between the new table and the “tblAirdate” table.

微软Access

项目ID: #4439821

关于项目

4个方案 远程项目 活跃的Apr 17, 2013

授予:

winghei

Hi, Please check my profile and your pmb Regards, winghei

$65 USD 在0天内
(29条评论)
5.3

有4名威客正在参与此工作的竞标,均价$87/小时

amcsummers

Thanks for taking the time to writea detailed scope. It makes it a lot easier to give a fair price on work. You referrenced some jpg files but I did not see them on the project. I hope you will consider my bid. F 更多

$85 USD 在3天内
(38条评论)
5.1
emova

Hi. I'm an access expert. I read through your project description and can assure you of getting this done perfectly with 100% accuracy and attention to detail. Kind Regards. Emmanuel

$99 USD 在3天内
(32条评论)
4.3
expertcoder1vw

I'm a professional MS-Access / VBA / SQL Server developer and can do this job for you starting today. Thank you for considering my bid. Bests, Larry

$99 USD 在2天内
(8条评论)
4.2
NourElDeen

Dear Sir, I'm Ready To Help. Best Regards, NourElDeen

$100 USD 在2天内
(18条评论)
4.1