Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    7

    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...
  2. Replies
    13
    Views
    661

    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...
  3. Replies
    13
    Views
    661

    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...
  4. Replies
    13
    Views
    661

    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
  5. Replies
    13
    Views
    661

    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.,...
  6. Replies
    13
    Views
    661

    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...
  7. Replies
    13
    Views
    661

    Combining records

    I have a table structure in Access 2007 as shown below

    Category Percent
    ABC 1.1
    ABC .5
    DEF ...
  8. Replies
    1
    Views
    147

    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...
  9. Replies
    4
    Views
    277

    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...
  10. Replies
    4
    Views
    277

    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.
  11. Replies
    4
    Views
    277

    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...
  12. Replies
    2
    Views
    249

    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
  13. Replies
    2
    Views
    249

    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...
  14. Thanks for the reply, Patt. Where do I place the...

    Thanks for the reply, Patt. Where do I place the Me.Filter code?
  15. Works like a charm...thanks so much:D

    Works like a charm...thanks so much:D
  16. Thanks so much for the reply. I am not a coder...

    Thanks so much for the reply. I am not a coder so I am attaching the code with my changes the form name is Pay and Benefits and the field name I want to be able to search on is FirstName. Would you...
  17. Go to record based on search in Access 2007 form

    Hello
    I would like to be able to go to a record in an Access 2007 form by searching on partial criteria. For example if I am looking for a business name and it has the word Training anywhere in...
  18. That's what I thought...thanks for the response!

    That's what I thought...thanks for the response!
  19. Replies
    14
    Views
    853

    This is perfect, just what I was looking for...I...

    This is perfect, just what I was looking for...I will try the Match function as well...Thanks so much!!
  20. Replies
    14
    Views
    853

    If Date is Day Before or After Holiday

    Hello
    Is there a way for Excel to declare if a date is the day before or after a specified date? I have a list of Holidays below that I would like to compare dates to and if the date is one day...
  21. Change the default reponse in Outlook 2007 Calendar

    In Outlook when I accept a meeting request the default is set to "Send a Response". Can this default be changed by me so that when I accept a meeting request the default is No Response?

    Thanks!
  22. Replies
    7
    Views
    561

    This is a perfect starting point...thanks so much!

    This is a perfect starting point...thanks so much!
  23. Replies
    7
    Views
    561

    Thanks for the response. I am attaching a sample...

    Thanks for the response. I am attaching a sample worksheet that assigns each workday a number. Mon=1, Tues=2...etc I am trying to find the best way to chart the data showing the most requested...
  24. Replies
    7
    Views
    561

    Establish a Pattern in Excel

    Hello,
    I am tracking workdays the employee has called in sick in Excel. I need to know if there is a way in Excel to establish if there is a pattern in the workday that the employee is calling in...
  25. Replies
    7
    Views
    2,100

    Steve Thank you so much, your solution works...

    Steve
    Thank you so much, your solution works great!!
Results 1 to 25 of 86
Page 1 of 4 1 2 3 4