Access Database

$10-30 USD

In Progress

Posted

over 8 years ago

$10-30 USD

Paid on delivery

I have an Access database, In the FRM_JobTicket there is a button to create a new record. What I need is a new button to create a related “component” ticket. If the existing record number is 2345, then the first new component ticket will be 2345a, the second component will be 2345b and so on. After the letter z the next letter will be aa then ab and so on. After az will be bb, then bd and so on. The number remains the same but the letter changes each time a new component ticket is created. In the FRM_JobTicket will be split into two parts. The top half has the current record details and the bottom will be listed all the component tickets relating to the ticket above. Clicking on a component ticket record will take you to that record. Database to be returned with all codes easily accessible.

Microsoft Access

SQL

Visual Basic for Apps

Project ID: 8743381

About the project

2 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

2 freelancers are bidding on average $50 USD for this job

@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.

$75 USD in 3 days