Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    13
    Views
    704

    Mark, Can you give a little bit more detail on...

    Mark,

    Can you give a little bit more detail on this, my Surveyor field is a concatenation of first_name and surname and is stored as text. In my SQL, this is the first part of the statement...
  2. Replies
    13
    Views
    704

    Thanks RG, Yes, I did include the...

    Thanks RG, Yes, I did include the SwitchPrinters() code in the project and PDF Creator is installed. I may need to get on to my IT department, as I cannot get into the PDF configuration file to...
  3. Replies
    13
    Views
    704

    RG, I keep getting a compile error at the...

    RG, I keep getting a compile error at the following part of the code. strDfltPrt - I get ByRef Argument type mismatch. Any ideas?
  4. Replies
    13
    Views
    704

    Thanks, RG, I will try this out shortly and let...

    Thanks, RG, I will try this out shortly and let you know how I get on.
  5. Replies
    13
    Views
    704

    I have just checked our system and we do have PDF...

    I have just checked our system and we do have PDF Creator. I would only need to change the code to not send emails and just save each surveyor's report as a separate PDF to a specified subdirectory,...
  6. Replies
    13
    Views
    704

    Thanks for that RetiredGeek, how would I modify...

    Thanks for that RetiredGeek, how would I modify this to not use ClearPDF as a printer and to not use Outlook - there are no email addresses in the report?
  7. Replies
    13
    Views
    704

    Access Report to multiple PDF Files

    Hi, I need help with running an Access 2010 mdb report to multiple PDF files, my report is grouped by Surveyor with a page break at each change in Surveyor and I need a separate PDF for each...
  8. Why not just use =VLOOKUP(C2,F3:J367,5,0) - this...

    Why not just use =VLOOKUP(C2,F3:J367,5,0) - this seems to much simpler that the other suggested formulae.

    Regards,
    Maria
  9. [SOLVED] Hi Mike, Insert a new column to the right of...

    Hi Mike,

    Insert a new column to the right of your credit card numbers and if Your credit card numbers are in column A, then in the new column B enter the following formula...
  10. Replies
    3
    Views
    7,363

    Save file as .xlsx in VBA Code

    Hi,

    How would I change the following code to ensure that the file saves as .xlsx format? (Excel 2013). I had changed the code after the Do command to include the .xlsx extension, but Excel...
  11. Replies
    2
    Views
    1,271

    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...
  12. Replies
    2
    Views
    1,271

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

    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 = ""
  14. Replies
    1
    Views
    548

    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...
  15. Replies
    1
    Views
    416

    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...
  16. Thread: UCase syntax

    by simmo7
    Replies
    7
    Views
    1,472

    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
  17. Replies
    11
    Views
    1,200

    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
  18. 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...
  19. Replies
    4
    Views
    1,221

    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
  20. Replies
    14
    Views
    6,655

    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...
  21. Replies
    14
    Views
    6,655

    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,...
  22. Replies
    1
    Views
    758

    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...
  23. Thread: Lost Macros

    by simmo7
    Replies
    2
    Views
    571

    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
    ...
  24. Replies
    4
    Views
    973

    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
  25. Replies
    3
    Views
    945

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