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.


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.

Taidot: Microsoft Access

Näytä lisää: 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

Tietoa työnantajasta:
( 91 arvostelua ) BONDI JUNCTION, Australia

Projektin tunnus: #7367819

25 freelanceria on tarjonnut keskimäärin 148$ tähän työhön


[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 Lisää

$222 USD 3 päivässä
(486 arvostelua)

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 Lisää

$222 USD 2 päivässä
(222 arvostelua)

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 Lisää

$200 USD 5 päivässä
(31 arvostelua)

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, Lisää

$200 USD 3 päivässä
(33 arvostelua)

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 2 päivässä
(57 arvostelua)

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 Lisää

$111 USD 3 päivässä
(32 arvostelua)

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 Lisää

$180 USD 3 päivässä
(5 arvostelua)

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 3 päivässä
(28 arvostelua)

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

$65 USD 3 päivässä
(11 arvostelua)

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 Lisää

$150 USD 8 päivässä
(21 arvostelua)

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

$194 USD 4 päivässä
(19 arvostelua)

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] Lisää

$222 USD 3 päivässä
(5 arvostelua)

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

$250 USD 2 päivässä
(3 arvostelua)

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] Lisää

$50 USD 3 päivässä
(14 arvostelua)

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. Lisää

$60 USD 3 päivässä
(2 arvostelua)

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 Lisää

$150 USD 3 päivässä
(1 arvostelu)

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 Lisää

$70 USD 2 päivässä
(1 arvostelu)

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 Lisää

$155 USD 5 päivässä
(2 arvostelua)

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 Lisää

$95 USD 5 päivässä
(2 arvostelua)

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

$150 USD 3 päivässä
(0 arvostelua)