Closed

MSAccess form, VBA, query tasks -- 2

1. Build a query to update [url removed, login to view] (query to be included behind [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] 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.

Skills: Microsoft Access

See more: vba load, microsoft vba, microsoft spreadsheets, microsoft access, microsoft access vba, build ap, create file table access, access query table, access create form, vba tasks, delimited access, vba data form, access table query, access table query form, access create query, form generation, microsoft access update form, access report vba query, query query, create table vba access

About the Employer:
( 91 reviews ) BONDI JUNCTION, Australia

Project ID: #7367819

25 freelancers are bidding on average $148 for this job

Prashantskin

[login to view URL] I have gone through your project requirements and the database. I will be able to do all the things. My question is.. Can I write VBA code in stead of query for the following..? 1. Build a query to More

$222 USD in 3 days
(486 Reviews)
7.1
branislavm

Hello, This is doable and ti will require, probably, some VBA coding. As for first task single query would not do, as, in that case, recordset will not be updateable. I am not sure why is needed to have such counter More

$222 USD in 2 days
(222 Reviews)
6.3
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 reco More

$200 USD in 5 days
(31 Reviews)
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, More

$200 USD in 3 days
(33 Reviews)
5.5
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 in 2 days
(57 Reviews)
5.6
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 More

$111 USD in 3 days
(32 Reviews)
4.8
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 b More

$180 USD in 3 days
(5 Reviews)
4.8
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 in 3 days
(28 Reviews)
4.8
mdkass

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

$65 USD in 3 days
(11 Reviews)
4.7
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 More

$150 USD in 8 days
(21 Reviews)
4.6
farr4u

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

$194 USD in 4 days
(19 Reviews)
4.3
bubu77

Hi, Access expert having 8+ years of IT experience and doing freelancing. We have gone through your requirement and will be able to do all the 5 points for you. Do you want to write the new code to the [login to view URL] More

$222 USD in 3 days
(5 Reviews)
3.4
AlexandrK1

please inform about next steps i can prepare first draft foe your approval within 24 hours .

$250 USD in 2 days
(3 Reviews)
3.6
smb310570

Your work can only be done by VBA programming. Please reply this massage for more discussions. Please see my profile and completed project for more details. You can also see me on [login to view URL] More

$50 USD in 3 days
(14 Reviews)
3.3
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. More

$60 USD in 3 days
(2 Reviews)
2.7
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 a More

$150 USD in 3 days
(1 Review)
2.0
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 do More

$70 USD in 2 days
(1 Review)
1.7
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 addit More

$155 USD in 5 days
(2 Reviews)
1.8
elmawardy

Hello , I would love to start working on this project at the moment ,I've already finished my last project s which looks like this project using (C# ,MS-Access & SQL) and here's a demo version of my work : https://w More

$95 USD in 5 days
(2 Reviews)
1.5
parama4u

7+ years in VBA, VbScript. Looking forward for long term relationship starts with small steps. Lets catch up. Ping.

$150 USD in 3 days
(0 Reviews)
0.0