...automate the process to upload an excel Template. I want this driven by buttons... from a userform or sim to. The users are not Access intelligent. So need to make this easy for them. I want to upload from a Template, verify the data from the template aligns to the fields in the table. IT IS EXTREMELY IMPORTANT that the data goes into the correct fields
Create a userform to automatically save down a template. Must create 2 lines from 1 entry. only difference is Col J one line must have receive or deliver short, second line receiver or deliver long. receiver or deliver is chosen by the option box. The highlighted cells are the entries that will be filled in. the rest is prefilled including the date
I have a Macro that I use and works well, it finds duplicate words in a cell and puts them in the next cell so I can edit so if the cell had big red dog with big collar ------ it would put ---- big big in next cell but if it was big, red dog with big collar then it sees big, with the comma as a separate word there may also be other characters causing issues but so far only seen comma, so pro...
Create a VBA application in Excel to help automate the business or organisational process you have decided to address, which must: 1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. 2. Demonstrate the key programming skills expected
I'm building an interactive excel tracker for [đăng nhập để xem URL] is movement based on day count and selection from Listboxes. Most of the code is done on this workbook, but I am self taught and need some assistance with the more advanced code. 1. Initially I set Column A on the Status tab to equal column A of another sheet. Now, I need Column A on
I would need help creating a Com add in for Visio that would work as a userform where u can fill data. The code would need to be accesable since we will do more changes to it later and add other processes to it. Is this something you could do ? this is only the begining alot more things could be added to this later on
I would need help creating a Com add in for Visio that would work as a userform where u can fill in the data in the attached image. The code would need to be accesable since we will do more changes to it later and add other processes to it. Is this something you could do ? this is only the begining alot more things could be added to this later on
...I'd like to create a tool (possibly Excel or whatever you think is best) that uploads the data from the template sheet into Access and checks for duplicates as it updates. If there are duplicates it should ignore them but continue to upload the non-duplicates. Next, I'd like there to be a way to query this data from Access into neat reports, summarizing
The creator of this file does not include your name or your company name. File coding should be good at the time of running this file, there should not be any problem in this file should be just the name of our company. Company: - Computer World Frist [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions]
I have a word template with multiple locations that are required to be updated, for example, client name, project name, proposal number, etc. We have developed a basic userform with bookmarks, however after filling out the form, it doesn’t allow for any changes. The word document is about 10 pages long, and approx 10 fields required. Need a simple
• Capacidade de captar dados através de um formulário (UserForm), contendo os tópicos: o Dados básicos e histórico social; o Farmacologia atual e sua adesão; o Problemas relacionados a farmacoterapia atual; o Avaliação do tratamento. • Capacidade de armazenar os dados em abas com formato de banco de dados, com, no míni...
...I would also like to use a userform to type in the titelblock informations. Also there should be a button for either starting the script or cancel. I already named the textforms in the AI-file so you should easy access them through the script. Step one The informations in the titelblock need to be filled with a userform. Step two The file will be
... I use this document many times a day with different data so filling the fields in manually is not an option. I need someone who can use Visual Basic in MS Word to create a document that has a userform in that will pre populate the information that I require. To show you what I mean by userform please watch this video of someone doing something similar
I have an already built VBA macro using UserForm. I need to do some cosmetic changes. I need the count of records in the Supply section and it needs to be a link, once clilcked, should display the same in an already existing listbox.
...***RANDOM BIDDERS WILL BE REPORTED AND DELETED**** Access 2007 sort out the ability for a user to select a supplier from another table of data and add into a single field of a purchase order Please provide a written instruction as to how we can do this we CANNOT send out the database due to data protection We have a form called frm SubContractors, linked
We are trying to SETUP a server backup opetation and we get this error "a fatal error has occurred during a windows server backup snap-in operation" We need somebody to solve this problem and create an inceremental backup job Payment after Project Completion
My delphi 2007 ide which is running on a virtual machine has suddenly stopped working and throws exception errors constantly. I need a delphi expert to look at this and repair the issue. It is running os a windows 7 virtual machine on parallels on mac osx
Hi Balint K., I noticed your profile and would like to offer you my project. I have a excel workbook. With a VBA userform data is inputed into a master table. Additionally I also wanted it to copy that input to diferente sheets depending on one criteria (like master table all inputs, then if is about car also copies to car sheet but if is motorbike
I am looking for an individua...a period of 2-4 months. The successful candidate will work with me on a delphi / mysql project. You will have a very good command of english and good experience in Delphi 2007, mysql and php. You will need to work quickly and accurately writing and testing procedures, creating mysql queries and developing a php api.
I have this worksheet with dates in column B, and name in row 1 and sub headings in row 2. I have set up this userform, so the user can select a name, choose a training and date, then upon enter button the type of training will show on that date. However I am now stuck on how to locate the specific cell with the name selected and locate it to the training
Exchange 2007 on SBS2008 (both in German) with several issues (Autodiscovery not returning any account data) which is why a simple cutover migration is not possible. In a first step, the local configuration needs to be sorted out (DNS, Exchange and IIS config, in particular) so that an endpoint migration can be done. This task is urgent. Please only
I need someone to create an Excel staff training database. I have been following a tutorial ([đăng nhập để xem URL]) Please see video for the functionality i am looking for [đăng nhập để xem URL] I have already created a workbook and a User Form in Visual Basic, but i cant program
Problem/Challenge: I have all the questions in MS Word format. Currently there are 2 options available to upload these questions from MS Word to MYSQL – 1) Upload one question at a time via an html form. Have to manually copy paste the question, all the answers and any images in the question. Takes 1-2 minutes per question 2) Upload via a CSV file by populating all the fields but we have ...
Actualmente tenemos tres aplicaciones de escritorio desarrolladas en Delphi 2007 que hace envío de correos, pero ahora que vamos a cambiar de servidor de correo necesitamos modificar la clase de envío de correos para que use SSL ya que para envío de correo a través de office 365 es necesario, además de modificar la clase si es necesario habría que
...automate an excel file for reporting purpose. Currently I do it manually and bits and pieces of automation which I have recorded macro, it was working fine till I had to do conditional formatting for duplicates and delete column 1 data based on duplicates. I have attached a dummy data file for your reference, when I receive the raw data, it consists
Please download the attached MS Access database and perform the following. 1. Open the Item form, and observe the slider control in the sub form 2. When the slider is adjusted, please set 'TestValue' to the range between 'Minimum' and 'Maximum', assign to the slider's tool tip. 3. If the parent form's 'AutoUpdate' is checked while the 'TestVa...
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
...backend data using linked tables. * Front and backend running MDB file format. * Backend data existing as 6x MDB files (+ Design Master) - 2 at each physical site (live data and syncing hub). * Backend database size approx 350Mb. * Backend data compacted and repaired on a bi-weekly basis (during manual sync) * Running environment Office 2007 (for
I need some help with selling something.
I need to transfer some documents from the old form to our new form some of them is a photo in pdf form or word document the output must be in word 2007 doc and formatted to our new form. I included zip file including our empty form a filled document in our new form and pdf document to be transferred
Have written a code for a user form to automatically add information (delivery details) into a database, however code only currently works if all the boxes in the userform are filled, need this corrected so that form will work regardless of whether all the boxes on the form are filled or not.
1. Maintain page size A4 and margin left and right margin as 1.5” with top and bottom margin 1.0” header, footer & gutter 0”, page zooming 100%. 2. Maintain Header/footer Size 10 in times new roman. 3. Heading font Time’s new roman-bold size 16, sub heading font time’s new roman size 14, general text times new roman size 12. 4. The font to be used in times roma...
Need a userform made to allow data to be entered into worksheet. The worksheet already contains dates so the code needs to be able to match the date entered in the userform to that in the worksheet and put in the userform data which corresponds to that date
Hi, I recently started learning VBA and need some help with some code. I have around 16 columns of data, that needs to be filled in with a help of a User Form. I came so far that I have created the userform and can fill out all rows correctly, so I have coe for that. However for some of the columns I would like to have a combobox instead of a textbox
I currently have a userform (triggered by the "Add New" button on Sheet1) that is supposed to autopopulate the data that is typed into the textboxes and listboxes into the next available row in on my Sheet1. Currently, only the listboxes are populating once I press my Submit button. Please help my debug my textboxes, which are name as txt___. I also