Devam Ediyor

114415 Microsoft Access MDB Changes

I have a Microsoft Access project that needs to be complete. I have several tasks involved but I would like you to bid on this task only for now.

I have a MDB file which upon opened opens a switchboard. This program is for a guy who manages theater trailers. This program is already complete I just need some modifications.

When the switch board is shown you will see the option of Printing A Report. The Report will contain information regarding the current compaigns for a specific theater in a specific city. The user will first ender the campaign starting date and ending dates. The Query will then grab all the campaigns between those 2 dates and generate a report for each one. This functionility is already built.

Rigth now the report looks like this:



Name | X | X | | | Trailer Length | Extend Date

The X are a checkbox under the heading G PG, etc. Again this functionality is already built. Onto what we need:



Name | X | X | | | Trailer Length

Extended Campaigns


Name | X | X | | | Trailer Length

We need the reports be broken up into 2 sections. Campaigns and Extended Campaigns. Campaigns will list only the compaigns between those 2 dates with no extension and related to the theater and city this report is for. Extended Campaigns will show a list of campaigns who only have an extension date and will coorespond between the two dates, theater and city.

I have started building this but I am stuck. From my understanding there needs to be 2 sub-reports used. Each of those sub report queries must be related to the values inputed via a form before the report is pulled up. I was passing the variables through the form to the report so the query can accept parameters. The problem I have encounted is doing it this way by looping through the the database for each theater and city and then generating the right sub report using the information from the first query to be quite difficult. Since the report might have 8 pages, the next 7 pages are still using the first sub reports information as theres no way to have the sub report update every page generated by the report from my understanding.

This is rather hard to explain, basically ill give you the mdb so you can check it out yourself once you bid. The bid can be temporary until you see the mdb. I am just looking for someone highly skilled in Microsoft Access/VB to make this project work.

Beceriler: Her şey Kabul, Microsoft Access, Visual Basic

Daha fazlasını gör: what is mdb file, what is an mdb file, what is a mdb file, starting with visual basic, what is microsoft visual, what is microsoft project, Microsoft work, microsoft visual, make a trailer, microsoft, mdb, ender, access microsoft, access project program, update form access, microsoft access database modifications, program trailer, access database form reports, database project microsoft access, visual basic access project

İşveren Hakkında:
( 2 değerlendirme ) Omaha, United States

Proje NO: #1860586