Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    328

    Access 2010 select query won't filter

    It seems that my select queries aren't filtering. If I change it to a make table query, the table is filtered but if I just run the query, it doesn't see my filters. They are simple filters,...
  2. Thread: Need a Macro

    by LindaR
    Replies
    4
    Views
    316

    Thank you Steve. That worked. Thanks for your...

    Thank you Steve. That worked. Thanks for your help.
  3. Thread: Need a Macro

    by LindaR
    Replies
    4
    Views
    316

    Need a Macro

    In column A, I have Client Number. I sorted on column A and removed the duplicate client numbers where there are duplicates. In Column N, I have a Contact name. For every break in Column A, client...
  4. Replies
    13
    Views
    1,748

    I am getting an error 2501 The outputTo action...

    I am getting an error 2501 The outputTo action was cancelled.

    Here is my module that I created. I created a form with a command button that calls the module.

    Public Sub ExportReportsPDF()

    ...
  5. Replies
    13
    Views
    1,748

    Thank you for your help. Will try this on Monday.

    Thank you for your help. Will try this on Monday.
  6. Replies
    13
    Views
    1,748

    I put the code in a module and when you say call...

    I put the code in a module and when you say call it from the click event, what does that look like? Sorry, I am not that good at VBA.
  7. Replies
    13
    Views
    1,748

    I was going to create a form and put the code in...

    I was going to create a form and put the code in the on click event of a command button. Can I do this?
  8. Replies
    13
    Views
    1,748

    Access 2007 but will be upgrading to Access 2010...

    Access 2007 but will be upgrading to Access 2010 in near future. For now 2007.
  9. Replies
    13
    Views
    1,748

    macro to export reports

    I need a macro to export 14 reports in PDF format to a location on C drive or network drive. Maybe prompted for location.
  10. My grouping and sorting doesn't work in Access 2007 Report design

    I can't get my report to group and give me a total at the break. I am used to 2003. I know it is something I just am not doing right in 2007. I have a field "Type of Coverage". I want it to group...
  11. Replies
    2
    Views
    640

    thank you so much. Saved me hours of work.

    thank you so much. Saved me hours of work.
  12. Replies
    2
    Views
    640

    Macro to delete rows with 1 in column B

    I need a macro to delete the entire row where there is a 1 in column B. Also, to delete one row above. So where there is a 1 in column B, I need that row deleted and the one above. Any help is...
  13. Replies
    21
    Views
    3,702

    Can't you just select the summation symbol on the...

    Can't you just select the summation symbol on the top and hit enter. If you look at the calculation, it uses =subtotal(9,c2:C100) for example
  14. Replies
    15
    Views
    11,829

    How about a pop-up calendar. The attached...

    How about a pop-up calendar. The attached spreadsheet describes how to do this in Excel 2003. Not sure about 2007. In the code, you have to format the column to the date format you want.
  15. Replies
    10
    Views
    997

    Right click one of the total lines. Click on...

    Right click one of the total lines.
    Click on Field Settings
    Click None.
  16. Thread: Folder creation

    by LindaR
    Replies
    2
    Views
    533

    I am not that familiar with Outlook. I thought I...

    I am not that familiar with Outlook. I thought I created a folder under another folder - something like a sub folder. I moved an email to this sub folder but I can't see the folder under the folder...
  17. Replies
    2
    Views
    459

    I am not sure if this is where to ask this and I...

    I am not sure if this is where to ask this and I am not sure this is a Windows XP problem. When I go to Microsoft Office Discussion on the web, the area that displays the discussions is blank. I...
  18. Replies
    8
    Views
    8,551

    =Date(Mod(A2, 10000),TRUNC(A2 / 1000000),...

    =Date(Mod(A2, 10000),TRUNC(A2 / 1000000), MOD(TRUNC(A2 / 10000), 100))

    Copy down
  19. Replies
    8
    Views
    8,551

    Highlight and Right click the column you want to...

    Highlight and Right click the column you want to enter the dates.
    Select Format Cells.
    On the number tab choose custom and enter in the Type Box 00\/00\/0000.
    It looks like a V between the 0s...
  20. Replies
    3
    Views
    493

    This may be too simplistic but have you tried: ...

    This may be too simplistic but have you tried:

    Put a + sign in the cell you want the data to appear
    Go to the other spreadsheet and highlight the cell that has the data you want
    Hit enter
    This...
  21. Thread: Cell format

    by LindaR
    Replies
    8
    Views
    648

    Since it is a zip code and a set number of...

    Since it is a zip code and a set number of characters try this:

    In a new column put =TEXT(A1,"000000") and copy down.

    Then highlight that column and
    EDIT
    copy
    Paste Special
    Choose values
  22. Replies
    6
    Views
    709

    I figured out how to prevent the #REF! error from...

    I figured out how to prevent the #REF! error from showing. Just in case someone else has this problem.

    =IF(ISERROR(SUM(E5,E7,E9,E13,E23,E27))," ",SUM(E5,E7,E9,E13,E23,E27))
  23. Replies
    6
    Views
    709

    Yes, I switched from trying to connect the data...

    Yes, I switched from trying to connect the data using Access. I use Access just to update the first spreadsheet. From that spreadsheet I populate the premade spreadsheet with the breaks, headings...
  24. Replies
    6
    Views
    709

    Yes, the spreadsheet I am linking to is premade ....

    Yes, the spreadsheet I am linking to is premade . It is set up with calculations, headings and such. I am just updating certain sections with data that changes (monthly). I have linked the data...
  25. Thread: Database Query

    by LindaR
    Replies
    4
    Views
    534

    I do have overwrite existing cells with new data,...

    I do have overwrite existing cells with new data, clear unused cells but it overwrites the cells and leaves the extra cells there. I have to manually delete them. I am not sure what it does if the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4