Search results for query: *

In an excel work sheet, is there a way to verify that the numbering in a column is in sequence and if a number is missing in the sequence to identify it? Thanks

I would like to know how to link a range of cells from an excel worksheet which is part of a workbook into a word document.

I currently have a word document in which I want to run a macro which will open a specific excel workbook, go to a specific worksheet, copy a range within that worksheet,then paste the copied range into the word document and then format it to fit the page in the word document. The problem I am...

I have a word document and an excel worksheet. I am trying to create macros within the document which will go to the worksheet, copy a range of cells and paste special (microsoft office excel worksheet object) the copied cells an then format the object to fit the document. I am trying to do...

How can I format the TOC to read: Operations 2006 Overtime Table.........18-25 instead of how it is currently reading: Operations 2006 Overtime Table..........18 Operations 2006 Overtime Table..........19 Operations 2006 Overtime Table..........20 Operations 2006 Overtime...

I currently use the same workbook every day which has a worksheet for each day in the month. Is there a way to change the date (in a particular cell)on each page (for the current month) without having to do it manually? The tab for each day also has a date and I would like to change this as...

I have an image in my report(a logo) that will not show when I use the office link to MS Word. Any suggestions how I can get this to appear? Thanks

I have downloaded a log (.txt) file off a server and imported it into an access table. The format of the date/time field from the log is as follows: [12/Oct/2005:13:26:04 and - [12/Oct/2005:13:28:2 I want to convert it to a mm/dd/yyyy format. How can this be accomplished? Thanks

I have a workbook which has several worksheets (linked) within it. One worksheet is called "download 2005" which feeds many of the other worksheets. "Download 2005" has totals by month which updates other work sheets. I also have a worksheet named "Current mth by facility". I would like to be...

I have a macro but need the code to export the data (and headings) to a new workbook. How is this done using VB code? Thanks DK

I want to record a macro that when I enter data into cells,I can calculate sums and % and then when I run the macro, it will open another sheet and put all of this data into another sheet. I will be extracting data from a database into the first excel sheet and then "exporting" this data...

I have a form(serial#) and a sub form(serial#sub). The sub form resides within the form. When I open the form, I want the cursor to be on the first field(tagno), which is a combo box. After choosing the tag # from the combo box, I want the cursor to move to the description field on the sub...

I am having trouble creating a form that will be able to update an existing table as well as add new records. The form has a combo box(tag#), but if I want to add a new tag#, I cannot do this. The combo box allows me to see existing tag#'s and the data associated to them. Any suggestions? Thanks

I have two tables, Scantable1 and serial#. In a form, I am pulling a field from scantable1(tagno). I am inputting information into this form and want to be able to update the serial# table with the for data. I need to know how I can update the serial# table with the tagno field from the...

Is there a way to hide blank rows in a report? Thanks

Hello! In Access reports, is there a way to supress a blank row in a report? I can not show duplicate records but cannot seem to get the rows(blank) to disappear from the report. Help please! Gray78

Hello, I have a spread sheet with one column is always PM, is there a way I can format this column that when I put a time in (5:00) it comes up as 5:00 PM? Thanks

I have a form where I would like to place a button that when clicked, it will revert the form back to it's original data. How is this done? Thank you

I have a form and I want the data input to be stored in two tables, a history table and an inventory table. Can this be do and if so how?? Thanks

I have a simple for and want to put in a cancel/reset button in. When clicked it will not store the data and will set the fields (4) back to their previous state. Can anyone help?? Thanks