Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    11
    Views
    146

    Works Great...Thanks so much!

    Works Great...Thanks so much!
  2. Replies
    11
    Views
    146

    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...
  3. Replies
    11
    Views
    146

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

    No, TestData will not be the only worksheet.

    No, TestData will not be the only worksheet.
  5. Replies
    11
    Views
    146

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

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

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

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

    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.,...
  10. Replies
    13
    Views
    744

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

    Combining records

    I have a table structure in Access 2007 as shown below

    Category Percent
    ABC 1.1
    ABC .5
    DEF ...
  12. Replies
    1
    Views
    156

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

    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...
  14. Replies
    4
    Views
    294

    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.
  15. Replies
    4
    Views
    294

    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...
  16. Replies
    2
    Views
    269

    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
  17. Replies
    2
    Views
    269

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

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

    Works like a charm...thanks so much:D
  20. 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...
  21. 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...
  22. That's what I thought...thanks for the response!

    That's what I thought...thanks for the response!
  23. Replies
    14
    Views
    911

    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!!
  24. Replies
    14
    Views
    911

    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...
  25. 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!
Results 1 to 25 of 90
Page 1 of 4 1 2 3 4