Importing excel file access database excel vba jobs
...contractor to handle projects and technical support. The task involves installation of network equipment (switches, access points, and security cameras for both indoor and outdoor areas). Your role will involve: - Mount/Install network equipment as directed - Field technical support - Remote support Contractor should carry liability insurance and C7 license is preferred Ideal candidates should have extensive experience with network cabling and a track record of executing similar projects successfully. It's crucial for the freelancer to be proficient in handling varieties of network cables especially Cat 5e, Cat 6 and Fiber optic cables, and familiar with network switches, access points, speakers, and security camera installations both indoor and outdoor....
...expert Access Developer to undertake some key aspects of a large-scale relational database for our office team. Tasks include: - Database Design and Development: Plan and construct a robust relational database incorporating more than 20 tables. - Form Creation and Customization: Create and customize user-friendly forms for data input and manipulation. - Report Generation and Analysis: Design analytical reports that will aid our decision making. Ideal skills: Proficiency in Microsoft Access, understanding of relational database theory and form design, experience with report generation and analysis. Prior experience working on large-scale databases would be a plus. This project offers a challenge but also a great opportunity for you to showc...
I need an age verification popup for my website that is displayed upon entry to any page. Key requirements: - Ability to change validation type (e.g. Over/Under 18; Date-of-birth, Year-of-birth) - see images - Ability to change images, text, background and redirection address (for Under 18) - To remember age verification forever (for Over 18s) and this session for Under 18...requirements: - Ability to change validation type (e.g. Over/Under 18; Date-of-birth, Year-of-birth) - see images - Ability to change images, text, background and redirection address (for Under 18) - To remember age verification forever (for Over 18s) and this session for Under 18s I already have a mock up design and imagery files available. The website is hosted by Neto e-Commerce and I have full access to ...
I'm looking for a professional who can make a .jar file in Java 17 for me. It is intended to be a software product which I want to package and distribute. Here are the specifics: - Purpose: The main goal of this project is to create a .jar file that is user-friendly and easy to use for anyone who downloads it. - Platform: The .jar file should be compatible specifically with Windows operating systems. It should be tested and guaranteed to run smoothly on those systems. You should have: - Proficient in Java 17 and Eclipse. - Prior experience in creating .jar files for software products. - A good understanding of user experience and interface design to ensure the .jar file's usability. I'm open to suggestions on how to improve this project. Your creativ...
I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!
...Users should be able to make purchases directly through the interface - Access Control: Secure access to certain information or features based on user roles - Loyalty Program Management: Implement a loyalty program to incentivize user engagement - User Portfolio: Users should be able to customize their interface with links, contact information, and product displays - **iOS App Development:** I need an iOS app to complement the NFC interface and provide a seamless user experience across different platforms. Ideal candidates for this project should have: - Proficiency in developing both NFC card interfaces and iOS applications - Experience with payment processing integration - Strong background in access control and user management systems - Familiarit...
...conducting employee performance reviews. This will be a crucial tool primarily utilized by team managers. Key Features: - The website should facilitate the process of conducting performance reviews. It should allow managers to set goals, document uploading and feedback, and track progress of administrators over time. - The platform should include a user-friendly interface for managers to easily access and navigate through. - Integration with email services is essential. Notifications for upcoming reviews, reminders, and other relevant communication should be sent through this system. - Calendar scheduling tools should also be incorporated to allow easy organization of review meetings. Ideal Skills and Experience: - Proficiency in web development, particularly for building inte...
if you can do the work on this moment you can do it i need the file like in within 20 min. it is a eps file it seems it is unsharp. file format is correct but it looks unsharp who can fix it. these are dthe guideline of the file needed:
As an organization, we aim to significantly boost our network security. Thus, we're seeking a skilled professional capable of: - Configuring firewall - Implementing an effective Intrusion Detection System - Establishing secure remote access Unfortunately, we skipped out on specifying our preferred secured remote access service and the size of our network infrastructure during the initial stages. However, we encourage applicants to be fully versatile with VPN, SSH, RDP, and to be equipped to handle infrastructure of various sizes. Prior experience with these areas will be advantageous. Do you have what it takes to help us execute a thorough network security overhaul? If so, we want to hear from you!
We are using an online field service software platform called Uptick for our field technicians to carry out inspections of fire systems. The online software we use generates a PDF report based on the field technician inputs. We have access to the CSS/HTML/DJango source code to modify the PDF output. We require a developer who will work with us to generate a PDF output based on our design by modifying the existing source code. Please note: The developer must be willing to discuss the project via [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] so that clear instructions can be discussed as to the required PDF output.
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...Maintains primary responsibility for grant schedules and tracking grants; * Serves as a liaison to all funding agencies and organizations; * Works with appropriate personnel to research, develop, write and submit letters of inquiry, concept papers and grant proposals; * Coordinates and follows-up on the progress of submitted proposals; Institutional Effectiveness; • Develops and maintains a master file on pending grants and contracts; • Remains up-to-date on current issues relative to grant proposals; • Inform business owner on the progress of all grants and issues that may arise with each grant. • Maintains confidentiality of information exposed to in the course of business Minimum Education, Skills and Abilities; * proven successful track record in the la...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. ...
I'm in need of someone adept at PHP and SOAP. My development site is currently returning a warning message: "Attempt to read property "Invoice_Number" on string." I've set up a dev SOAP server for you to carry out the work. At this point, I'm uncertain if I'm attempting to access the "Invoice_Number" property on a string. There are also no other error messages accompanying this issue. Key tasks: - Identify the cause of the "Invoice_Number" warning - Fix the PHP SOAP warning Ideal skills: - Proficiency in PHP - Experience dealing with SOAP - Ability to troubleshoot and resolve such issues promptly
...that is easy to navigate. - It should support live streaming capabilities in high quality. - A Video-on-demand library should be integrated to provide a variety of content for viewers. The panel should come with the following functionalities for user management: - User subscriptions management: allowing the administration of user accounts and subscriptions. - Multi-user access control: enabling different levels of access for various users. - User activity tracking: to monitor and analyze user engagement with the platform. Ideal candidates for this project should have experience in: - Developing Android applications, particularly in the field of IPTV. - Building user-friendly interfaces and ensuring smooth user experiences. - Implementing live streaming capabilities and m...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate
I want to set up an online shop on my website and have it connected to Fresha CRM, the system I currently use. This shop should have a so...Experience: - Proficiency in e-commerce development and CRM integration - Strong portfolio of elegant and sophisticated web design projects - Previous experience with integrating payment gateways - Excellent understanding of user experience and online shopping best practices is wordpress Need also to edit the website to look better! Need to create a shop where the client when access our website to buy directly from website and not from fresha which we are using now! About crm I m looking to integrate voucher / membership and most important when the client do an appointment from our website need to integrate with fresha if possible
...will pay commission per placement. This person can also bring in any other consultants on our payroll (Separate incentives for this) We don't need anyone who works on Job boards. Need someone with strong relationship in the market Job Types: Part-time, Freelance Ideal Skills and Experience: - Proven experience in IT Bench Sales recruitment is a must. - Strong network in the IT industry and access to potential candidates. - Proficiency in utilizing various sourcing techniques and tools to identify and engage with potential candidates. - Excellent communication and negotiation skills to ensure the successful onboarding of Senior-level candidates. - Experience in the freelancer recruitment model is a plus. This will be a freelance position and I'm open to discussing ...
We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.
We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.
I need a small metal shade structure built for a few horses to provide both sun and rain protection. The design should be durable, weather-resistant, and easy for the horses to access. - Materials: As indicated, the shade structure must be primarily built with metal for longevity. - Size: 40'X13' Ideal skills for this job include: - Experience with metalwork and construction - Understanding of, and experience with designing structures for animals, particularly horses - Knowledge of local weather conditions to best determine structure design. - drawing must meet Maricopa County standards
how to decode : All report content comes from the json data we provide, I explain the logic details in report logic.pdf., please check its content. I also attached a json data and a tire report , they come from one scan, you check its content to verify the report logic. we have to make similar script to generate report from our system
...and alert me about any potential security breaches. - Log Gathering: I'll need the app to effectively and securely gather logs from IoT devices. - Access Control Management: It should have the ability to manage and control access to the security system. Logging Mechanism: - The application should be able to log activities from sensors and smart home devices effectively. Ideal skills and experience: - Strong Python programming skills, coupled with experience in security applications. - Proficiency in designing and implementing robust intrusion detection systems. - Prior work on IoT device integration and data gathering. - Experience in access control management is a plus. - Understanding of secure logging mechanisms. In your bid, please include examples of ...
I am seeking researchers in Manchester, UK to conduct market research for a retail audit. The ideal candidate should have good communication skills and access to a smartphone. You must be available immediately. You will visit 30 bars in the city of Manchester, UK and the payment for this project is €390. For this project, the product costs and materials that will be needed to assess the product will be reimbursed. Specific requirements for the project include: - Conducting a retail audit in Manchester, UK - Collecting data and inputting it into an app Skills and experience needed for this project: - Strong analytical skills - Excellent communication skills - Ability to finish the project by a specific deadline - Flexible schedule Please get in contact if you are interested ...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...
I have previously worked code in and stored but it stopped working because readyPromise doesn't work and in that case, it can't load sequently and crashes. New Java stuff?? I...sequently and crashes. New Java stuff?? It doesn't recognize readyPromise with var/const only works as await. Async has problems too. Even without Crashing tilesets seem not to load both from ION and Private/Public Domain. Need to solve this ASAP. You need to download files and work within your Domain or IDE or any other way to work directly with CESIUM LIBRARY!!!!! Or I will give you my Domain FTP access to the project folder and you can Upload .js .html files and see RESULTS in this directory as it will load html and js: YOU HAVE TO WORK WITH CESIUM LIBRARY!!
i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.
I'm looking for an artist to paint roses on my China coffee pot in the Edelstein Delphine style. The purpose of this project is purely decorative. Key Requirements: - The style of painting should mat...to copy the colors and shapes of the roses on the bowl for the coffee pot. Ideal Skills and Experience: - Experienced artist with a good eye for detail and the ability to replicate a specific style. - Previous experience in painting on China or delicate surfaces would be a plus. - Good communication skills will be essential to ensure the final product matches my expectations. If you don't have access to enamel paint that can be baked on, I have some for you to mix and use. If you're confident you can recreate the Edelstein Delphine style of roses on my coffee pot, I...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...
Hello and Thank you for being here Trying to make this reference work Fails ("~/.ssh/mycreds") Works ("/home/username/mycreds") How can I make the logical reference work ~ Can you help me please ? Will give a 5 Star Review when this is done and will write such inspiring words for you, when done. Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually compl...
...AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity with accessin...
I need someone proficient in C# to help create a Remote Administration Tool (RAT). This tool will primarily offer remote desktop access. A user-friendly graphical user interface (GUI) is a must, with a clear and clean design that's simple to navigate. It should be tailored specifically for a Windows operating system. Ideal Skills: - Strong background in C# - Experience in creating GUI - Expertise in remote desktop functionalities Experience: - Developing RATs - Working with Windows OS - Designing intuitive GUIs
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover...
I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.
We are looking to build a new website using WordPress which will link to our .net bespoke erp software which is currently being developed. As all our business is B2B, it’s very important for our customers to access as much information as they can online without the need to call our office. Features include: - Ordering products should be in grids for our customers to order - Customers to order embroidered/printed goods with product selection controls in place - Modern and attractive up-to-date designs - Customers should be able to view all their account information - Customers should be able to download copy invoices and credit notes - Customer should be able to pay online - Customers should see what’s on backorder for them including editing and cancel them - Livestoc...
I'm looking for a skilled app developer to create a cross-platform (iOS and Android) app. The primary goal of the app is to provide information. Key Features: - A user-friendly, intuitive design that makes accessing and browsing information easy and engaging. - Implement a login feature that allows for quick access to the app without requiring user registration.( Only for initial phase later there is a need of registration also for paid course) Ideal Skills: - Proficiency in cross-platform development, with experience in both iOS and Android. - Strong UI/UX design skills to ensure the app is intuitive and visually appealing. - Familiarity with implementing secure login systems. Experience in developing similar information-providing apps would be a bonus, as would a trac...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Make a nice design for a lighting company's product catalog 2 products on each page with a small description of the product Like this:
Just like the title says, i currently have a script on my site that displays text on mouse over, just not sure why it wont let me add line breaks; i can not give you access to the site, but i can send you the script. I have tried adding... '<br>, n, b, ' not really sure why its doing it. Thanks,
...architecture 2-Proficient in integrating and consuming RESTful APIs to enable seamless communication between microservices 3-Skilled in testing and debugging microservices to ensure high performance, reliability, and scalability Identity and Access Management (IAM) 4-In-depth knowledge and hands-on experience with at least one of the following IAM solutions: 1.1 -Keycloak. 1.2-Casdoor. 5- Strong proficiency in Python programming language 6- Expertise in developing RESTful APIs using the Fast API framework 7- Proficient in utilizing MongoDB as a NoSQL database for storing and retrieving data 8- Experience with containerization using Docker and orchestration using Docker Swarm for deploying and managing microservices 9-Experience in working with RabbitMQ as a message broker....
I want to create a Calculator File locker app, similar to the ones already available (on codecanyon) and in play store. The app must work in both Android and iOS
Design and implement one page website. The website shall have a d...any third party libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
