Find Jobs
Hire Freelancers

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

$10-30 AUD

Zamknięte
Opublikowano prawie 9 lat temu

$10-30 AUD

Płatne przy odbiorze
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
Identyfikator projektu: 8139372

Informację o projekcie

23 ofert
Zdalny projekt
Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
23 freelancerzy składają oferty o średniej wysokości $29 AUD dla tej pracy
Awatar Użytkownika
Hi...As output you just want to open spreadsheet in Excel? or require other functions to do with spreadsheet?
$30 AUD w 1 dzień
4,9 (54 opinii)
5,4
5,4
Awatar Użytkownika
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 w 0 dzień
4,8 (74 opinii)
5,8
5,8
Awatar Użytkownika
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 w 1 dzień
4,9 (44 opinii)
5,5
5,5
Awatar Użytkownika
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 w 3 dni
5,0 (8 opinii)
3,9
3,9
Awatar Użytkownika
Предложение еще не подано
$30 AUD w 1 dzień
4,9 (13 opinii)
4,2
4,2
Awatar Użytkownika
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 w 1 dzień
5,0 (7 opinii)
3,7
3,7
Awatar Użytkownika
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 w 1 dzień
5,0 (6 opinii)
3,6
3,6
Awatar Użytkownika
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 w 2 dni
5,0 (5 opinii)
3,5
3,5
Awatar Użytkownika
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 w 1 dzień
5,0 (7 opinii)
2,8
2,8
Awatar Użytkownika
Aucune proposition n'a encore été fournie.
$20 AUD w 1 dzień
4,5 (5 opinii)
2,6
2,6
Awatar Użytkownika
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 w 1 dzień
5,0 (4 opinii)
2,2
2,2
Awatar Użytkownika
I have experience working with Visual Basic, Access and Visual Basic for Applications. I think I can do the work
$23 AUD w 1 dzień
4,6 (1 opinia)
2,2
2,2
Awatar Użytkownika
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 w 1 dzień
5,0 (1 opinia)
2,0
2,0
Awatar Użytkownika
A proposal has not yet been provided
$30 AUD w 1 dzień
5,0 (2 opinii)
1,3
1,3
Awatar Użytkownika
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 w 3 dni
5,0 (1 opinia)
0,5
0,5
Awatar Użytkownika
Please look at my profile..........................................................................................................................................................................................................................................
$30 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 6 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
Sydney, Australia
5,0
3
Zweryfikowana metoda płatności
Członek od sty 16, 2015

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.