Query sql server access 2007 vba jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    17,567 query sql server access 2007 vba jobs found, pricing in USD

    I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [login to view URL](LookupValue, LookupRange

    $116 (Avg Bid)
    $116 Avg Bid
    23 bids

    VBA programming for an already prepared excel-folder. See commentary in the attached excel-folder (sheet "ZZZ": A4, B3, C5, E5, F5 and in sheet "aaa" A3)

    $71 (Avg Bid)
    $71 Avg Bid
    18 bids

    Thsi should be easy: I have a file that reads like this: $sql = mysqli_query($con, "SELECT `searchString` FROM `mightyUsersSearch` WHERE `user_id`='$cid' LIMIT 1"); if (mysqli_num_rows($sql) == 0) return 0; .... The output generates the data for the screen shot. Now I want to extend it to several such 'searchstrings' and remove LIMIT

    $19 (Avg Bid)
    $19 Avg Bid
    16 bids

    I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are

    $113 (Avg Bid)
    $113 Avg Bid
    3 bids

    The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces [Back-end] The ability to create multiple...

    $165 (Avg Bid)
    $165 Avg Bid
    17 bids
    MYSQL Query Fix 5 days left

    I have a mysql query I am working on, part of it is correct and part of of it is not. I need help correcting the issue. I can provide sample data and queries. This is the main query in its current state. amtbill column does not sum correctly. I'm sure it is the type of join but I am not sure how to fix. SELECT [login to view URL], [login to view URL]

    $32 (Avg Bid)
    $32 Avg Bid
    21 bids

    Pivot Query with Multi Where clause , Sql Server

    $19 (Avg Bid)
    $19 Avg Bid
    15 bids

    Excel to Mail Merge if certain records selected to print than to mail merge certain records to word. Needs to be automated in vba.

    $106 (Avg Bid)
    $106 Avg Bid
    10 bids

    Here is everythin...video: [login to view URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [login to view URL] Let me know if you have questions, Thanks, Jai

    $95 (Avg Bid)
    $95 Avg Bid
    16 bids

    I have a spreadsheet in excel with a set of macros and buttons written in VBA that i want to convert to google spreadsheets, where macros should be written in Javascript. The file is attached.

    $57 (Avg Bid)
    $57 Avg Bid
    6 bids

    I need you to develop some software for me. I would like this software to be developed for Windows using SQL.

    $14 / hr (Avg Bid)
    $14 / hr Avg Bid
    6 bids

    Currently I am updating my personal program using excel manually. Since i have no knowledge using VBA

    $93 (Avg Bid)
    $93 Avg Bid
    29 bids
    convert excel file to exe 3 days left
    VERIFIED

    convert excel file that contain VBA to exe with password to protect the formula and protect VBA

    $20 (Avg Bid)
    $20 Avg Bid
    20 bids

    Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.

    $29 (Avg Bid)
    $29 Avg Bid
    6 bids

    Want to get done a spreadsheet using Macro and VBA for sending emails via outlook for list of recipients.

    $86 (Avg Bid)
    $86 Avg Bid
    8 bids

    The project is using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really e...using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project.

    $22 (Avg Bid)
    $22 Avg Bid
    8 bids

    Simple 15 minute Excel VBA project. Push a button and it puts a name which is typed in into a list and clears the field for the next name to be input.

    $26 (Avg Bid)
    $26 Avg Bid
    18 bids
    VBA data entry 3 days left
    VERIFIED

    Using VBA and FORM in Excel to build data entry with option buttons. 2 days

    $64 (Avg Bid)
    $64 Avg Bid
    41 bids

    I want to extract some data via PHPmyadmin from a database in a CSV format. only apply if you are an expert and can do this right now. I think its small task and it can be done within 5 min if you understand my requirements. Need to be done on anydesk.

    $15 (Avg Bid)
    $15 Avg Bid
    15 bids
    exel macro and vba 2 days left
    VERIFIED

    I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month file to prepare for next month. Af...

    $46 (Avg Bid)
    $46 Avg Bid
    19 bids

    as like CRM, complete sales solution from customer entry to dispatch

    $99 (Avg Bid)
    $99 Avg Bid
    7 bids

    Need some strong Jquery developer to set over flow issues, already we used horizontal scroll need to set overflow for one sections, will give more details.

    $30 (Avg Bid)
    $30 Avg Bid
    24 bids

    I have some work, in an Excel spreadsheet. Need a quoting system build in excel, using our data base

    $107 (Avg Bid)
    $107 Avg Bid
    35 bids

    Summarising data from table onto new sheets in specific formats. All formulas no VBA.

    $20 (Avg Bid)
    $20 Avg Bid
    22 bids

    I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.

    $169 (Avg Bid)
    $169 Avg Bid
    17 bids

    alter table [login to view URL] if the following cols dont exist add z_rech_code string 10 chars z_suc_msg string 100 chars z_min number like 999999.32 z_warn integer 2 dig default 1 Z_tries integer 2 digit default 0 z_last_topup_date date z_last_topup_run date default is create date z_enabled 0 or 1 z_ussd_1 string up to 100 dig z_ussd_1_return string up to 100 z_ussd_2 string u...

    $196 (Avg Bid)
    $196 Avg Bid
    17 bids
    Modify SQL query to MDX 10 hours left
    VERIFIED

    We have a stored procedure with sql queries , need a person to help us converting it to cube and get the desired output. we have the dimension and measures are in place

    $6 / hr (Avg Bid)
    $6 / hr Avg Bid
    9 bids

    ##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been

    $111 (Avg Bid)
    $111 Avg Bid
    42 bids

    Hi there, My IT person is away on holidays and I need someone to help me with 6 simple queries. Very simple task is to write 6 SQL statements based on a simple data model (4 tables only). Easy for a very good SQL programmer, should take less than 20' of your time! Details of the model and the 6 questions to be shared privately after project approved

    $19 (Avg Bid)
    $19 Avg Bid
    58 bids

    Customers, Agents, Sales, Inventory, Reports, schedule, time in time out .... and more in excel

    $402 (Avg Bid)
    $402 Avg Bid
    45 bids

    Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running

    $36 (Avg Bid)
    $36 Avg Bid
    21 bids

    build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows

    $31 (Avg Bid)
    $31 Avg Bid
    8 bids

    I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File

    $20 / hr (Avg Bid)
    $20 / hr Avg Bid
    38 bids

    Hi friends - I have this syntax that I am attempting to query an API and return data from it. My issue is that when the syntax hits List<IH> ih... line it returns a 500 error. Can someone examine this and let me know what I should do to remedy? private void LoadGrid() { List<IH> IH = new List<IH>(); IH = dal

    $37 (Avg Bid)
    $37 Avg Bid
    13 bids

    I need to get data from target open sites into a spreadsheet. You need to be able yo use excel vba, python or any of the scraping tools. Contact me so that I send the detail urls. Thanks

    $25 (Avg Bid)
    $25 Avg Bid
    46 bids

    NEED SOMEONE TO HELP FIX SQL DATABASE QUERY (Load directions: 610 directions)

    $28 (Avg Bid)
    $28 Avg Bid
    25 bids

    Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followe...

    $73 (Avg Bid)
    $73 Avg Bid
    21 bids

    I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Comments"...

    $1 / hr (Avg Bid)
    $1 / hr Avg Bid
    2 bids

    I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.

    $69 (Avg Bid)
    $69 Avg Bid
    20 bids

    ...need this done soon so please reach out if interested. Thank you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard

    $30 (Avg Bid)
    $30 Avg Bid
    2 bids

    ...1.1 Query/Search - "leaf" View Search History - Live Example: [login to view URL]~%3A=PARA1%24LD&expr=PARA1+AND+PARA2&p_s_PARA2=leaf&p_tagrepl~%3A=PARA2%24COMB&p_op_ALL=AND&a_default=search&a_search=Submit+Query&a_search=Submit+Query

    $22 (Avg Bid)
    $22 Avg Bid
    4 bids

    Advanced VBA needed in 24hrs

    $189 (Avg Bid)
    $189 Avg Bid
    13 bids

    VBA programming, auto graphing and data sourcing needed

    $182 (Avg Bid)
    $182 Avg Bid
    4 bids

    Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks

    $16 (Avg Bid)
    $16 Avg Bid
    31 bids

    Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing

    $134 (Avg Bid)
    $134 Avg Bid
    21 bids

    Please write sql statement to query “total sales of each product for each salesman who had sales on more than 1 product“ check files

    $20 (Avg Bid)
    $20 Avg Bid
    18 bids

    ...iis and hosted in aws and in AURORA db. The scope of work includes running benchmarks tests, analyzing the results and improve the query performance Till acceptable performance level is achieved. This is no simple sql writing job. Need high level expertise in understanding complex queries and rewriting them to improve the performance. Please share

    $528 (Avg Bid)
    $528 Avg Bid
    50 bids

    I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data we need to be manually Changeable and updateab...

    $36 / hr (Avg Bid)
    $36 / hr Avg Bid
    10 bids

    Need to be able to semantically parse queries to classify textual queries into buckets and translate them into actions to perform. More information if we decide to proceed.

    $2241 (Avg Bid)
    $2241 Avg Bid
    7 bids

    I need to make 10 queries on MS-Access, are multitable query. And very important, I have a table with User and password. Need to show information if user and password is valid, if not valid the query not show information. I want to the freelance will connect to my machine to make queries.

    $41 (Avg Bid)
    $41 Avg Bid
    9 bids