MSAccess form, VBA, query tasks -- 2

$30-250 USD

Cerrado

Publicado

hace alrededor de 9 años

$30-250 USD

Pagado a la entrega

1. Build a query to update [login to view URL] (query to be included behind [login to view URL] GL button) 1st AccountNo, AP Record DLineNo=1 2nd AccountNo, AP Record DLineNo=2 3rd AccountNo, AP Record DLineNo=3, etc. eg. AccountNo AP DLineNo 0686688200 AP630 1 0686688200 AP630 2 0686688200 AP630 3 0686688200 AP887 1 0686688200 AP887 2 0686688200 AP922 1 0686688200 AP930 1 0686688200 AP940 1 0686688200 AP950 1 0686688200 AP950 2 0686688200 AP950 3 2. Format the Manager & Accountant output spreadsheets (produced from [login to view URL] Spreadsheets button :- 2.1. Fit column widths for all columns in all worksheets 2.2. Bold Titles for the columns 2.3. Current, LastMonth & 12MnthAvg columns to be formatted as currency, $ with 2 decimal places 2.3. OUTop20Calls format 2.3.1. CallDateTime dd/mm/yy hhmm 2.3.2. Seconds , between thousands 000 2.3.3. ChgExGST $, 2 decimal. 3. Place a message on [login to view URL] when reports are being generated ‘Report generation in progress, please wait’ This message should only appear when reports are being generated and should disappear when reports are complete 4. Place message in worksheets where data was not found ‘- no data found - 5 Create a query that will generate the output using tables GLTemp_H, GLTemp_L & GLTemp_D The output query will be exported as CSV format , (comma) delimited no text delimiter The format for the output file is as follows: refer doc I will load a spreadsheet with more explanation on this output.

Microsoft Access

ID del proyecto: 7367819

Información sobre el proyecto

23 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

23 freelancers están ofertando un promedio de $147 USD por este trabajo

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.

$150 USD en 8 días

4,9

(215 comentarios)

7,6

@Neno585

Hello, I am employed MS Access/SQL Server developer and I can do all of your tasks without much of my problem. As the rating and your satisfaction is very important to me I would do my best and even fulfill minor additional requests if you happen to had ones. If you are interested, fell free to contact me. In any case, thank you for the consideration and I wish you all the best.

$155 USD en 5 días

5,0

(23 comentarios)

7,4

@jhaynes75

I have 15 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven record of providing quality workmanship. My experience and knowledge of coding and databases makes me one of your top bidders for this project. I take pride in my work and always strive to exceed customer expectations. I look forward to hearing from you and hope we can work in the near future. I'm available to start right away. Regards, Jerry

$200 USD en 5 días

5,0

(30 comentarios)

6,0

@dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you like to complete some tasks as you described. I have 6 year's experience designing and developing Microsoft Access Application. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.

$111 USD en 3 días

4,9

(70 comentarios)

6,0

@jawadaman

Hi I am interested in this project. I can do the job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks. Regards, Jawad

$77 USD en 3 días

5,0

(79 comentarios)

5,7

@mail2vimalarora

Hi Gary, I have gone through your project details and would like to work on it. I am putting my bid here to start working on it. Rest we can have discussion on Skype on the project progress. Thanks, Vimal

$127 USD en 2 días

4,7

(121 comentarios)

6,1

@winghei

Hi, I see your needs and I want to help. I am a skilled DBA/Software Developer working on several platforms both on desktop/web application mainly on MS Access and PHP/MySQL. With my skills and years of experience, I can assure you can have a quality product. Moreover, since I am an accountant too, I think I'm the best fit for this job. I have also created a similar project using excel as the final output and where data stored are on Access Database. Hoping for you response and have a nice day. Best Regards, Sherwin

$200 USD en 3 días

5,0

(33 comentarios)

5,5

@farr4u

HI, expert here ready to start, I assure you high quality work done, thanks in advance.

$194 USD en 4 días

5,0

(22 comentarios)

5,3

@bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL, MYSQL,SQL server and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.

$180 USD en 3 días

5,0

(9 comentarios)

5,2

@mdkass

Hello, I have good experience with Access and writing vba and automation, I can do your project easily. Regards.

$65 USD en 3 días

4,8

(13 comentarios)

4,8

@piekn

Hello. I think, it's real to perform it. But I need to specify some tasks: 1. "Format the Manager & Accountant output spreadsheets" - MS access allows format only forms (not tables), that may have "table-like" view. And it's possible to format exactly the form, created and linked with this table. 2. "Place message in worksheets where data was not found" - table doesn't allows that, only forms. Form may have the same name, the same view like the linked table. So, - no data found - may be only on the form 3. ‘Report generation in progress, please wait’ - I think, it possible using modal form. So, if you agree with my specifies, contact me, please.

$60 USD en 3 días

5,0

(12 comentarios)

4,3

@robnicholson

I can help with your Access forms and VBA requests. I have worked with Access for over ten years, so I have a good grip on changing Access objects, modifying and creating VBA. Please note my bid is low because I am doing this to improve my rank rather than to gain money. Regardless of whether you choose me, have a nice day :-)

$70 USD en 2 días

5,0

(2 comentarios)

2,6

@barkatmulani

I have years of experience working with MS Access. Could deliver the given tasks with quality work and in reasonable time frame.

$110 USD en 10 días

4,8

(4 comentarios)

2,6

@milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan

$150 USD en 3 días

5,0

(1 comentario)

2,0

@pnjadhav

Please review my profile I am working with skills that you required for this job from 14 years. Screenshots I have attached in zip file which has lots of samples of MS Access,Excel,MS SQL with VBA work I have done. I can definitely help you in this job, to make your database design very proficient. Recently I have done projects in Power Pivot,DAX with Excel. If you want to know my advanced level skills in MS Access/Excel with VBA, we will do a Skype or G-talk discussion. I will shows my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc.

$277 USD en 3 días

5,0

(1 comentario)

0,6

@achintya

Hi. I have done several projects like this in past. I have 10+ yrs of exp. in VBA for Excel/Access and online. I can deliver you project quickly with excellent code quality. I will also provide proper documentation so in case of any change requirements in future it can be done easily. Thanks.

$155 USD en 3 días