Search results for query: *

I am trying to create a table of contents in my spreadsheet. I have a macro that I need to read the contents of cells A1:A5 of all the sheets in the workbook and put the contents of those cells with a space starting in column B2. I am getting no errors but no information is going into the column...

I have written a macro to add the sheet name to the header and the page number to the footer I can't get it to work. Any help would be appreciated. Tom Sub UpdateHeader() ' UpdateHeader Macro Application.PrintCommunication = True Application.PrintCommunication = False With...

I am trying to delete a specific part of a cell with no luck. The cell is A3 on the sheet I am working on. The full string in cell A3 is JYC Internet                 (351) – includes. What I am trying to do is delete all characters after the - is this possible? Tom strChange =...

I am using Excel 2010 and Outlook 2010. What I am trying to do is copy the contents of an email into an excel spreadsheet. Currently I can pick the right email and I can copy and paste into the worksheet. The problem is the paste function is pasting into 1 cell instead of multiple cells. So I am...

I have tried another 10 ideas since my post this morning. I get sent a file every day with an attachment and what I need to do is is save that attachment to a folder. I only want the email from today saved in the folder. The code I have does not give me any errors but It isn't looping through...

I am using Outlook and Excel 2010. Everyday I get an email with an excel attachment, I need to save this excel attachment into a folder. I would like to automate this process. I have a rule that sends this email into a folder every day. The name of the outlook folder the email is in is called...

I am trying to copy and paste from one workbook to another. I have tried different methods with no results. I am hoping that I could get some assistance. The root of the problem is I don't understand how to link the application level, workbook level,sheet level. I have highlighted the line that...

I am using outlook 2010 and Access 2010. I click on a button in access that goes to the test Subroutine. I am trying to open a hyperlink that is in an email I get every day. I am getting an error 91 object not set. I have tried many different ways of using the email object with no success. I am...

I am creating a new Macro and I getting an error 438. I have tried to create the object but it is still not working. The name of the first worksheet is AMDOCS_DATA. The line highlighted in Blue is what is causing the error.Any help would be appreciated. Tom Sub Formatting() Dim rng As Range...

Whenever I try and paste data into an excel spreadsheet I get the number as text error in every column that has a number in it. After researching the issue I found some code that does go through the columns and formats them into a number, but the code goes into an endless loop. What can I add to...

I have trying to determine a way of adding an incrementing number into a new table I have created with no luck. I have been bouncing back and forth between identity and row_number. My current code is using select identity. The table field is called cnt and the data type is int. I would like the...

I have a user that was just given a new windows 7 computer. I have a database that has linked tables to an SQL 2005 database that I administer. The database is an Access 2003 database. The user is using Access 2010. whenever I use a linked table I get the SQl Server error 1801. I have added the...

I have a PHP that I want to modify. I am not sure how I would start. Currently the box will display the numbers 1 -31. I would like it to display 1-15 than 27 -31. I have never programmed in PHP before.Is this possible? Any help would be appreciated. Tom // Default Close Day...

I am using access 2003 and trying to write an update query to update a date field. I am trying to combine three fields from different tables to create this date. All fields are integers. If I run the query for the dbo_dic_Period table cal_num = 1 and year = 2015. From the z_CloseSched table I...

I am trying to write a select query that will give me the only the most current record from the table that I am selecting from. Currently from the query that I have written I would expect 18 records and that is what I get. SELECT aid,eid,slid,tid FROM rptdata_monthly.dbo.rpt_dat_CSDetail...

I started working with the absolute function today. Right now I am getting an error: Incorrect syntax near the keyword 'HAVING'. The statement I am working with: HAVING (ABS(Sum(Case When CS.trantype =4 Then (CS.Amt) Else 0 End)) = AR.CurBal) I originally tried to put this at the end of the...

I have tried to write a WHILE loop for SQL 2005 unsucessfully. What I am trying to do is have a negative value added to rptpddiff. If the update was done properly I would have rptpd 395 = 0 , rptpd 396 = -1, rptpd 397 =-2, rptpd 398 = -3 and so on. Currently I am updating the correct records...

I have copied an Access 2003 working database from one server to another. On the new server I created 5 new system DSN's through the SQL server with the ODBC connection program. I than created the ODBC connection in the Access database. I see all 5 ODBC connections I created from within the...

I am using SQL 2005. I created my first sql loop using the cursor method. Unfortunately I am getting an error message incorrect syntax near the word open. The current value for @rptpd is an integer 383. What I need the loop to do is increment 12 times . Any help in this matter is appreciated...

I am using Access 2003. I am getting a run-time error 1004. I am not sure why it is failing. The failure point is highlighted in blue. The range where the information is is AA2:AN52 The excel sheet name is SvcStats Any help is appreciated Public Sub RS_SvcStats(liCl As Long, liRPd As Long...