Vba sql database connection jobs
Hi, I have built a SCARA robot-arm, but need someone to help me to arrange electronics (RPI. ESP32, OPI) and software for it. 3 if its axes are driven by closed-loop stepper motors, each with its own internal driver and encoder and CANBUS connection. Another axis for vertical movement is a regular industrial servo motor that comes with an externa servo driver that is also connected via CANBUS. So all 4 motors need a controller able to control the arms all motors so the arm moves fast and with fluid and organically movements without any jerkiness. The arm will have 34 fixed points in space where is will pickup or deliver a small plastic containers. Pickup will have its own standard travel path and deliver will have it own as well. The differences is how it hooks into the container...
I'm looking for a skilled web developer who can design and implement a website for my Degen Memecoin project on the Solana blockchain. Key Requirements: - **Design Style**: The website should have a bold and colorful design to attract and engage users. - **Primary Features**: - User Wallet Connection: Users should be able to connect their wallets to the website. - Token Buying/Selling Functionality: The website should enable users to buy and sell the Degen Memecoin. - Real-time Token Price Chart: The website should display a real-time price chart of the Degen Memecoin. - **Homepage Information**: The homepage should prominently display: - Token Price - Token Market Cap Ideal Skills: - Proficiency in web development, particularly with Solana dapp scaffold. - Expe...
DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping
Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks
I'm looking to develop a comprehensive psychology app that will primarily focus on connecting users with licensed therapists. The ideal candidate for this project will have a deep understanding and experience in developing mobile and web applications, particularly in the psychology or mental health sector. Key Features: - User Registration and Profile Creation: The app should allow users to create accounts and set up their profiles. - Search and Filter for Therapists: A user-friendly search functionality should be implemented to help users find therapists that meet their specific needs. The app should be designed for iOS, Android, and Web platforms, therefore the candidate should be proficient in developing for these platforms. Experience with building secure and reliable messaging ...
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for acce...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...
I'm looking for an AWS expert to design and implement an online platform for my non-profit organization Community Connect. The primary feature of this platform should be project listings. Expectations: * Develop a categorization system specifically for educational projects. Ideal Skills: * AWS Experience * Proficient in Backend Development * Web Design * UI/UX Design Your understanding of categorizing and structuring information for user-friendly navigation will be key. Experience in developing platforms for nonprofit organizations or similar work is considered a plus. Your contributions will help connect volunteers with educational community projects, making a difference in our society.
I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.
I require a meticulous professional, experienced in the workings o...functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the softwar...
...close-ups, lifestyle shots). ###Copyright issue: Ensure that you are not violating any copyright laws when downloading images. Only download images that are publicly available and meant for public use. ###Steps to Collect Images: 1. Preparation: Create a folder structure on your computer to organize the images by product category (e.g., Shoes, T-Shirts, Sofas). Ensure you have a stable internet connection for browsing and downloading images. 2. Finding Images on Amazon: Go to Amazon. Search for a product category (e.g., "Men's Shoes"). Click on individual products to view their detailed pages. Select images that meet the quality and content requirements. Right-click on the image and select “Save Image As…” to download. Name the file appro...
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Appl...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
...easily recognizable, featuring a minimalist logo that incorporates a Himalayan blue sheep and using triangles to convey a sense of individuality and connection. Project Requirements: Logo Design: Create a minimalist logo that includes an abstract representation of a Himalayan blue sheep. Color Palette: Use the specified color palette to ensure a cohesive and professional look: #3A0360 #6622BD #7063BF #D5CEFF Versatile Branding: The logo should be suitable for various platforms and branding materials, such as business cards, clothing tags, and storefront signs. Our Vision: 'Purely Personal' is a fashion brand that celebrates individuality and connection. We aim to create a brand identity that is modern, elegant, and reflects our core values. The logo should be ...
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should...
- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project
...designing and implementing the user interface of our web application. A strong grasp of HTML/CSS, and Bootstrap will be crucial here. - Back-end Development: You'll also be involved in developing the server-side logic, and ensuring high performance and responsiveness to requests from the front-end. Proficiency in PHP is a must. - Database Integration: You'll be tasked with ensuring a seamless connection between the front-end and back-end systems, using CodeIgniter's database functions. I'm also open to discussing any specific features or functionalities you think could enhance our application. Ideal Skills: - Proficient in PHP, Laravel, JavaScript, HTML/CSS, and Bootstrap - Strong knowledge of CodeIgniter framework - Experience with integratin...
Need a college B. Tech student who is studying and want to earn something.
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...
I need help with a data entry task that involves extracting data from various websites and inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may ...to help with administrative tasks. Responsibilities: Manage Google Workspace (Gmail, Calendar, Drive, Docs) Handle domain management via GoDaddy Assist with email communications Update records and databases Requirements: Experience as a Virtual Assistant or in a similar role Proficient in Google Workspace Familiar with GoDaddy Strong communication and organizational skills Reliable internet connection To Apply: DM your resume. Tell me 3 reasons why you would be the right fit. We look forward to hearing...
I am an attorney and need a logo, favicon, and business card design. The name of my practice is "The Legal Way." I chose this name because of its slight connection to the railways. My legal practice is located in a building next to the train station. To reflect the connection between the railway and my legal practice, I would like to incorporate a railway intersection in the logo. The railway intersection represents my practice guiding clients to a legally acceptable path. I have created a few drafts that can be consulted in the attached documents. The design and colors should correspond to the existing web site that I will provide to the selected candidates by PM.
...automatically. This will ensure a seamless workflow and efficient task management within Trello. - **WhatsApp Integration**: The main goal behind this integration is to enable the sending of automatic messages. This could be vital for sending reminders, updates, or other important information to my team or clients. - **Billing Software Integration**: The developer should also work on establishing a connection between our billing software and other applications. This could involve automating invoice generation, tracking payments, or other relevant tasks. The ideal candidate for this project should have experience in integrating different applications and working with APIs. A good understanding of Trello, WhatsApp, and billing software integrations would be a big plus. I value...
Need freshers who want his first job with good visibility.
...previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding o...
I need assistance in migrating an Admin panel Vue2 application to Vue3 (approx. 40 pages / 86 *.vue files). This migration project will primarily focus on: 1. Moving to Vue3 / composition API 2. Moving from Vuex to Pinia 3. Rewriting JQuery AJAX calls to Axios / connection to the REST/JSON API. 4. Moving from a Bootstrap3 to a PicoCSS based layout. You may need to customize the CSS, as long as it mostly fits the previous layout (demo server available if you want to see how it looked like before). Nonetheless, the less custom CSS you'll write, the better. Required skills: - Strong expertise in Vue3, especially the Composition API - Proficiency in migrating from Vue2 to Vue3 - Good skills in CSS Layout / UX - Past experience handling medium complexity Vue applications - ...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
Need freshers who want his first job with good visibility.
I need assistance troubleshooting a VPN connection, you assisted me setup this connection, the host has upgraded their router and they are struggling to get the VPN up. We can discuss any details over chat.
...journey towards sobriety. Key Features: - Daily Tracker: Users should be able to log their daily progress and track their journey towards sobriety. - Motivational Quotes: The app will feature a collection of motivational quotes to inspire and uplift users. - Progress Charts: Visual representation of their progress in the form of charts or graphs. Additional Features: - Alcohol Test Device Connection: Ability to connect with an alcohol test device through Bluetooth for added accountability. - Alcohol test result history management - Competition Rank Board: A competitive element where users can see how they rank against others in their sobriety journey. We need to refer to and we add some community function in the app. Ideal Skills: - Proficient in app development for both
...button on phone to sound a loud alarm on PCB - Flashing light feature - light flashes when alarm sounds - Show on-map location - Rechargeable battery capability - Battery charge status either within app or on PCB i.e. flash red LED on PCB when charge low Nice to Have - Show distance to PCB based on signal strength The app should be: - Compatible with both iOS and Android devices. Bluetooth Connection: - The desired Bluetooth range is less than 50 meters. Ideal Skills and Experience: - Proficiency in PCB design and software development. - Experience in mobile app development for iOS and Android. - Familiarity with Bluetooth technology. Link to similar product:
I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual reports. ...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and I... - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow easy expansion for adding new sales data, inventory items, saved BOMs, assemblies, types or categories. **Skills Required:** - Demonstrated experience in BOM and Inventory system development. - Advanced Excel Macros and VBA skills. - An analytical approach with a focus on delivering simple and functional solutions. Candidates are encouraged to share examples of previous similar projects. This project aims to deliver a straightforward solution that supports our small home business operations effectively. Budget: Maximum o...
...experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this r...
...into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm l...
I'm seeking a seasoned logo designer experienced in integrating indigenous art into modern design. This logo should aesthetically represent my Australian native civil construction company. Let me share the specifics: - Colors: The colors should consist of Red, Yellow, and Black. These reflect our aboriginal connection and corporate identity. - Artwork: Incorporation of Aboriginal artwork is vital. Creatively weave indigenous motifs into the modern design to establish a captivating blend. Ideal Skills: - Ability to merge traditional and modern design - Experience with indigenous Australian artwork - Sensible color applications in logo design - Knowledge of the construction industry would be a bonus. Your portfolio demonstrating your previous work in this realm will be helpful...
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...
...imagery Request file building from SEA Content Studio for new images to be created Request photo retouching for all lifestyle photos to be featured Route loose cross-functional imagery for approval Fulfil image requests from various functional teams Communicate with other team members on requests, project information and transferring of assets Keep trackers up to date along with managing asset database Work with usage rights team on 3rd party assets relevant to the SEA markets Work with digital asset managers to transfer launch assets to long-term Digital Asset system Assist Content PM(s) in understanding the nuances of different languages and be able to identify what content requires localisation and to convert it to a brief for the graphic production team Plan, manage...
Hi Falaq, reaching out in connection with the ongoing project (Mark Solonsch). I think it's better for us to at least have a quick call regarding on the webpage we are creating. Thank you!
...functionalities I am looking for in this API include: - Provision of Real-time data updates - Implementation of robust Security measures - Seamless Integration with existing systems - Development of a user-friendly Back-end and front-end infrastructure for an investment and trading app. - Connection of accounts in Forex, Stocks and Crypto brokers and exchanges to show live and historical statistics - Copy trading / social trading / PAMM with risk management features (on the next project) - Connection of startup business and real estate accounts (on the next project) Key Skills and Experience: - Proficiency in Python, Ruby on Rails and other relevant programming languages and frameworks. - Experience in creating APIs with real-time data functionality and stron...
I'm in need of a skilled freelancer to film and edit Instagram reels for my bus...posting schedule of twice a week. - Creative and engaging ideas to attract a broad audience. - Sharp editing skills, and a knack for business-related content. Ideal candidate should have: - Experience in video content creation and editing, preferably for Instagram reels. - Good understanding of what captures audience on Instagram, especially regarding business content. - Reliable internet connection for smooth communication and transfer of files. - The ability to hit deadlines and stick to the posting schedule. This project brings the opportunity to be part of an innovative content journey, delivering direct impact to brand growth. Hence, I look forward to working with a passionate and commit...
I'm in need of an experienced developer who can build a completely custom database website that primarily serves as a customer relationship management (CRM) tool. In addition to the standard CRM functionalities, I'm looking for the following: - Expertise in complex Java and YAML scripting - Ability to create custom database scripts - Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong...
Seeking a Los Angeles based social media manager who specializes in content creation (reels). Main Responsibilities: Develop and im...more than 2 posts per week) Ideal Skills: - Proven experience with Instagram platform - Solid understanding of demographic preferences of mature professionals - Creativity and effective communication skills - Demonstrated ability to create engaging content that sparks conversations Your expertise will play a significant role in raising awareness about our brand and establishing a stronger connection with our audience. Please bid if you are interested in bringing ideas and strategies to life and have proven success engaging this demographic on Instagram. You will be responsible for developing high-engagement strategies as well as overall account m...
in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...
I am currently working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control
