Vba code convert access database sql serverdela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I am seeking an experienced web developer to create a detailed Stock Options Analysis website for me. Ideally, you have a solid background in financial web projects and a keen understanding of the stock ma...required. Moreover, I want the site to include the following functionalities: - Real-Time Data Updates: Keep users informed with real-time data on the stocks. - Option Chain Analysis: Equip users to analyze market possibilities. - Portfolio Tracking: Let registered users track their portfolios' performances in one place. - Trading Alerts: Keep users updated with the actionable trading alerts. User access should be limited to registered members only. Therefore, the site should have a user-friendly but secure registration and login facility. Want a similar website as give...

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

$150 USD. Deadline is April 20th, 2024

I'm in search of an experienced translator to convert my novel from French to English. The book is over 100,000 words long, and I would like this task completed within a month. The ideal candidate for this job must: - Be fluent in both French and English, with a strong grasp of the nuances and subtleties of both languages. - Have previous experience translating novels, with a focus on literary translation. - Be able to work within a strict time frame without compromising the quality of the translation. It's crucial that the translator can convey the emotions, tone, and style of the original work accurately in the translated version. I'm looking for someone who is not only linguistically skilled but also has a passion for literature and storytelling. A sample of p...

...group dedicated to the exchange of free items like furniture, clothing, and tools. This group is primarily targeted towards community service groups advertising donations. I aim to quickly grow a Facebook group to 10,000 members, focusing on connecting individuals across the USA who offer free items like furniture, clothing, and tools. Our objective is to foster a community that provides easy access to these resources. Freelancers should use organic traffic strategies to attract members. I'd appreciate a demonstration of your ability to increase group membership. Successful completion of this task will result in a monetary bonus for outstanding performance. Link for facebook group - Key requirements include: - Implementing location-based search

I'm in need of a talented developer who can help me convert my Figma design to a responsive HTML website. The project is on a tight timeline, so I need someone who can start immediately and deliver high-quality results promptly. Requirements: - Proficiency in HTML and CSS - Experience with Figma to HTML conversion - Ability to create a website that is fully compatible with both Chrome and Firefox As the conversion requires an urgent delivery, I'm looking for someone who can commit to timely communication and updates on the project's progress. Please include samples of your previous Figma to HTML work in your proposal.

I'm looking for a talented freelancer with specialized experience in Schneider Electric product lines, particularly Ecostruxure Building Operation (A/C) and ...systems. - Proven ability in system integration. - Familiarity with programming languages and software tools commonly used in building automation. Specifically Ecostruxure Building Operation (A/C): Ecostruxure Security Expert (Card Access):  If you have the necessary skills and experience, I'll be excited to hear from you.

I'm seeking a proficient web developer to create an articulate, business-informed website primed for information dissemination. The website's core functionality would pivot around articles and text-based content delivery - a seamless platform where visitors can easily access, read: The website will be divided into two main sections: Tourism and Sports (Sailing). For both, users are free to navigate, and they have two levels of content viewing. Each subcategory will be divided into different window pages. In the center of the screen between the two main categories, there will be a stylized boat containing two pages (visually clicking inside the boat to "enter loyalty" and outside the boat space to "enter the sea"): Partners will have an icon on the boat...

I'm seeking a highly skilled system administrator capable of installing CloudLinux with LVE and cPanel support on my server. - Purpose: The key goal behind this project is to optimize resource allocation for my server. I intend to host multiple websites on this server, making resource optimization crucial to seamless performance. - Websites: The server will host a diverse range of websites including e-commerce, blogging, and corporate websites. - Volume: The server should comfortably accommodate between 10 to 50 websites simultaneously. The ideal candidate for this project should have strong CloudLinux and cPanel working knowledge. An in-depth understanding of server management, specifically for resource management in high-traffic env...

