Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    138

    Thanks Steve, I just tested with the error...

    Thanks Steve, I just tested with the error handling and it worked, no debug mode triggered. Just what I wanted. I am not sure if your alternate method would work as the 2 pivot tables are created...
  2. Replies
    2
    Views
    138

    Filtering a Pivot table via macro code

    Hi,

    I have a macro that creates 2 pivot tables, both tables have some filtering set as follows, however, the values that I filter on do not always have any data.

    With...
  3. Replies
    5
    Views
    279

    I use the Wingdings characters 251 & 252 in the...

    I use the Wingdings characters 251 & 252 in the following macro's.

    Code:Sub XMark()
    '
    ' XMark Macro
    ' Insert X in Wingdings font
    '

    '
    ActiveCell.FormulaR1C1 = ""
  4. Replies
    1
    Views
    193

    Problem loading switchboard

    Hi, My work PC was recently upgraded to Office 2013 - without Access. I still have Access 2007 on my computer, but since the upgrade any of my databases where I use the inbuilt switchboard are...
  5. Replies
    1
    Views
    189

    Restricting characters in a field

    Hi, At work we use an Access 2007 database where one of the fields in a table is a policy number. I want to restrict users to use 9 to 12 mix of alpha and numeric characters but ensure that the...
  6. Thread: UCase syntax

    by simmo7
    Replies
    7
    Views
    571

    Another way is when in Table design, simply set...

    Another way is when in Table design, simply set the format for the field to show >, this will force every entry into the field to uppercase.

    Regards,
    Maria
  7. Replies
    11
    Views
    224

    Just a little point, I find it better to save...

    Just a little point, I find it better to save files with dates using Year-Month-Day - this makes files easier to sort into date order.

    Regards,
    Maria
  8. Pivot Table - show summarized data

    Arcturus 16a,

    In Excel 2007, right click on the field and go to field settings, change from Show item labels in tabular form to show item labels in outline form and make sure both boxes are...
  9. Replies
    4
    Views
    515

    Hi Trevor, Is the report based on an Access...

    Hi Trevor,

    Is the report based on an Access query? If so, I would put a criteria in the query under the order number field as = not null.

    Regards,
    Maria
  10. Replies
    14
    Views
    2,559

    Thanks Maud, This will be very helpful. ...

    Thanks Maud,

    This will be very helpful. Quite often, I need to hide empty columns after I have deleted some content and then unhide them after I have printed out the content I need. I can't...
  11. Replies
    14
    Views
    2,559

    Maud, I am assuming that if I wanted to use...

    Maud,

    I am assuming that if I wanted to use this code to hide empty columns rather than delete them, then I would change line 5 of your code to read Then ActiveSheet.Columns(I).Hide

    Regards,...
  12. Replies
    1
    Views
    471

    Dr Dre, I have done something similar to this...

    Dr Dre,

    I have done something similar to this in MS Access. What I did was pasted a document (in your case it would be a .jpg file) into a blank report, then inserted fields where required over...
  13. Thread: Lost Macros

    by simmo7
    Replies
    2
    Views
    420

    Hi, You need to tell the Citrix version of Excel...

    Hi, You need to tell the Citrix version of Excel 2007 where to find your personal.xls file in Excel Options - Advanced -General - at startup load all files in {drive name}.

    Merry Christmas
    ...
  14. Replies
    4
    Views
    691

    Joel, If you have Excel 2007/2010 you can use...

    Joel,

    If you have Excel 2007/2010 you can use Data, Text-to-Columns. All you need to do is specify what delimits the text.

    Regards,
    Maria
  15. Replies
    3
    Views
    750

    You can use the Data Consolidate command (Excel...

    You can use the Data Consolidate command (Excel 2007). Have all quarterly sales worksheets open and in a new file use the Data Consolidate to combine them. You can add references as needed.
    ...
  16. Replies
    4
    Views
    1,660

    Rory, Thanks, your formula worked slightly...

    Rory,

    Thanks, your formula worked slightly quicker than mine. I had thought about using INDIRECT, but could not remember how to set the reference.

    Regards,
    Maria
  17. Replies
    4
    Views
    1,660

    Bob, I deliberately did not use F2 as I am not...

    Bob,

    I deliberately did not use F2 as I am not always pasting into row 2, by using the column my lookup worked perfectly.

    Regards,
    Maria
  18. Replies
    4
    Views
    1,660

    Pasting a volatile formula in Excel 2007

    I am pasting the following formula into a sheet - =VLOOKUP(D2,'Lookup current policies.xlsx'!ExpiryDates,2,0). Once I have it in the sheet and location I want, is there any way of Excel knowing what...
  19. Replies
    5
    Views
    1,360

    Pivot Table Question

    Hopefully this is what you want. I have often used pivot tables to count yesses and noes or Trues and Falses.

    Regards,
    Maria
  20. Replies
    4
    Views
    5,388

    Howard, Here is a link to some Microsoft help...

    Howard,

    Here is a link to some Microsoft help for pivot tables.

    http://office.microsoft.com/en-au/excel-help/results.aspx?filter=1&ck=1&av=zxl120&qu=Pivot Tables&ex=2

    Regards,
    Maria
  21. Replies
    4
    Views
    5,388

    HowardC, I dragged the Description field down...

    HowardC,

    I dragged the Description field down to the Values area and it defaulted to count. Hopefully this is what you wanted.
  22. Replies
    2
    Views
    624

    Need help with adding new fields

    Hi all, I have a database that includes the table structure shown in my attachment. My questions are as follows.

    1. If I add a field called Date_Further_Info_Reqd, then is it possible to auto...
  23. Replies
    6
    Views
    1,071

    Richard, Yes you can share the workbook. In...

    Richard,

    Yes you can share the workbook. In Excel 2007 use - Review, Share Workbook - prior to this you can use Protect Sheet and a password if you want some areas restricted. In Excel 2003...
  24. Does the same problem occur if there is actual...

    Does the same problem occur if there is actual data on more than one page?

    Regards,
    Maria
  25. conditional formatting

    I don't know why you can't change the font, perhaps you don't have wingdings installed?? I have changed to Arial Font, hopefully this is now OK for you.

    Also I missed one step, first you select...
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4