Find Jobs
Hire Freelancers

open a specific excel worksheet corresponding to a number in a textbox using a command button

$10-30 AUD

Zaprt
Objavljeno pred skoraj 9 leti

$10-30 AUD

Plačilo ob dostavi
Good Morning all, I have a form in a database which as a textbox named "Core Serial Number" These serial numbers correspond to 58 different engines. I have 58 folders that contains two excel spreadsheets, with the folder name, and one of the excel spreadsheest name that same as the core serial number displayed in the text box. e.g. Core Serial Number Displayed in textbox on form = CAE540151 Folder located on A:\ Drive = CAE540151 Excel worksheet located in folder = CAE540151. The form is linked to an master excel spreadsheet, which is updated daily, and any data that is changed in the master excel spreadsheet is replicated on the form. What I would like to do is create a command button on the form that will allow me to open the excel worksheet located in the folder on A:\ drive that corresponds to the core serial number displayed in the textbox. If the serial number in the text box changes, then the command button will open the spreadsheet that corresponds to the new number. e.g. Core Serial Number Displayed in textbox on form = CAE540714 Folder located on A:\ Drive = CAE540714 Excel worksheet located in folder = CAE540714. I want to be able to do this without hyperlinks, as I have done this in the past, and when ever the serial number changes I had to re establish the hyperlink. I want it to be done so regardless of what serial number is displayed in the text box, when I hit the command button it will open the excel spreadsheet with the same number as displayed in the text box. Is this possible? I am using Access 2013
ID projekta: 8139372

Več o projektu

23 ponudb
Projekt na daljavo
Aktivno pred 9 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
23 freelancerjev je oddalo ponudbo s povprečno vrednostjo $29 AUD za to delo
Avatar uporabnika
Hi...As output you just want to open spreadsheet in Excel? or require other functions to do with spreadsheet?
$30 AUD v 1 dnevu
4,9 (54 ocen)
5,4
5,4
Avatar uporabnika
Hi, I have gone through your project requirement and would like to take an opportunity to work on it. I have worked on several projects on MS Access and can help you in adding command button on form with required functionality of opening particular excel file based on core serial number in text box. To discus sin detail, I would like to have chat and finalize on the project to start. Thanks.
$25 AUD v 0 dnevu
4,8 (74 ocen)
5,8
5,8
Avatar uporabnika
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.
$50 AUD v 1 dnevu
4,9 (44 ocen)
5,5
5,5
Avatar uporabnika
Hi Andrew, If it is a access form then I can do it for you. I can add a button in the form and on click of it it will open the excel named as in the text box. Please send me a copy of your database.
$35 AUD v 3 dneh
5,0 (8 ocen)
3,9
3,9
Avatar uporabnika
Предложение еще не подано
$30 AUD v 1 dnevu
4,9 (13 ocen)
4,2
4,2
Avatar uporabnika
Hello I can do this for you. I have many similar projects in the past. I can create a form and background macro for you. Please see my feedbacks
$35 AUD v 1 dnevu
5,0 (7 ocen)
3,7
3,7
Avatar uporabnika
Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please give me chance to prove myself. Thank u!
$29 AUD v 1 dnevu
5,0 (6 ocen)
3,6
3,6
Avatar uporabnika
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$40 AUD v 2 dneh
5,0 (5 ocen)
3,5
3,5
Avatar uporabnika
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. I have over 15 years of experience as Physics and Math teacher; 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. Send me database with hyperlinks and I could transform it into a command button. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$25 AUD v 1 dnevu
5,0 (7 ocen)
2,8
2,8
Avatar uporabnika
Aucune proposition n'a encore été fournie.
$20 AUD v 1 dnevu
4,5 (5 ocen)
2,6
2,6
Avatar uporabnika
I will help quickly and efficiently. Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.
$30 AUD v 1 dnevu
5,0 (4 ocen)
2,2
2,2
Avatar uporabnika
I have experience working with Visual Basic, Access and Visual Basic for Applications. I think I can do the work
$23 AUD v 1 dnevu
4,6 (1 ocena)
2,2
2,2
Avatar uporabnika
Hello, it definetly can be done: I can write it for you in VBA, but could be done with creating hyperlink dinamically. I understood that you want no hyperlink but it can be usefull information for you that it could be done by generating the hyperlink besd on the text in the textbox. Pls. take a look at my porofile i've had lots of VB and VBA jobs in the past few yrs..
$15 AUD v 1 dnevu
5,0 (1 ocena)
2,0
2,0
Avatar uporabnika
A proposal has not yet been provided
$30 AUD v 1 dnevu
5,0 (2 ocen)
1,3
1,3
Avatar uporabnika
dear sir I have 5 tear experience in vb.net and thus will ne a very easy task for me. please do consider my bid thank you. this particular task is very very easy I can do it within an hour.
$25 AUD v 3 dneh
5,0 (1 ocena)
0,5
0,5
Avatar uporabnika
Please look at my profile..........................................................................................................................................................................................................................................
$30 AUD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
this can be done, simple file searching and read data from it. with actual file structure and data it will be done in 1 day.
$35 AUD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have worked on similar kind of projects in past and the results were as per customer satisfaction. We have worked on different projects where we create reports in excel, save them and then open them as per customers/project need. I think i've experience and resources for working on your project and providing you with the results as per your satisfaction.
$35 AUD v 6 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Through VBA, i can force excel to open the spreadsheet entered into the data field in a user form. It's pretty simple code. Just send me the example of the file and the specified folder locations and I will write the code in about an hour.
$25 AUD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I am a Systems and Data Analyst with over 7yrs experience with financial institutions. I am a VBA and SQL expert. I provide Business Intelligence services for management and compliance reporting. My specialties are in Excel and Access VBA, SQL, XML, Web Services, Tomcat, IIS, Glassfish, HTML, Support Services.
$25 AUD v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava AUSTRALIA
Sydney, Australia
5,0
3
Plačilna metoda je verificirana
Član(ica) od jan. 16, 2015

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.