Search results for query: *

I got this code: Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy...

I got this code: Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy...

How do I get Excel to put the value in a cell (AA1) from all active worksheets into the header and format it to Arial, Bold 18 pts? Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = "" ActiveSheet.PageSetup.CenterHeader =...

Is there a way to separate contents of a memo field into multiple fields based on when a return is press, i.e. every paragraph in the memo field will get its own field? Thank you, Uong Saki

I have a large workbook with multiple worksheets and numerous range names used in calculation. over time and with all the changes I made, I've last track of which range names are still is in use. How can I find the unused ones and delete them from the workbook? Thank you, Uong Saki

I have a table with two date fields, date1 & date2. How dow I get Date2 automatically entered for me when I enter Date1 by adding 15 days to Date1? I was able to have Date2 entered automatically on a form but was not able to have it updated in the table. Thanks, UongSaki

I heave several Excel 2000 workbooks and each workbook has several worksheets of similar columns. Is there a way in Excel that I can combine all workbooks and their worksheets into one worksheet without having to copy and paste each worksheet? Thank you, UongSaki

I need help in writing a visual basic codes to make a salary projection for my company budget. The cost would include an annual increase as agreed with different unions and an employee date of hired or date of last salary increase due to a step increase. Time between steps for: Union Code Job...

I was able to make Access print reports to PDF file using basPDFSaver from FAQ703-2533. But how do I make the PDF document properties title field blank instead of the name of Access Report it was generated from? I have a report name RptVariance and the PDF being created with basPDFSaver has a...

I was able to adapt some codes from Roger Carlson (http://www.rogersaccesslibrary.com/) to make Access prints a report based on value in a table. Now my boss wants to print it to a PDF instead. How do I modify the procedure below so that Access prints to PDF using using value from a table as...

Hi all, How do I get Access to display N/A on a report when a calculated value as a percentage is greater than, let’s say, 1000% using code? I cannot add another if statement in my formula as access refuses to accept it. My formula is too long. Thank you, UongSaki

Is there a way to make one of the report groupings invisible if the value used in one of the group’s doe not meets a certain condition? Here’s my grouping CEGroup Descending CEAttribute Ascending CEType Ascending Currently there are four values in the CEAttribute when the report in...

How do I change this statement If CheckDivison Then strWHERE = strWHERE & "D.Divisions = " & (ComboDivision) End If so that my SQL result is SELECT D.* FROM TblFinalData AS D WHERE D.Divisions = "All CMP"; and NOT this SELECT D.* FROM TblFinalData AS D WHERE...

Is there a way to tell Access to create a table with field type using Make-table query? I want to create a text field type where Access currently creates a number's. Thanks, UongSaki

I’m trying to use Excel Pivot table to analyze data from a Union query. Is there a way to do it? I keep getting "Too few parameter – Expected 2 error message." Thanks, UongSaki

How do I create a query to delete, if there's a corresponding entry, i.e. credit/debit, row highlighted? Here a small sample of my table: Cost Center Partner Cost Element Value COCurr Document header text 53005 71110 640290 ($5,057,647.97) NTDA1019980701Op Planning CC to Op 53005 71110 640290...

Sum of Total Cost Center NTDA CE Cost Element 11000 11002 640100 501000 501001 490639.72 115753.3 501006 501007 501011 501012 501014 501998 890.89 445.2 I would...

I have an Excel file with Pivot tables that uses data from an Access database that use to reside on the local drive. I had to move the database to a share drive. How do I change the path to the new location? Thanks Saki

I have two tables, Actual & Budget. I would like to create a query that would give me the result like this (I cut & Pasted on Wordpad) Fiscal year Posting period Costcenter Cost element Actual Budget V6/2004 1 11000 501001 $40,077.90 V6/2004 1 11000 501998 $7,525.97 V6/2004 1 11000 502000...

Is there a way to extract dollar amounts from this type of file? I have a text file that when loaded into Excel all the values are in column A called value to extract. I would like the result in column B but I don't know how, help please. Thanks Value to extract Extracted Vale...