I need to combine two separate documents in an editor

Office

Question:I need to combine two separate documents into one or to be able to copy pages from one to the other.Answer:Open the two publications. Create as many blank pages that you need in the composition of "pulp". Go to the first page of the publication of "copy" and edit > select all or Ctrl +, then organize > Group and then copy and go to "Paste" publication and paste or paste special and...Read More

Posted: 17 Apr 2012

Tags: I need to combine two separate documents in an editor need combine two separate documents editor

Set up a button "Add new record" to create a new record in a separate form

Office

Question:How to configure a button "Add new record" to open and create a new record in a separate form? The employee ID [txtIDNumber] must automatically be completed as it is invisible on the form. The employee ID has a relationship many of the first shape in the separate.Thank you.Answer:How to configure a button "Add new record" to open and create a new record in a separate form? The employee ID...Read More

Posted: 30 Mar 2012

Tags: Set up a button Add new record to create a new record in a separate form Set button Add new record create separate form

Separate data in the same row (names and numbers)

Office

Question:I currently have a report that comes to me in the following format:1 2 3 4 5 6 7 8 9 10 11 12A JoeB 2Marc cD 1Fred EF 5G SueH 7I SamG 1What is the best way and quickst to numbers of is own colum?I have more than 1000 articles and I try to avoid doing this manually. The number is associated with the name on it. I would like to than the numbers in the next column, and in the same line. Any...Read More

Posted: 12 Mar 2012

Tags: Separate data in the same row names and numbers Separate data the same row names and numbers

Macro to separate several reports so that each is its own tab

Office

Question:HelloI have a report in which export to Excel, and it is actually 6 reports that exports to a file on a tab with a report after another. Here are the name of each of the reports, and these names are not duplicated anywhere elsewhere in the reports. Is there a way to automatically separate these reports so that each is its own tab in the Excel file? Perhaps a macro? In addition, the reports...Read More

Posted: 03 Mar 2012

Tags: Macro to separate several reports so that each is its own tab Macro separate several reports that each its own tab

Change the color of cell table based on the values in separate cell

Office

Question:If its like this:Pass, a pass B Col Col C D_______________________________Set the Score. Your results. 1_______________________________|Good. You marked 30 52. 2_____| |OK. | 3_____| |Poor. | 4_____|___________________________|Good has a green cell colorOK has a cell in yellow colourEvil has a red cell color** cell color styleWhere them "you have marked..." "columns are merged, the lines...Read More

Posted: 14 Feb 2012

Tags: Change the color of cell table based on the values in separate cell Change the color cell table based values separate