Project vba sqlmunkák

...Write clean, functional code and test it for responsiveness and efficiency • Troubleshoot, debug and upgrade software as needed • Write technical documentation and collaborate with other developers and product managers Qualifications: We are looking for a Full Stack Developer with: • At least 2 years of experience in developing desktop applications • Proficiency in C# and Microsoft SQL • Proficiency in designing XAML UIs out of Canvas designs (Experience with Canva is a plus) • Experience with MVVM and MVC design patterns • Experience in designing and integrating RESTful APIs • Knowledge of best practices for software development and testing • A passion for technology and innovation • A team playe...

I'm seeking a proficient Excel expert to create a spreadsheet that calculates the future value of an annuity. This tool will be used for varying payment accumulation scenarios specifically: - Monthly payments - Annual payments -Can get an existing online template but customize to meet this project needs -NO VBA and NO Macro needed The payment periods for the annuity will span 10-50 periods. The spreadsheet should be intuitive, user-friendly, and accurate at determining future values. Ideal Skills and Experience: - Excel proficiency - Understanding of financial calculations - Previous experience in creating financial tools in Excel Please note, at this stage, no graphical representation like charts or graphs are needed for the calculation results. Attention to detai...

Very Basic Code I'm looking for an PHP Debugger who can work with me on my Windows development environment. Your expertise will be crucial for improving and maintaining the current code. Key Requirements: • Deep understanding of PHP, JavaScript, and HTML/CSS and sql • Familiarity with Windows operating system. • Prior experience with phpmyadmin is desirable. To execute this project, you will need to dive deep into the code, hence prior experience with similar projects is highly preferred. Your ability to identify, isolate, and fix issues in the PHP code will be crucial in this role.

Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!

I'm currently undertaking a course that requires a deep dive ...seeking a skilled professional who is proficient in Tableau, SQL, and Power BI. Your role will include but not limited to, the following: - Creating comprehensive reports and dashboards tailored to the needs of my course project. - Carrying out data analysis and visualization, interpreting the data for clarity and easy understanding. Ideally, you have extensive experience in Tableau, SQL, and Power BI with a deep understanding of data analysis but most importantly extraordinary data visualization skills. Knowledge of query optimization is an asset. Additionally, if you have experience in the academic setting, that's a bonus. Your creativity is welcomed as long as it falls within the r...

...reliable freelancer to handle the deployment and maintenance of our ASP.NET Core MVC e-commerce website. This is a critical role as we expand our client base and aim to ensure the smooth operation of our websites. Responsibilities: Server Administration: Set up and configure the server environment for hosting the ASP.NET Core MVC e-commerce website. This includes allocating resources such as MS SQL databases and ensuring server security. Website Maintenance: Regularly monitor the website for uptime, performance, and security. Take necessary actions in case of downtime or security threats. Software Updates: Apply software updates, security patches, and perform necessary migrations to keep the website up-to-date. Code Deployment: Work closely with our development team to uploa...

...a member of a team working with a specialized Postgres SQL database, I need someone proficient in SQL to conduct a walkthrough on writing complex queries, over a Zoom call. During the walkthrough, we'll be focusing deeply on: - Syntax and formatting - Managing associations using Joins - Writing Subqueries and nested queries My main aim is to understand the structure and formatting of these queries, how to establish relationships across various database entities using joins, and understand the use and function of sub-queries and nested queries. The functionalities of tables and fields in the queries are also a crucial part of this project. Ideal qualifications would be: - Extensive experience with SQL - Ability to explain complex SQL concepts c...

...generated will be sorted based on different project attributes and purchased with the initial capital budget of $650,000. The number of projects available for purchase will increase by 5 every year, with 25 projects available in the first year. The cash flow of each purchased project is added to the capital remaining at the end of that year; if $600,000 worth of projects are purchased in the first year, then the next year's budget will be $50,000 plus one year's worth of cash flow from each purchased projects. The cash flow of each purchased project will be added to the budget of every year of that projects lifetime. At the end of the purchasing cycle (5 years), the net wealth accumulated from the purchasing decisions made is compared across different p...

