We run an Access/VBA appliation against our MS-SQL server. We're not highly experienced and haven't spent anytime fine tuning the server over the past couple of years. Recently we've noticed a few oddities such as the inability to open rows in the database on the server. We are linked to those tables over an ODBC connection from Access and can
...forms to add employees will be supplied. The employer may change each shift’s start and end times. The employer may change the first day of the week. The schedule should be a copy of the prior week’s schedule. The work week consists of 7 days, 3 shifts. Display, store, and print a single page display showing a schedule for each day of the week, each
...macro. Here are the steps that the user currently has to carry out. I'd like a VBA macro to automate these steps: 1. On the menu bar, go to "Tools," "Add-Ins." Check the boxes for: "Analysis ToolPak," "Analysis ToolPak - VBA," and "Solver Add-in." 2. On the menu bar: go to "Tools,"
I have refined my previous project..Here are the complete details.. I have a Cell C1 continuously calculated from A1-B1 ( A1 and B1 are the cells updated from external links) on my Excel Worksheet..I want to run a VBA script which should monitor the cell C1 and when its value is >2 then it should run the macro... The script should contionuously
I want you to create a function which I can use for formatting input values in an Excel VBA form. The function should: * delete any thousand separator * handle both "." and "," as decimal separator The user should be able to use either "." or "," as decimal separator no matter which setting the computer has. * return a numeric value with 0
this is a project that was allready done by RAC coder which is now suspended and we have some updates needs to be done. We use an excel sheet to track relations between sites we manage. The excel runs a simple and easy crawling method on demand and log the links on a special map view. ## Deliverables the changes needs to be done are minor
...are looking for a software programmer expert in VBA (only for Excel) and the NET environment. You can work from home, 20 hours a week for 12 months. We pay US$400 a month (US$4800 in total). There is room for improvement for productive people. The ideal candidate: - has experience in programming VBA code for Excel and is comfortable with API functions
Please do not post code in reply, my project got cancelled last time :) Right now I have an excel macros that reads a product code and then inserts the product picture into the excel sheet. Only problem is that the picture size is too big and I need to have the script automatically create a thumbnail. ** THE SCRIPT MUST CREATE A THUMBNAIL OF THE
Very Fast Project: Right now I have an excel macros that reads a product code and then inserts the product picture into the excel sheet. Only problem is that the picture size is too big and I need to have the script automatically create a thumbnail. This should be extremely easy for VBA programmers. $10USD Take a look at my current macro (vba
Basically. I'm trying to come up with a VBA code that solves a sudoku puzzle. The Sudoku grid is a 9x9 grid of numbers. The program should also be able to identify if the solution is correct or incorrect. If the solution is incorrect, the exact row or column which contains the error should be highlighted. Also, a separate program should be created that
In my Excel application the user inputs amount through VBA forms and I use a format function to round the amount to max 3 decimals if necessary. The rounding function handles both "." and "," as decimal separator since the users are living in different countries. For some reason I've now seen that I can't use the rounded value in calculations
Hi, We have written code in Excel VBA for inventory production planning. But we have some small problems at with the code. It is a job of maximum 2 hours for someone who knows VBA very well. This job has to be done today and we need to communicate by a messenger to get the job done. Bidding will last for 5 hours! Thanks
I need someone to work on a VBA excel project, that allows me to easily and quickly invest cash into a stock equity portfolio that tracks a well known equity index, for example like the S&P 500. This Excel VBA tool will be known as a Portfolio Optimizer The project involves creating a process that enables me to automate the process of investing
...from all workbooks in a certain directory - collecting data per worksheet - preserving formatting in every worksheet - ensuring that the 255 character limit in excel copy,paste does not cause problems See the attached file for details. The macro is filesgather there is a "unprotectall" macro which removes sheet proctection password ("Secret")
...library. The end result of this project is a professional looking Demo that has the above features. It needs to have sound design and coding style. However, it is not part of this bid to make it a final product. Many of the business requirements are still being worked on. Those will be a seperate project. ## Deliverables 1) Complete
..."Bob") to provide interaction with the user. I do not want dodnet framework. I do not want to use a complex third party graphic library. The end result of this project is a professional looking Demo that has the above features. It needs to have sound design and coding style. However, it is not part of this bid to make it a final product.
Need a vba macro for word 2000 that will search a document and replace all dates in the format of mm/dd/yy with the format of dd-mmmm-yyyy (ie 10/10/06 to 10-october-2006) also need help in creating the button that will be placed on the microsft toolbar so that user can execute this function on a constant basis ## Deliverables 1) Complete and fully-functional
I have a very small MS Access database that I would like an Access/VBA expert to look over, fix problematic relationships, optimize, include a few small features I request, and work with me over AIM to perfect it. I honestly think it will only take about an hour or so of work from someone skilled. Send PM only. Thanks.
Hello, You will see attached exactly what I would like to accomplish. Basically, I would like a macro that adds one cell with the cell next to it, and adding a " - " to seperate the data. If you can create this as an add-in, that would be great. Thanks
i need 4 different things please. FOR TEST DATA GO TO FORM, PARAMETERS TOWNSHIP = CENTER TOWNSHIP CLASS = 500 first when i click the save report buttons in FORM PARAMETERS each WILL generate 2 new tables i need five new columns put into table SAVE_RPT_CLASSNBR_DET and table SAVE_RPT_TWP_DET when i click on save reports buttons the 5 columns are in table MAIN1 they are ...
This small project simply parses a module of VBA text and separates the code into three types of element, comments, keywords and symbols. As you should know comments are colored green, keywords dark blue and symbols black. I want a fragment of code that generates an xml document representing the VBA code. This can then be styled into HTML using a style
1. In my VBA form, see the attached file, the information from two cells is separated with a tab which gives the list a strange look as you can see. I want you to fix this so that the information from the 2nd cell is aligned. 2. In my Excel sheet I have a drop down box which shows values from 1-5 with half intervals. I want to also
The project is to make a Makro bridge between MS Access and MS Word. I have a premade MS Access database, that contains a query with ca 4 fields. The query will return between 1 and 10 records. What this query returns is determent by the MS Access database operater, and will not be included in this project. All that is already done. The output
...and 2 reports. The core is to create 1 form in order to entry data in 2 tables and to print a couple of reports. Only experienced database people need apply (MsAccess and VBA). Desing is important, you can send me examples. This must be completed by next monday morning. Scrowl payment after test (I need 1 day to test after deliver). Please, see attached
I have a VBA form in Excel, see the attached file. I need to extend the calculation functionality. Today it work like this: The user enters a target value, f x 100. The user enters increase in %, f x 10. The application calculates the new value, f x 110. I want you to change this so that the user can enter the new value, f x 110 in
We would like to import Ical events and To-do's to Microsoft Outlook. They would be sent as an attachment on an email to a client. We are looking for a VBscript or VBA extension for a Microsoft Outlook client. The script would be able to process incoming email and check it for the presence of an iCalendar or .ics format file. It would also check that
Looking for a VBA programmer to help with various projects. Other skills of interest include PHP/MySQL, VB.NET, SAS, and any interest/experience in Market Research. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition
Need someone profiecient in MS ACCESS 2003, VBA, & SQL. Need someone who can code manually inputted text in the text boxes of my access DB and store this information in the tables. Also can code the buttons. Please see attached as step-by-step flow is given with screen shots to make it more understandable. The DB is also furnished so you can
...locked cells" option is not checked for each file. I know it can be done but i just dont have the time to attempt this myself. This program should be created in VB6 (or VBA) so i can change things if necessary. However, if the only option to do this is in another programming language i am open to consider it. NOTE: if you dont have excel 2003
...is a need for some kind of sorting. I also want you too check that a new measure really gets saved on the correct object since there is some kind of error in the current VBA code. I don't know if it has to do with the current sorting or if it is something else. I need this done immediately. ## Deliverables 1) Complete and fully-functional
I will provide a detailed scope document with table names, fields, form names, etc. within the next 2 days, but I just need to get a sense of the cost right away. The essence...etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Microsoft Access 2003, VBA
I need a custom Vbulletin skin/style fully designed (uncoded). You do not have to code it but I require a customised postbit and a suitable header. On top of that, it should be visually pleasing. More information is within the attachment. Ask all question before accepting bid
We need a sample application written in Microsoft Access 2000, 2002, or 2003 & VBA code that can access and utilize the eBay SDK. The program only needs to be able to contain sample code to connect to the eBay sandbox and do _**one**_ of the following: 1. A function to demonstrate GetSearchResults and load data into a table, and also demonstrate
I am looking for someone to make the following code that I can use in microsoft excel 2003 sp1. I would like to open .pdf files from within microsoft excel. I am picturing something like a hyperlink. Step 1 High light the text where we want to put the hyperlink. Step 2 Click on .pdf hyperlink button Step 3 Browse to find the .pdf file we want to open then attach it. With the above st...
I Have a MS Access Database. I need to transfer at the push of a button the facility to pre fill...create the presentation on the fly and prefill the relevant areas. It must not link to the original for copy protection reasons. I can provide copies of the presentation and datbase as a guidline. I need you to write the whole presentation in VBA code.
...to the web form and submit the data. There are several third party tools for autofilling web forms are available. Need this functionalitiy to be done through Excel VBA. This needs to be automated using windows scheduler to occur at a specific date/time that can be set from the application by the user. Any comments. ## Deliverables
I have a client that designed a MS Excel VBA project for the enginering industry. He would now like to "lock" the excel sheet to prevent viewing of the source. He would also like to create a system whereby the app requires an activation code before running. This code will then prevent the app from being copied. We also need a keygen app to
...cannot just be replaced as they each contain unique data which takes a long while to recreate. The tool must be written in VBA with no installation required and no dll's required. ## Deliverables 1) Fully functioning tool written in VBA with all code documented and fully commented and explained. 2) Deliverables must be in ready-to-run condition, as
We are looking for a VBA coder who can create macros for Office:mac 2004 to specs. Must be aware of fundamental differences between PC/Mac VB libraries. The "project de résistance" (a little prowess test): write a macro that leafs through all slides of a PPT, selects all embedded text boxes and tables, and changes the language setting as specified by
...files. I would like an Excel 2003 ouput file with one fleet or vehicle per sheet and a distribution of this times (how many occurences per category) as a graph. I need a VBA program fully commented, with an UserGuide Word 2003 document in English. If satisfactory, I will have more developing on the same matters. ## Deliverables 1) Complete
Hi, I need simple, already written MATLAB functions translated into macros using VBA. My boss wanted me to do this, but unfortunately, I only have 3 weeks before I leave this office. I personally do not have the time to learn these two new languages. As a result, if there is a fee, it will be coming out of my own pocket. I need about 10 functions, which
...projects at our company. This has been laid out in excel, but we are looking to create a "prototype" for a more streamlined application. Functionality can either be improved with VBA macro programming, or a .NET application could be developed. If done in .NET, the data tables must be accessibe by me, so if the table would need to be created in Access, but
Have a table where all values are text values, I'd like to copy the table into a new table where text fields with numbers or dates are converted to numbers/date fields so I can perform calculations. The new table is exactly like the original, except that field format is numeric for the the numeric fields. Fields to be converted: Billing amount Remove
...good eye for art & graphics. Second phase requires lots of coding. We have posted a Project Summary on our website at [[login to view URL]] under "Employment." We _do not_ need to build ASP or ASP.net pages to input data. We have an Access/VBA application for that. more about that in the [login to view URL] Employment section. The summary incl...
...request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 1) Complete
Hello, I would like to have a sprea...see any tabs. Also, please include comments that will explain your vba coding. Also, if possible, please prepare the spreadsheet in a way whereby I can use it for another project. Please note that I will not choose a provider nor send payment until I have a proper working copy. Thanks very much to all!!