...not premium. 3. User Authentication: Secure login and registration system for users to access the app. 4. Profile Page: After logging in, users will land on a profile home page which includes: 4.1 Recent Readings: Display recent readings showing the tarot card, the question asked, and a snippet of the response with a 'Read More' button. 4.2 Menu Options: Users can navigate through the menu containing ‘Home’, 'History of Spreads', 'Affiliate Program', 'Contact Us', and 'Sign Out'. 5. Subscription Model: - Free Trials: Users receive three free readings upon registration. - Premium Subscription: Continued access requires purchasing a subscription. Benefits include unlimited readings, access ...

I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I am seeking a knowledgeable AWS specialist to provide server support including the maintenance of an Application Load Balancer. The project also uses Git CD/CI, and support on GIt is required as well. Ideal freelancer skills and experience: - Deep knowledge of AWS services, particularly EC2 and RDS - Experience in setting up and managing Application Load Balancer - Familiarity with Git & CD/CI To make a successful application, please include: - Details of past work experience particularly related to AWS EC2, RDS and load balancer configurations. Looking forward to your applications.

I am looking for a translator to convert a short text from English into Vietnamese. The document is related to the legal and technical field. I need the translation to be accurate and maintain the legal and technical terms. Skills and Experience Required: - Proficiency in both English and Vietnamese - Previous experience translating legal and technical documents - Familiarity with radio terminology is a plus - Attention to detail and accuracy

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