...require a professional with a strong command of macros and VBA code. Although I'm still finalizing the design and layout, my vision is for a simple and clean aesthetic for the spreadsheet interface that remains user-friendly. The functionalities that I would like to integrate, but don't quite know how to, are: - An automatic room booking system. - Interconnect the dynamic database with the availability check. -Create automatic work orders for the registered event. -Fallow up warning . The right candidate should have significant experience with Excel, specifically with implementing macros and VBA code. A potent mixture of creative and technical experience will be ideal for creating a design that's simplistic yet efficient. If this project excites you...

I have an on-going project which has been built using ASP.NET MVC, AngularJS and MS SQL Server in Microsoft Visual Studio 2022 and Grunt. I want to add one functionality which consists of several pages on, namely, Behavior page with 3 sub tags. Same UI, Same logic, and nothing more! What you should do: - Desing tables for Behavior logic in MS SQL Sever. - Build UI parts using AngularJS (Must follow same principle in the project like naming and componenting while doing this.) - Implement server logic in C# and ASP.NET MVC. You can find the reference here. Also, check the attachment to get confirmed, as well. Please, only apply if you can finish the task using Visual Studio 2022 within 2 weeks. Thanks for your consideration.

...evaluate the percentage that a trade to be successfull studing this different wave and few other parameter like risk reward and hour in the day. I am seeking a top-notch Data Scientist who can confidently apply techniques such as ARIMA, Exponential Smoothing, and various Machine Learning algorithms for a complex time series analysis project. REQUIRED SKILLS: - Proficiency in at least one of these programming languages would be advantageous: Python, R, or SQL. However, the preference is for your demonstrated expertise in time series analysis methods and your capability to deliver high-quality results. - Familiarity with applying ARIMA models, Exponential smoothing techniques, and Machine Learning algorithms to time series analyses. APPLICATION REQUIREMENTS: Thoug...

