Search results for query: *

Has anyone got knowledge of how this occurs and if so how to correct. I've tried looking around security and macros.

I am new to forms and have an issue that I do not wish to see the line that is appearing at the bottom. I have checked object dependancies and I am using none. I cannot find a control source in properties either.

I have an excel sheet holding information in rows. Some of the 21 rows need to become 21 columns. for example cell I2 needs to become G1 cell I3 needs to become H1 The 21 row values in column j need to be kept in step. for example cell J2 needs to become G2 cell J3 needs to become H2...

Typical, I just get to grips with creating an excel msquery as data source/connection for a word mailmerge! What happens Office 2010 is installed, now they need a change and nothing works as the layout/familiarity with Excel 2007 is all over the place. Does anyone know the way now to create a...

Hi, I am very inexperienced in Crystal Reports but knowledge of database techniques. I need to add a field into an existing report. The reports current access database connection does not contain the field. I believe I will need to create a new connection. However when I try this it I drops all...

I have used the range coding before in a single Workbook. I require to search Column J in Workbook/Worksheet named TY_Multi_Gifts.xls/TY_Multi_Gifts Using the range for a single worksheet works fine in other macros, I just can't grasp how to make it work using Workbook and Worksheet names. I...

I have an excel spreadsheet that I need advice on how to merge rows/cols and drop the surplus rows. The following sample from the excel file is as follows. Row Col A Col B Col C Col D Col E Col F 1 24/03/92-139 5668 Kilkeel 81161 Wool £1,157.38 2 24/03/92-139...

I have no previous experience but require assistance with a problem at work that needs resolving. I have needed to build a report from scratch. I have designed and can view data at a field level. However when I go to Preview I see no data. Is there anyone out there who can help?

Hi I need to know how or if its even possible to retain the formatting I have in a cell of text that I wish to use as the body of an email from outlook. For example Not replace where I have used alt CR with CR LF Also any bold, colours etc.

This is continuing on from some code I wrote where an excel spreadsheet had Column E holding email addresses. This column E was read and for each cell containing an address it would select Column A containing name of excel file to be put in an email. I need to refine this as I need to ensure...

I have put the code below my issues, it's drawn from other threads I've found. 1. The FOR loop does not exclude row 2 in Column E(blank email) of my single excel sheet. 2. I unable to get past the .Attachments.Add it fails to find the files even though I have checked the path. If I hard code...

I have this code but cannot get it to run into my loop. Any help would be most welcome. Requirement is to read all column C in worksheet1 and for each cell check its value for existence in worksheet2. If found then I need to copy the value from worksheet2 activecell -1 into activecell -1 of...

I am unable to understand why in my macro I can use the range from input boxes successfully to pasteall or pastevalues. However I have tried several ways to use the outputcells variable in my code to have each cell replace part of the formula they contain. Testing for !F and replace with !E...

I am unable to understand why in my macro I can use the range from input boxes successfully to pasteall or pastevalues. However I have tried several ways to use the outputcells variable in my code to have each cell replace part of the formula they contain. Testing for !F and replace with !E...