...membership tier (Freemium, Plus, Pro, Premium). Set up subscription plans with varying features and access levels for Investors, Professional Consultants, and other users, (Plus, Pro, Premium). Implement pricing strategies for different subscription tiers based on features and benefits offered. Configure trial periods and promotional offers for new users. Community Forum Development: Integrate a Community Forum feature within the platform using SureMembers. DONE. Customize and matchmaking user profiles (Advanced plugin for profiles?) to include relevant information for startups, scaleups, investors, and professional consultants. Implement user authentication and authorization mechanisms to ensure secure access to the forum. Enable features (Gamipress..) and algorithms (AI...

...subdomains on our website. These subdomains will be dedicated to different client groups: schools, church, events, and portrait. Each subdomain is intended to provide a tailored experience for visitors interested in these specific categories. - Secure Photo Download: The project calls for the implementation of a secure photo download feature. This feature should ensure that our clients are able to access and download their purchased photos with ease, while maintaining the security of our images. - Crop Preview: Prior to downloading the photos, it is imperative to include a crop preview functionality. This will allow our clients to make any necessary adjustments to the composition of their images before finalizing the download. - Single Payment Gateway Integration: The project als...

As a designer, I am looking for someone to create a series of posters and marketing materials. These materials will primarily focus on advertising our products/services to a target audience of young adults. The ideal candidate for this project should: - Have experience in creating modern and minimalist designs. The aesthetics should represent our brand to help di...an understanding of the type of imagery, typography, and color schemes that resonate with this demographic. - Be able to create materials that are not only visually appealing but also effectively communicate the benefits of our products/services. This may involve a mix of visual elements and concise copy. Ultimately, the goal of this project is to create a suite of materials that engage and convert young adults into ...

We are looking for a tester to cooperate with, who will ensure the quality of our online games in the countries of Africa. The person will be responsible for testing online casino games and reporting encountered errors. The projects will be short and may occur irregularly. We will settle accounts for individual projects, but we value collaboration with one committed pers...responsible for testing online casino games and reporting encountered errors. The projects will be short and may occur irregularly. We will settle accounts for individual projects, but we value collaboration with one committed person. The tester should be available to complete a project within 1-2 days. The equipment required to perform the tests includes a smartphone with Android and iOS, as well as access to the...

...create a hybrid mobile application for iOS and Android along with a corresponding Laravel website. This app will function as an online job and vacancy platform. The app will also need to have a same Laravel admin panel to manage the all Android, IOS apps and website easily. Key Functionalities: - Implement User Registration and Login to enable job seekers and employers to create accounts and access the platform - Job Search and Filtering, enabling users to search for jobs based on different criteria - Apply for Jobs feature allowing job seekers to apply directly for the positions they are interested in Additional Features: - Push Notifications are to be integrated into the app to keep users informed about relevant updates - The app will have a Resume Upload and Storage feature...

I require an expert PowerPoint designer with a solid understanding of nursing concepts to create impactful presentations ...nursing education: 1. Anatomy and Physiology 2. Medical and Surgical Nursing 3. Pediatric Nursing More than 50 slides are expected, promptly breaking down complex ideas into digestible, easy-to-understand content. Essential skills for this task include: - Strong familiarity with nursing education - Proficient in creating engaging and pedagogical PowerPoint presentations - Ability to efficiently convert educational content into visually appealing slides - Excellent command over English language A successful completion of this project could lead to more work in the future. Let's ensure that our nursing students are receiving quality education through exc...

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter...

I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tr...the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to implement basic security requirement such as restricted access to webpages, 2 user roles, keeping data secur...

I have some data that requires entry from spreadsheets into a database. I specifically need: - A meticulous professional who understands the importance of data accuracy. - Someone who can efficiently convert the data on these spreadsheets into a structured format suitable for database management. Your responsibilities include: - Transferring data from spreadsheets into our database system while ensuring data integrity. - Performing data cleaning and verification to maintain high quality and accuracy. Ideal candidates will possess: - A proven track record in data entry, especially from spreadsheets. - Experience with database management and understanding of data cleaning and verification. - Strong attention to detail and ability to deliver high-qual...

I need a developer who can convert a PHP-based login page and registration form to Angular, while integrating Google reCAPTCHA for security. Key Requirements: - Converting PHP files to Angular: The current PHP login page and registration form should both be redeveloped using Angular. - Google reCAPTCHA Integration: I need to add the Google reCAPTCHA functionality to the registration page. I have no specific version preference of Angular for this project. A developer with good knowledge of Angular, PHP, and security integrations like Google reCAPTCHA would be ideal for this job. Prior experience in similar projects would be a plus. Please share your relevant experience when bidding for the project.

...will be on S3 -Prepare models to run on sagemaker totally, so that we can do training and testing 100% on sagemaker.-Models are already running on a local computer, but I need to move them to Sagemaker 100%. Data is on S3 already. -You need to configure and prepare Sagemaker from end to end, and teach me how you did it, since I need to replicate it in another system. -I will give you the data and access to AWS Ideal Skills and Experience: - Demonstrated experience in performing similar migrations - Proficiency in Python, R, and Spark languages - Hands-on experience with AWS Sagemaker -AWS is a MUST, -No matter how, we need to have both models up and running on Sagemaker. -You dont need to change, or imrpove the models, they are already good. But maybe you will need to adapt the...

...organic search visibility by optimizing all website pages. - Address any additional aspects that could enhance the site's SEO. My Services Exam: Offers on-demand scheduling for Aviation Radio License exams, available both virtually and in-person. Reprint: I am the sole private provider in Canada for reprinting lost or misplaced licenses, a unique service only otherwise offered by the ministry. Convert: Specifically designed for Indian pilots training in the USA who intend to fly in India, or for Indian students planning to study in the USA, this service provides an alternative to Indian aviation exams. Ideal Skills and Experience: - Proven track record in SEO optimization, specifically with a focus on boosting online visibility. - Strong understanding of content optimizati...

...in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediat...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I am seeking a proficient typist to convert my printed English documents into typed format. Nearly 50 to 100 pages need to be completed. - Tasks: The project involves transcribing printed pages into digital format. All printed documents are in English, and I expect the typed versions to replicate the content accurately. - Skills: A strong command of the English language is parameters. This project requires attention to detail, accuracy, speed, and fluent typing skills. - Experience: Previous experience in copy typing would be an advantage, and familiarization with English written materials should be proven. Bids are open for freelancers who can deliver a top-notch task. Your diligence and expertise are essential to this project's success.

This project calls for a proficient web developer with expertise in setting up a large-scale school fee management system. The platform should support over 500 users and m...for physical transactions. - Automated Fee Calculation: Implement real-time fee computation, enhancing financial accuracy and administrative efficiency. - Detailed Fee Reports: Generate comprehensive reports on fee transactions to aid administrative decisions and keep accurate historic records. Furthermore, the system needs to incorporate specific security measures, including role-based user access, to ensure the privacy and safety of user data. The ideal candidate for this project will have significant experience in web development, online payment systems, financial calculations, report generation and data...

I am seeking an enthralling research paper that navigates the moral standards of the Ming Dynasty through an in-depth analysis of the erotic stories found in "San Yan." The venture calls for extensive reading and comprehensive understanding of specific historical texts and scholarly articles or books, that will extensi...specific historical texts and scholarly articles or books, that will extensively and persuasively illustrate and support the analysis. Ideal candidates should possess: - Profound knowledge of Ming Dynasty's history, culture, and moral standards - Excellent research and analytical skills - Competence in crafting engaging research papers - A strong understanding and familiarity with "San Yan" - Access to and ability to interpret relevant h...

Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel

...8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * D...

WordPress developer with experience in developing Simple Job Boards by Press Tiger. I have purchased two add-ons which allows fo...they fill out a contact form, attach a CV and send it direct to the recruiter without any of the applicants’ details being saved on the server. (the add-on should do part of this) As a recruiter: - The recruiter can access the back end, manage their own job posts, and receive to their emails only As the administrator: - I am developing the one Word Press Site () with many recruiters adding their job posts (search by country or category) - Each country has its own landing page (e.g. ) with a simple job board, which each country manager should be able to manage their job posts. skills: Simple Job Board short code WP

I'm looking for an experienced cloud engineer who can resolve a server downtime issue I'm experiencing with my OVH Public Cloud. Key Responsibilities: - Analyze and troubleshoot the root cause downtime - Implement a robust solution to prevent future occurrences - Ensure that during downtime, website and database access functionality is restored promptly Ideal Skills and Experience: - Proven expertise in OVH Public Cloud management - Strong troubleshooting and problem-solving skills - Understanding of website and database access best practices - Excellent communication and teamwork abilities I'm open to suggestions on how we can best approach and solve this issue, so if you have ideas, I'd love to hear them.

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I am looking to create a traditional style loft or bonus room above our existing attic with a convenient access staircase. The intended purpose of the room is as an entertainment area. Although no specific amenities were selected, ideas, suggestions and recommendations are welcome to make it a lavish space for entertainment. Ideally, freelancers should have experience in structural remodeling and interior design, with a keen eye for traditional aesthetics. Skills in carpentry, interior design and construction are definitely a plus.

...Title: Freelancer Needed to Build Crypto Host Platform for Bitcoin Transactions** **Project Overview:** We are seeking a skilled freelancer to build a Crypto Host platform specifically designed to handle Bitcoin (BTC) transactions. The platform will facilitate the secure storage, management, and distribution of BTC funds, allowing users to connect their wallets, initiate automatic payments, and convert funds into USDT or other cryptocurrencies. **Project Details:** - Develop a Crypto Host platform with robust support for Bitcoin (BTC) transactions, including wallet integration, automatic payment setup, and currency conversion functionalities. - Implement advanced security measures to protect users' BTC funds and personal information, ensuring compliance with industry best ...

I need a Python code developed for vehicle route optimization. - The code should include 3 algorithms for route optimization. - Successful freelancers should include past work in the application. Ideal Skills: - Proficiency in Python - Experience in developing route optimization algorithms - Strong background in data analysis, web scraping, and machine learning, as these functionalities will be required in the project.

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...

...be multi-faceted, with the capability to track referrals, assign rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce syst...

I'm in need of a skilled individual who can convert a Word document into a professional and corporate styled PowerPoint presentation. The project would require: - Incorporation of photographs as the primary visual accompaniment to text content - A keen eye for design to ensure the layout is clean, minimal yet professional - Understanding of the purpose, which is to inform and update The ideal freelancer should have ample experience in PowerPoint design, understand corporate branding, and have an appreciation for accurate content representation. Proficiency in integrating visuals and text is key and previous experience in similar projects would be an added advantage.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...