Estoy creando una aplicación en Visual Basic Acces y tablas Sql Server (aplicación en 3 tiendas conexión WAN) y quisiera asesoramiento y guia para ciertas cuestiones (mejorar código, lectura pesos balanza y codigos de barras que alguna vez se bloquea.

I am in need of a...Administrator (DBA) who can focus primarily on SQL optimization for my project. While the specific tasks were left open, emphasis will be placed on effective SQL optimization to enhance our database operations. * Ideal Skills and Experience - Specialized in SQL optimization - Broad DBA experience - Familiarity with Database Design, Data Backup and Recovery, and Database Performance Tuning would be beneficial Please include your previous experience in your application, especially your experience in SQL optimization and other DBA-related tasks. A proven track record in these areas will significantly increase your chances of being selected. I am looking forward to working with an experienced DBA who can enhance our database&...

I'm seeking a Synapse Expert that will help me to check to data quality of parquet file : number of rows, columns order, data type... It should be done without Spark or Databricks only using sql script in serverless.

We are building a data warehouse which will gather data from different endpoints holding the same database (40+ servers). This data warehouse will live on AWS The data will be sent from the servers to S3 and then processed by AWS Glue The data lives on a SQL server DB on all different servers (schema is the same) We already have the plan laid out, we just need a devops / solutions architect to take the lead Proeficcient on: Batch / Powershell scripting AWS Glue AWS S3 AWS RDS AWS VPC / networking

Backend developer for IoT project --- desarrollador de Backend para proyecto IoT I am looking for a Backend developer for an entrepreneurial project. You also have to develop the mobile application. We are developing an IoT system (similar to an Alarm system but without the "cameras" section) with connections via HTTP, MQTT, Websockets and Wifi. It must be connected to the microcontroller (ESP32) of the device as well as to the user's mobile App. You will receive all the support you need, since we have a general coordinator in the project who will facilitate the correct progress of the different disciplines. We have a completely prepared flow chart, so the job is to start programming immediately. The budget, if it is for backend and App, according to ...

<SQL> SELECT o.sales_order_number AS 'Order', AS Container, t.tag_id AS Tag, IFNULL(, 'ALL') AS Priority, Pickup_Location AS Origin, Delivery_Location AS Destination, DATE(Delivery_Time) AS Delivery_Date, Tender_Time, Pickup_Time, Depart_Time, Arrival_Time, Delivery_Time, Deliver_Driver AS Driver, m.Business_Unit, AS Party_Name FROM summary AS m LEFT JOIN tag AS t ON m.tag_row = LEFT JOIN priority AS p ON = LEFT JOIN shipment_packing AS k ON m.tag_id = LEFT JOIN shipment AS s ON = LEFT JOIN table_order AS o ON s.buy_order = LEFT JOIN business_unit ON CAST(m.business_unit AS SIGNED) = LEFT JOIN party ON = WHERE Deliver_Driver IS NOT NULL and Delivery_Time

We have a parking management system, where sometimes we see 30 vehicle in month get access to no card login, which should not be the case, We need an expert who can access it on share screen and fix it asap. Changes required only in SQL server stored procedures only.

We are looking for a skilled full-stack developer with experience in C# and .NET Core developer to join our team for a stack development project. The ideal candidate should have a strong understanding of both front-end and back-end development, as well as proficiency in C#, .NET Core, SQL Server and Azure Cloud. Skills Required: .NET, C# Programming, Full Stack Development, Azure, SQL Server

Actualmente tenemos este desarrollo para SQL Server, y queremos pasarlo a Postgress son solo 20 end points

I need a person that know VBA. In the attached file you'll find the TAB with input and the TAB with output I need the macro use data from input TAB to automatically generate info on TAB output. I will use output in another software so we have to respect the requested structure of data. If you are able to manage, please contact me

I'm seeking an experienced PHP developer to elevate an existing system's analytic capabilities. Here’s what I need: - Installation and customization of a PHP script, specializing in data reporting, analytics and Bulk Inventory upload Script bought from Codecanyon Ideal Skills: - Proficient with PHP and SQL databases - Prior experience with analytics-related scripts - Understanding of data privacy and security measures - Ability to optimize for performance and scalability Experience Requirements: - Portfolio showcasing past work with PHP, especially in data-centric applications - References or testimonials validating expertise and reliability Freelancers should provide a detailed proposal outlining their approach, timeline, and any suggestions for script improve...

...looking for a talented and dedicated Full Stack Web Developer to join our project. Your responsibilities will be as follows: • Designing the User Interface: Inject your creativity and expertise to assist in creating an engaging and intuitive interface for our platform. • Implementing Server Side Logic: Harness your skills to deliver solid server-side solutions and ensure the functionality of our platform meets the project requirements. • Managing the Database: Utilisation of the Microsoft Database/SQL to effectively manage and organise information on our platform. Ideal Skills and Experience: • Extensive knowledge in HTML, CSS, JavaScript required. • Mastery in Node.js/Express.js, React.js, and Microsoft Database/SQL or other simil...

I'm in immediate need of a skilled Data Science professional to collaborate on various tasks. Here's what I'm looking for: - Mastery in **Python**, **R**, and **SQL** - Comfortable with **data cleaning and preprocessing** - Capable of conducting **statistical analysis** - Experienced with **machine learning modeling** Ideal applicants should demonstrate: - Proven track record with relevant **past work** - Substantial **experience** in similar projects - Ability to craft a **detailed project proposal** Your expertise will play a crucial role in the success of my project. If you possess the skill set mentioned and are available for immediate start, I look forward to your proposal!

I'm in need of a competent web developer skillful in ASP.NET webforms, JavaScript, and familiar with techniques such as Fetch and AJAX. The project involves building a comprehensive hotel management system with a SQL server database. Key functionalities required are: * Booking Management - the system will need to handle a volume exceeding 50 bookings a day efficiently. * Inventory and Room Management - keeping track of hotel supplies and managing room distribtution. * Customer and Account Management - managing customer details and accounts in an organized manner. * API Integration - this is necessary for booking from an external website, the API should provide real-time booking updates and show availability and rates. * website must be RTL. * with Code Source If you ...

I'm looking for developers to stand-up our events and services platform. The application has already been thoroughly designed in Figma, with extensive prototyping and process write-ups. Besides some edge-case frames, the UI/UX is completed. We...UI/UX. We are not creating a new or ground-breaking technology, we are simply consolidating and simplifying existing mechanisms to create a unique and efficient solution. Integrations and API's: - Stripe - Contacts, Calendar, and Location data - SMS/Email/Push notifications required - AWS Hosting (anti-spam, and security features included via AWS) Expected programming experience: - Python - SQL - Mobile application development - AWS certified would be a plus, but we can out-source the hosting management if needed. If intereste...

I'm looking for a highly skilled freelancer to assist me in automating tasks within Microsoft Excel. My goal is to efficiently manage and process basic data and return optimal results as well as a visual. related specifically to manufacturing foam blocks. Ideal Freelancer Skills: - Proficient in Excel VBA and macros - Experience with automation of data tasks - Knowledge of manufacturing industry a plus - Detail-oriented and analytical thinker Project Requirements: - Ensure accurate interpretation of manufacturing data - Generate solutions for rectangular and custom-shaped blocks processing Specific request: We are a foam manufacturing company and we cut foam to size from very large blocks on saws. We typically calculate the size to cut manually on the factory floor ...

I am looking for a Backend Developer with established skills in Node.js, who also had experience in handling both SQL and NoSQL databases. The primary purpose of the project is to fetch Indian market IPO allotment status. What i want is a system where i send users PAN number and it fetches me the data whether IPO is alloted to user or not. I want something similar to narada app Key Responsibilities: - API Integration: Besides strong Node.js skills, experience with API integration is crucial. As most of the data will be served from external sources, fluency in API handling is crucial. - Database Management: The developer should be able to comfortably work with both SQL and NoSQL databases, managing and optimizing data flow as necessary. Ideal candidates will posse...

I am seeking an Excel Macro Expert who can assist me with creating advanced custom formulas. The ideal candidate should have experience in developing complex formulas in Excel. This project does not have a strict deadline, as the timeframe is flexible. Skills and Experience Required: - Proficiency in Excel macros and VBA programming - Strong understanding of advanced formulas in Excel - Ability to automate data entry and generate reports using Excel macros - Attention to detail and ability to deliver accurate and efficient solutions

I require a proficient data entry expert focused on database entry and handling. Key Tasks Include: - Handling data input into the database Ideal Skills: - Proficiency in handling large amounts of data - Skill in using various database systems - Attention to detail and high accuracy - Experience with SQL, NoSQL, or cloud-based databases is highly desirable, but not required. Please apply if you can consistently deliver high-quality work on schedule, and you're open to long-term work updates.

...web developer to create two critical pages for an upcoming web project. Your expertise should align with front-end development and database integration. Here's what I’m looking for: - **Page Design & Functionality:** - First page with a *registration form:* to gather user's personal details, qualifications, and experience. - Second page featuring a *robust search bar:* displaying submitted user details as a table below the search query. - **Database Implementation:** - Efficiently store registration data and allow for easy retrieval during search. - **Skills and Experience Ideal for This Job:** - Proficiency in HTML, CSS, and JavaScript - Backend programming knowledge (PHP, Python, Ruby, etc.) - Database handling (SQL, MongoDB, etc.) - ...

...business requirements documentation (BRD). Familiarity with data quality issues and Exact, Transform, Load (ETL) processes Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques Proven skills in data analysis – including queries to calculate data quality. Solid written, verbal, and analytical skills Strong research and problem determination and solution skills...

I need a reliable freelancer to extract specific user data from website's database that will enable me to contact users for prom...website's database that will enable me to contact users for promotional activities. Requirements: - Retrieve user names, phone numbers, and email addresses from the database. - Ensure data accuracy and integrity. Purpose: - My goal is to use this user data for promoting our latest offers and services. Ideal Skills: - Experienced in database management and data extraction. - Proficient with SQL queries and data mining. - Understanding of data privacy and protection laws. - Excellent attention to detail. Please provide examples of similar projects you've worked on and explain how you will ensure the security of the extracted data. Look...

I am seeking a skilled freelancer to create a captivating 3D odometer effect animation for my project. Here's what I'm envisioning: - Develop a realistic 3D odometer effect. - Ensure the animation is suitable for promotional purposes. Ideal Skills: - Proficiency in 3D animation Using Html, CSS, JS, SQL - Experience in creating animations for marketing and promotion - Ability to animate realistic mechanics and movements - Strong portfolio showcasing 3D animation expertise The final product should be of high quality and delivered in a format that can be easily integrated into various promotional materials. I'm excited to work with a talented animator who can bring this 3D odometer effect to life.

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project: We are developing a financial product including Europe's largest debt exchange and financial forecasting. Main job: - extending and updating the data set while meeting product targets - creating data flow diagrams Skills we are looking for: - Data Science, Big Data, Statistics, Business Analysis - Quantitative and qualitative research - Cartography&MapApps, Spatial data analytics. - Programming (Excel macro, Delphi, SPSS, Python (Jupiter Notebook)) - Statistical analysis - SPSS, Python, Excel. - Business analysis - Forecasts, ML, DSS, SEM. - Databases development (SQL, MySql, Access, VBA). - Data flows schemes Nice to have: - work with financial products nice to have - work with registry data nice to have - social and Marketing...

I'm looking for an experienced Azure professional with expertise in handling SQL Server Database. The main task includes creating a convenient setup on Azure and migrating both text and numeric data from Excel or table into the newly established SQL Server Database. There's no need for pre-processing the data, it can be directly loaded into the database. High familiarity with Power BI for Azure setup is also crucial for this job. Proficiency in data migration and database administration would be ideal for this project.

I'm seeking an experienced MS SQL database administrator to help with important tasks related to database backup and recovery, with a focus on performance tuning. Key Responsibilities: - Performance tuning to achieve significant improvements. - Administer routine monthly database backup and recovery. Required skills and experience: - In-depth understanding of database structure principles - Experience in MS SQL - Previous experience with database backup, recovery, and performance tuning - Solid understanding of SQL server troubleshooting and problem-solving.

I need a MS Access database designed and developed with for a simple task. The backend will be SQL. Here is a brief of the requirements - 1. Query data from the source SQL DB using the search parameter. The SQL query is ready. The parameter value needs to be displayed prominently in all further screens until saved and closed. 2. Show all available line items in the UI and user can select the ones needed for processing. 3. All the selected items will be shown in the next screen for entering data in a few fields. (This can be a table view for easy processing). 4. The selected and edited items need to be saved in a separate SQL DB. 5. Option to search and edit the saved records is needed. 6. User login is also needed. Possibly with the UserID/PW or auto authentic...

I'm searching for a seasoned expert in Microsoft SQL databases to create a perfect backup of my current database. This is not a data migration project nor will it require any data cleansing or de-identification. The key tasks include: - Copying the entire database with its existing structure intact - Ensuring that the newly created backup of the database is a perfect replica The ideal freelancer for this job would be proficient in handling large Microsoft SQL databases and have a proven track record of creating seamless database backups. Your experience and ability to create a flawless backup without any distortions to the structure or loss of data will be crucial for this task.

I am looking for a software developer proficient in Python, JavaScript, and Java. The primary task for the project will be to create a software that can convert HTML output into downloadable Word files. At the backend we use My SQL. Key Responsibilities: - Design and develop a program that accurately transfers text content, images, and tables from HTML to Word documents - Ensure there is no loss of information or image quality during the conversion - Optimize the process for maximum efficiency Ideal Candidate: - Proficient in Python, JavaScript, and Java - Experience with HTML, Word file generation, and conversion tools - Strong understanding and experience of software development and coding - Capacity to meet the deadlines If you believe you are a perfect fit for this ta...

...highly skilled developer with a deep understanding of Bitcoin Ordinals Protocol and a mastery of SQL. The project requires: - Creation of 2 SQL tables (1 for deploys and 1 for mints.) - Each row will extract filtered data relevant to the protocol (eg: "p":"x", "op":"mint", etc) for specific parameters (columns), starting from a specific block #. - Cronjob to add new rows every 10 minutes (new Bitcoin blocks to update tables data - new deploys, new mints or inscriptions ownership change/address owner) - UI with a user address search query, that will reflect the information of the 2 tables related to that address (mints and deploys relevant to the user address.) For the index, you can either use the SQL suggested metho...

I am in need of a skilled developer who can create a React MVC ASP.NET Core application with SQL Server and Entity Framework. The primary purpose of this application will be to import and process cashflow information. Preferred Technology Stack: - React - ASP.NET Core - SQL Server - Entity Framework Specific Features and Functionalities: - Advanced analytics and reporting for cashflow information processing Expected Timeline: - The project is expected to be completed within 4-8 weeks. Skills and Experience Required: - Proficiency in React - Strong knowledge of ASP.NET Core and Entity Framework - Experience working with SQL Server - Familiarity with cashflow information processing and advanced analytics

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project Description: Solve Website Database Connection Error The following errors occurred: SQLSTATE[HY000] [1045] Access denied for user 'root'@'' (using password: NO) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from where table_schema = 'botble_cms' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

Fix problem with /tmp in whm "“MySQL” database “mysql”: 1021 (Disk full (/tmp/#);"

I'm in need of an experienced VBA specialist to create a macro for automating reporting tasks. This project involves: - Crafting a macro for reporting automation - Working with Excel files You would be manipulating multiple sets of data, sourced from Excel, and automating the process for maximum efficiency. Proficiency in VBA and a strong understanding of Excel are crucial for this task. A background in data manipulation and managing complex spreadsheets would be advantageous.

He visto que una carpeta esta dañada y hay que renombrarla.

I'm seeking skilled developers for creation of an interactive, blog-oriented website. The main objective is fostering a community of engaged rea...approved/denied by admin) * Admin Account Management – to moderate content and maintain the blog’s integrity. * Interaction Forum – to foster a community of knowledgeable and engaged readers. *Database to retrieve the blogs from and store account information Competence in website development and a keen eye for user-friendly design is necessary. A strong understanding of blog management systems, SQL, Laravel or other relevant programming languages would be of great benefit. Previous experience in constructing dynamic blog platforms would be highly regarded. Please provide examples of previous work that highlights ...

Preciso de um desenvolvedor para criar um pdv para um erp já existem. Para trabalhar neste projeto você precisa ter familiaridade com essa stack: - Asp.net mvc .NET Framework 4.8 - C# - SQL Server - Entity Framework Adicionalmente você precisa ser capaz de trabalhar dentro de uma VM que será disponibilizada por mim, você vai precisa de uma internet boa e estável para consegui trabalhar. Vou deixar a VM configurada com o projeto pronto para você iniciar o trabalho imediatamente sem se preocupar com o setup do projeto. Aqui segue a referência de PDV que vamos seguir: Abaixo segue o escopo do trabalho com base a referência acima: 1. Lista de vendas realizadas via PDV com: a. Opções de filtro (por data, cliente...