Access vba change update querymunkák
SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...
Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.
Egy excel alapú bevételező, raktárkezelő és receptúrázó "alkalmazást" kellene Accessre ültetni, nemi fejlesztéssel (vélhetően Form és VB macro)
I have a WordPress-Avada website, I need to optimize the loading speed. I need to fix it or make specific suggestions on what to change, either on the server side or on the hosting or site. Website:
Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...
...rn1. MS Access/ SQL programozasra vonatkozo feladat rnrnAlabb belinkelt PHP-ban irott script-er at tudja-e inri MS Access-be, vagy SQL-be.rnFuncioja nagyjabol a kovetkezo: megnezi, hogy adatbazisban adott nyelven talalhato szohoz van-e letoltve kiejtes, es ha nincs, akkor GoogleTranslate-bol letolti hangfajl formatumban egy adott konyvtarba.rnMennyi idobe kerulne egy ilyen program megirasa? rn(Egyelore az elvi lehetosege es a kapcsolodo dijazasa erdekel. Pontos specifikalasara kesobb kerulne sor.)rnrnrn(Csak az elso fele, elso script erdekes. Masodik jelen pillanatban nem.)rnrn2. MS Access-ben programozasrnrnAlapvetoen ugy gondolkoztam, hogy MS Access-ben megcsinalom
NO PLACEHOLDER BIDS! I am looking for a freelancer who can set up a perfect system for me to maintain wordpress sites. Existing plugins can of course be used. Requirements: - Automated updates of plugins and CMS of Wordpress pages after connection - Automatic backups of websites before updates. It is important that the websites do not have access to each other's backups. - Automatic uptime check - Automatic malware check (if possible, e.g. by Ninja Firewall) We currently use MainWP and also have Pro versions for this. Likewise for BackWPUp. It is important to me that the freelancer has experience with this and provides me with precise solution proposals.
...academic journey. Yet, without financial assistance, their dreams of receiving a quality education may remain out of reach. Your support will directly impact the lives of these three children by covering their school fees, purchasing essential supplies, uniforms, and ensuring they have access to a conducive learning environment. By investing in their education, we're not just providing them with knowledge; we're empowering them to break free from the cycle of poverty, build brighter futures, and become agents of change in their communities. Together, we can make a tangible difference in the lives of Alice, Ben, Emma, and countless other children across Uganda who deserve the chance to thrive. Your generosity will not only transform individual lives but also con...
I'm in need of a developer who can help me integrate my Patreon page with my Discourse community to give my Patreon members access to exclusive content on my Discourse forum. The main goal of this project is to make my Patreon page and Discourse forum work seamlessly together, so that my Patreon members can get the most out of their patronage by engaging in exclusive discussions, sharing information and building a stronger sense of community. Ideal skills for this job would include familiarity with the Patreon and Discourse APIs, and a strong understanding of how to build and troubleshoot these kinds of integrations.
Professional Slide Layout Update
I am seeking a proficient photo editor to accurately insert a person from a given photo into a distinct group photo. I require precise merging skills to blend the person naturally into the intended image. Specifics Include: - I do possess both the images that need to be worked upon. - The critical change is to incorporate an individual from one picture into a group photo in an unnoticeable and flawless technique. - I want the person from the first image to be precisely positioned next to a specific individual in the group photograph. The ideal freelancer for this project must have extensive experience in photoshop or equivalent photo editing software, a keen eye for detail, and a strong understanding of lighting and shading to match the added person within the group setting. Addi...
Skills required Front-end: React or Angu...OAuth for handling secure authentication with streaming services. Technical Requirements and Development 1. Secure Authentication: Implement OAuth or a similar secure authentication protocol to allow users to log into their streaming services without storing their credentials. 2. Device Management: Develop a system to manage devices that can stream content, ensuring only authorized users can access the services during their stay. 3. Session Management: Ensure that user sessions are automatically ended upon checkout, or provide a simple way for users to log out when they are done watching. 4. Privacy and Security: Since the app will handle sensitive login information, ensure that the data is protected through encryption and secure network ...
...incorporating into the app. We need to make sure that the app is robust and capable of preventing unauthorized shutdowns of the device. - Provide customers with quick settings: The app should also have a user-friendly, accessible quick settings menu. This should include battery status, Wi-Fi settings, Bluetooth settings - essentially, everything that can be considered essential for quick and easy access. Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with anti-theft features in apps - Strong UI/UX design skills - Knowledge of mobile device security best practices - Ability to create a user-friendly quick settings menu The project is at an advanced stage and we need someone who can quickly understand the existing codebase ...
... The website should be visually appealing, easy to navigate, and optimized for search engines to help increase visibility. - A clean, modern design that aligns with my brand's identity. - Intuitive navigation structure to help users find information quickly. - Responsive design to ensure the website looks great on all devices. - Content Management System (CMS) integration to easily manage and update content. - Search Engine Optimization (SEO) to enhance online presence and attract more traffic. - E-commerce functionality, if required, to sell products or services online. - Social media integration to connect with my audience on different platforms. - Analytics setup to track website performance and user engagement. Ideal candidates should have a robust portfolio showcasing...
As the owner of an already active and functional Shopify website, I am in need of an expert to bring a fresh wave of updates to the site. Your task will encompass a wide range of revamps including: - Design Changes: I want my website to be attractive and user-friendly. Therefore, the design needs an update, especially on the product pages, which will be your main concern. - Functionality Improvements: The site should be fluid, and navigation must be effortless. Hence, updating the navigation layout is priority. - Content Updates: The descriptions for the product pages need a boost to maximize optimization. This is pivotal for the success of the site. The ideal candidate for this project should have substantial experience with Shopify interfaces, SEO optimization, usability princi...
I need a PHP script to update an existing PDF file with data from a form. - The purpose is to update information in the PDF file, not generate new ones. - The edited PDF will be displayed once, not saved for future reference. - The data that I'll be entering into the form is a bit more complex than just text. It includes text, images, tables, etc. The ideal freelancer for this project should have: - Strong understanding of PHP. - Experience with PDF manipulation in PHP. - Ability to work with various data types in PDFs. - Attention to detail to ensure the PDF retains its original style, font, spacing, etc.
...regular checks to ensure the website's smooth operation. Identify, troubleshoot, and resolve technical issues promptly. Perform routine backups and security updates to protect the site from vulnerabilities. Content Updates: Update site content, including text, images, and multimedia, to keep it fresh and engaging. Collaborate with content creators to ensure accuracy and relevance. Implement SEO best practices to enhance site visibility and traffic. Plugin Management: Advise on the selection and installation of WordPress plugins to enhance site functionality. Regularly update and manage plugins to ensure compatibility and performance. Monitor plugin performance and troubleshoot any issues that arise. Qualifications: Proven experience in managing and maintaining Word...
I have a black-colored, cotton garment that I want to change to white. I'm looking for an experienced professional who can accomplish this without damaging the item's quality and texture. The ideal freelancer will have prior experience with fabric dyeing, color theory, and material handling. Knowledge of best practices for color transition for cotton materials is a must.
I'm in need of an experienced UI/UX designer for my website. The website serves as a platform for providing information and needs to have a user-friendly navigation and layout. Requirements: - Proficiency in website UI/UX design - Able to integrate a smooth sign-up/login process - D...Experience in creating user interfaces for other informational websites - Strong understanding of information architecture - Able to create accessible, user-friendly designs with a focus on user experience - Previous experience integrating GPS tracking and chat/message functions The designer I'm looking for must value user-centered design principles and be able to make complex information easy to access and understand. I put a high value on clean, attractive design and want someone who...
((( We don't have much time, we only have one day now. and my budget is 25 LAST)))I won't respond to any bids unnecessarily. Second, you will only bid when you have applied my complete requirements to your localhost and have the project ready. Complete the work and then bid. Writing that I did it and , I will understand. Then I will understand and give login access you to my hosting, and your job and its price will be fixed at $25. I won't reply to anyone's bid; I've already wasted a lot of time. Whoever wants to work can create the same product page on their own and bid. I'll talk then, otherwise not. I'm looking for a skilled WordPress developer : I only need one page. It must have a product that functions like this one:
...of which are currently yellow, and I need them to be transformed into Red, Blue, and many more variants. This project is straightforward for someone who is proficient in using the Hue/Saturation filter in Adobe Photoshop. Scope of Work: - Your task is to change the color of these products to given color, ensuring that the new colors look natural and appealing. - I will provide one reference image with the exact colors I desire. You will use this reference to match the colors accurately in the other images. The main objective is to update the color scheme of our products. The new color scheme will be essential in our rebranding process, helping us to align our products with the new brand identity. Ideal Skills: - Extensive experience with Photoshop, particularly with th...
...of this project. - **Role-based Access Control**: I want the dashboard to have role-based access control. This means that users will have different levels of access based on their roles within the organization. Your responsibilities will include the following: - **Data Retrieval and Manipulation**: You will be tasked with retrieving data from a database and manipulating it to be displayed in a meaningful way. - **User Authentication and Authorization**: A key part of this project is ensuring that the dashboard is secure. You will need to implement a robust user authentication and authorization system. In summary, I'm looking for a PHP developer with experience in building custom admin dashboards, data visualization, user management, and role-based access...
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more...
...me get it back online as soon as possible. Key Tasks: - Diagnose the issue: I need you to identify the root cause of the website being offline, which I believe is due to the recent hosting provider change. - Implement a quick fix: Once the problem is pinpointed, I need you to apply an immediate solution to get the site live again. - Ensure smooth transition: I would also like your expertise in ensuring that the hosting provider change doesn't disrupt the normal functioning of the website in the future. Access Details: I can provide you with the WordPress admin access and hosting account access to help you resolve the issue. Ideal Skills and Experience: - Extensive experience working with WordPress websites. - Proven track record in resolving u...
My small computer remote fix and need logo. I repair windows computer only remote access and via phone.
I'm looking for a skilled Laravel developer to help me with maintenance tasks and add new features to my current project. I am seeking a senior-level Laravel developer to construct new modules, update existing code, and address bugs on a regular basis. The developer must be available and promptly address feedback. Key Tasks: - Update existing code to ensure the project runs smoothly - Address any bugs that may exist in the code What's Needed: - Solid experience in Laravel development - The ability to identify and fix issues in a timely manner Ideal Skills: - Strong knowledge of PHP and Laravel - Experience with database optimization - Familiarity with debugging and finding and addressing bugs Skills Required: PHP Laravel HTML API Integration JavaScript We�...
Hi there, We are a travel agency looking for an expert in API integration to answer the following questions: Is it possible to connect and our own booking system to check and update automatically accommodation availability, rating, pricing and meals within our internal booking system? It should take into consideration a radius of 5-10km from a certain city point. Our own booking engine works automatically as follows, it sends a booking request to the accommodations on a certain accommodation list (from the first to the last one on that list) following a rule: if the first accommodation on the list denies our booking request, automatically the request will be sent to the second on the list, and so on. What will the requirements?
We are looking for a skilled WordPress dev...research and learning new things to overcome challenges • Conducting website performance tests • Monitoring the performance of the live website • Experience optimizing web pages and improving page speed • Collaborate with internal teams to produce software design and architecture • Write clean, scalable code using NET programming languages • Test and deploy applications and systems • Revise, update, refactor and debug code • Improve existing software • Serve as an expert on applications and provide technical support • Designing and managing the website back-end including database and server integration • Generating WordPress themes and plugins Payment will decided based on ...
I need a specialist in server maintenance and troubleshooting, particularly for my Dedicated Linux Server Level 2 Strato. The key tasks required are: - Recovery: I need help with server recovery, the ability to troubleshoot and restore the server in case of failure. - Update: Keeping the server software up-to-date is crucial for security and compatibility. I need a specialist to handle the server updates effectively. Ideal skills for this job include: - Strong expertise in Linux server administration and management. - Proven experience with server recovery procedures. - Proficiency in updating server software without causing disruptions. - Strato dedicated server recovery - Operating system Ubuntu 16.04 LTS 64bit + Plesk Onyx (unsupported) - Ubuntu is outdated therefore weI cant ...
The project is the automation of the process of downloading information from the page, organising the data, and include it in a normalised format specified in an Excel file. Duplicate records should be removed and uploaded to a shared repository. The instance of the software and the repository should be in AWS. It needs a user friendly run option. The scope of the service includes the configuration of a repository in a AWS, set-up a remote desktop , delivery of the source code with good development practices. Additionally to the neighbourhoods added in the file, the scraper mus include: Zone 2: Gran america Centro nariño Centro narino Puente aranda El recuerdo La florida occidental Quinta paredes Industrial centenario Plaza Imperial Centro Comercial Paramericano Las america...
...and promoting monthly influencer events -Engagement and Community Building: -Engage with followers and respond to comments and messages. -Organize and manage giveaways for followers Research and Analysis: -Conduct research on digital beauty trends and skincare ingredients. -Monitor and report on social media analytics to measure the impact and adjust strategies accordingly. -Shopify Management: -Update and manage product listings on Shopify. -Assist with order processing and customer inquiries. Requirements: -Proven experience as a Virtual Assistant or relevant role. -Proficiency in using ChatGPT for content creation and customer engagement. -Strong knowledge of Shopify and its functionalities. -Excellent research skills and the ability to stay up-to-date with industry trends. ...
I'm seeking an expert in ZHHE-CAD software. We have a simple pattern file we would like to import into the ZHHE-CAD software. Please let me know if you believe you can help us and if you have the specific CAD software.
...tasks within the organisation, with defined states, assigned responsibilities, and status updates for the reporter. Additionally, it should include a Business Intelligence (BI) panel with detailed statistics on generated and managed reports. User Interface (UI) Report Form: An intuitive interface for reporters to submit their reports anonymously or with personal details. Reporter Portal: Access for reporters to track the status of their report using a unique code. Task Management for Reports Task States: Each report should go through various states (e.g., Received, Under Review, Under Investigation, Concluded). Assignment of Responsibilities: Ability to assign responsible parties for each state or stage of the report. Notifications: Automatic notifications to the rep...
...skilled writer to create a thorough and compelling 1000-word essay regarding the history of human colonization in the Pacific. - Topical Focus: This essay should concentrate specifically on the story of how humans came to colonize the Pacific, delving into the unique historical context and unfolding events. - Research Resources: Bids are highly encouraged from freelancers who have considerable access to, or are comfortable in using academic journals and historical books as the main resources for the project. - Ideal Skills: Strong writing skills are obviously a must, but a background in history or anthropology would also be beneficial for this project. A keen understanding and appreciation of Pacific cultures and their history is essential. - Experience: A proficient w...
I'm looking to update my website on a budget and quickly to make it look more modern and appealing to potential clients. I'm having trouble getting the containers to extend from edge to edge, so I'm hoping someone can help me achieve that. If you're interested in working on this project, let's chat and see how we can elevate the site even further in the future. Thanks for your time!
...be similar to the following websites: and Key Requirements: Frontend Development: Expertise in to build a responsive, user-friendly interface. Backend Development: Proficiency in Node.js for developing robust APIs. Admin Dashboard: Creation of an admin dashboard similar to WordPress, enabling our team to easily manage and update the content of pages and itineraries of tour packages. SAAS Integration: Knowledge of building SAAS applications and connecting them with brokers through APIs. Design: - I already have a theme in mind. It is the "ghurbo theme" which is a combination of {client's description of the theme}. Deliverables: Fully functional travel and tourism website with frontend built in and backend
Login redirect issue and access right not working. Able to work with ftp only
I need an experienced Figma designer to update our current design for dev mode. Dev mode depends upon scaling and pixelations. you would need to: - Audit each page component wise to review improvements. - Clean up and organize layers in heirarchical order. - Adjust equal spacing. - Use Auto layouts for responsive components. - set up guide with palettes and typography and space rules. - Use figma precision tool for alignment. - aprovide margin, padding and css using figma built in tool as dev mode setup If you have experience with jinja2 it is a big plus as we want to transfer all components from figma to jinja2. The job must be completed this week and is expected to take a skilled figma expert with experience optimizing for dev mode about 20 hours to complete. There will be mor...
I'm looking for a skilled web designer to revamp the current user interface of my website. The primary focus of this project is to improve the overall user experience. The key areas of the website that need to be redesigned include the layout and navigation. In terms of specific functionalities, I am looking to incorporate a sticky navigation bar for easy access. Key points: - Redesign the layout and navigation of the website - Implement a sticky navigation bar to improve user experience - Focus on enhancing the overall usability and accessibility of the site Ideal skills and experience for this job include: - Proven experience in UI/UX design, particularly for websites - Strong understanding of modern web design principles and best practices - Proficiency in relevant design ...
...Setup:** Setting up email services on the server for my domain. I will provide you with root access to the server, so you should be well-versed in security practices and able to handle the responsibilities that come with that level of access. Ideal candidates should have: - Extensive experience in managing Cpanel and WHM - Strong knowledge of DNS configuration and management - Proficiency in setting up email services - The ability to work with root level access securely and responsibly. Issue: This system does not control DNS for the “” domain. You can install the suggested “DKIM” record locally. However, this server is not the authoritative nameserver. If you install this record, this change will not be effective. Contact the p...
I'm interested in purchasing apps that have been released on the Google platform. I'm looking for apps that fall into categories such as entertainment, games, tools, movie...- Social media integration to help users share their experiences and invite others to use the app. The specific functionalities I seek include: - User profiles for personalized experience. - A robust search functionality for easy navigation. - Video streaming feature to broadcast various contents. - Different levels for games to keep users engaged and challenged. - Categorized tools for easy access and utilization. Ideal freelancers for this project should have experience in app development and understand the Google platform well. They should be able to provide unique and engaging apps that meet the...
...submission. • Admin Dashboard: • Secure login for administrators. • Interface to view, update, and manage user submissions and their statuses. • Whats App Chat Integration: • Interface for WhatsApp chat widget for customer support. • Accessible on all relevant pages. Backend Development 1. Authentication: • Implement secure user authentication using JWT (JSON Web Tokens) or OAuth. • User registration, login, and password management. 2. Payment Processing: • Integrate with a payment gateway (e.g., Stripe, PayPal). • Implement APIs to handle payment transactions, process payments, and manage payment statuses. 3. Document Management: • API for users to upload documents. • Secure storage of documents. • API for admins t...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone b...to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine
...webpage. This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and experience for the job: - Proficiency in Laravel and PHP - Experience with database setup, management...
I am in search of a skilled developer to create a web dashboard using Python with Django framework. The purpose of the dashboard is to monitor a specific service. Admin can create new services or update / delete Ability to add commands to start a service if it crashes by using the commands and notify on successful execution. As well as provide web dashboard for visibility . If this service crashes, the dashboard should send notifications via email and then restart the service. Key Requirements: - Develop a Python-based web dashboard using the Django framework. - Implement a monitor for a specific service. - Configure email notifications to be sent out to a designated email address upon service crash. - Enable the dashboard to automatically restart the service upon crash. Your...
I require assistance in viewing and downloading a few specific files from a different computer. Key Details: - The files that need to be accessed and downloaded are primarily documents and payment transfer proofs. - The method of access and download should be via a secure file transfer service. - Security is important. Therefore, the transfer should be password protected. Ideal Skills and Experience: - Proficiency in using remote file access and download tools. - Understanding of secure file transfer methods and experience with password protection. - Keen attention to detail, ensuring that the right files are identified and downloaded. (Images is for illustration purpose only) Name of real recipient will be told.
...is completed. This should include the date of completion and the name of the person who performed the task. Notes or Observations: Provide space for recording any observations or notes related to the maintenance tasks. This could include issues encountered, parts replaced, or recommendations for future maintenance. Flexibility: Ensure that the listing is flexible and easy to update as maintenance requirements change. You may need to add new equipment or adjust maintenance frequencies based on operational needs. Documentation and Resources: Include references to any documentation or resources needed to perform the maintenance tasks effectively. This could include equipment manuals, maintenance procedures, or safety guidelines. Review and Revision: Regularly review and r...
