Search:

Type: Posts; User: MOSTATE; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    290

    That is Wonderful!...Thanks so much!!:D

    That is Wonderful!...Thanks so much!!:D
  2. Replies
    7
    Views
    290

    Yes, I did that and it works I just thought there...

    Yes, I did that and it works I just thought there might be another way. I could create a macro for the Find and Replace piece but just wondered if there was an easier way. Thanks so much for your...
  3. Replies
    7
    Views
    290

    Excel Formatting

    Hello All,
    I have an Excel worksheet that has a column of data with various data entries for phone numbers. Some of the users have entered in the data as (123) 456-7890 while other have entered...
  4. Thanks Steve, I think that's the solution I will...

    Thanks Steve, I think that's the solution I will go with!
  5. That works great for the Axes but not the data...

    That works great for the Axes but not the data table. Is there a way to format the number format to % in the data table?
  6. Yes, they are linked to the source. So, would...

    Yes, they are linked to the source. So, would the only resolution be to break the link? I would like to keep the link between the 2 workbooks if possible...
  7. The entire worksheet was copied to another...

    The entire worksheet was copied to another workbook. Thanks for the response!
  8. When Copying Worksheet to another Workbook Percentages convert to Decimals

    Hello All,
    I have a worksheet that contains charts I copied to a different workbook. When the source workbook is open the Percentage formatting on the charts display properly, when I close the...
  9. Replies
    11
    Views
    218

    Works Great...Thanks so much!

    Works Great...Thanks so much!
  10. Replies
    11
    Views
    218

    I receive a syntax error on the following line of...

    I receive a syntax error on the following line of code
    zAddToName = Format(Month([D4],"##") & Format(Day([D4],"##") & Format(Year([D4],"##")

    The date in D4 is formatted as mm-dd-yy, if that...
  11. Replies
    11
    Views
    218

    This works great, thanks so much. How would I...

    This works great, thanks so much. How would I change the code if I wanted to copy the TestData worksheet with the same naming convention of NewData_090214 (NewData plus the contents of D4 which will...
  12. Replies
    11
    Views
    218

    No, TestData will not be the only worksheet.

    No, TestData will not be the only worksheet.
  13. Replies
    11
    Views
    218

    Name Worksheet based on Cell entry

    I am trying to create a macro that will copy an existing workbook and then rename that copy with Text joined with the contents of a cell address which will be a date. For example my worksheet I want...
  14. Replies
    13
    Views
    970

    No, there are about 10 categories and 10 percent...

    No, there are about 10 categories and 10 percent fields along with other fields. I would like for the query to create a field based on the criteria in the RPTGCat fields and group all the % for...
  15. Replies
    13
    Views
    970

    I am attaching a workbook that shows a sample of...

    I am attaching a workbook that shows a sample of what is actually entered in the database on the first worksheet and how they want the report to look on the second worksheet. I don't have access to...
  16. Replies
    13
    Views
    970

    Yes, but ABC and DEF are separate fields with the...

    Yes, but ABC and DEF are separate fields with the percents being the records.
    ABC DEF
    0.5 1.2
    1.1 0.75
  17. Replies
    13
    Views
    970

    Based on the original data there will be several...

    Based on the original data there will be several records that have ABC as the Category with a percent, some may have the same percent. I would like a field created based on the Category data i.e.,...
  18. Replies
    13
    Views
    970

    The original source table will stay intact as I...

    The original source table will stay intact as I would like the new object, table or query, to be based on the query results so that each like Category can be summarized with just the CategoryName and...
  19. Replies
    13
    Views
    970

    Combining records

    I have a table structure in Access 2007 as shown below

    Category Percent
    ABC 1.1
    ABC .5
    DEF ...
  20. Replies
    1
    Views
    178

    Sorting by Values and Text

    Hello
    I have a worksheet that contains values and text in the same cell that needs to be sorted by the value. For example the cell contains the entry 5 years 3 months and 10 days...I would like for...
  21. Replies
    4
    Views
    335

    What a difference a colon makes :rolleyes: I...

    What a difference a colon makes :rolleyes: I tried that custom format before I posted my thread but used the . instead of the : to separate the hours and minutes so it didn't work for me. It works...
  22. Replies
    4
    Views
    335

    Thanks for the reply Rory. I don't need to...

    Thanks for the reply Rory. I don't need to convert it to number of days I need the result to display in hours/minutes.
  23. Replies
    4
    Views
    335

    Subtracting Hours in Excel

    Hello,
    I have a spreadsheet that keeps track of the number of hours an employee has worked as it cannot exceed a certain amount of hours. In my calculation the max hours is 1039 and the employee...
  24. Replies
    2
    Views
    349

    That was indeed the problem, one image was a bmp...

    That was indeed the problem, one image was a bmp and one was a png. When I made them both png files it worked fine.
    Thank you so much...:D
  25. Replies
    2
    Views
    349

    Exporting Access Report to PDF Issue

    Hello,
    I have a report in Access 2010 that contains two signatures, they are both OLEunbound images. When I export as a PDF one signature exports fine but the other does not appear in the PDF...
Results 1 to 25 of 98
Page 1 of 4 1 2 3 4