Find Jobs
Hire Freelancers

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

$10-30 AUD

Ditutup
Dibuat hampir 9 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim
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 Proyek: 8139372

Tentang proyek

23 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
23 freelancer menawar dengan rata-rata $29 AUD untuk pekerjaan ini
Avatar Pengguna
Hi...As output you just want to open spreadsheet in Excel? or require other functions to do with spreadsheet?
$30 AUD dalam 1 hari
4,9 (54 ulasan)
5,4
5,4
Avatar Pengguna
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 dalam 0 hari
4,8 (74 ulasan)
5,8
5,8
Avatar Pengguna
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 dalam 1 hari
4,9 (44 ulasan)
5,5
5,5
Avatar Pengguna
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 dalam 3 hari
5,0 (8 ulasan)
3,9
3,9
Avatar Pengguna
Предложение еще не подано
$30 AUD dalam 1 hari
4,9 (13 ulasan)
4,2
4,2
Avatar Pengguna
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 dalam 1 hari
5,0 (7 ulasan)
3,7
3,7
Avatar Pengguna
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 dalam 1 hari
5,0 (6 ulasan)
3,6
3,6
Avatar Pengguna
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 dalam 2 hari
5,0 (5 ulasan)
3,5
3,5
Avatar Pengguna
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 dalam 1 hari
5,0 (7 ulasan)
2,8
2,8
Avatar Pengguna
Aucune proposition n'a encore été fournie.
$20 AUD dalam 1 hari
4,5 (5 ulasan)
2,6
2,6
Avatar Pengguna
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 dalam 1 hari
5,0 (4 ulasan)
2,2
2,2
Avatar Pengguna
I have experience working with Visual Basic, Access and Visual Basic for Applications. I think I can do the work
$23 AUD dalam 1 hari
4,6 (1 ulasan)
2,2
2,2
Avatar Pengguna
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 dalam 1 hari
5,0 (1 ulasan)
2,0
2,0
Avatar Pengguna
A proposal has not yet been provided
$30 AUD dalam 1 hari
5,0 (2 ulasan)
1,3
1,3
Avatar Pengguna
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 dalam 3 hari
5,0 (1 ulasan)
0,5
0,5
Avatar Pengguna
Please look at my profile..........................................................................................................................................................................................................................................
$30 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 6 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Sydney, Australia
5,0
3
Memverifikasi Metode pembayaran
Anggota sejak Jan 16, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.