Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    754

    I have a report in Access 2007 that I have been...

    I have a report in Access 2007 that I have been using for over a year. Starting yesterday, when attempting to open the report, I get the following message in a dialog box.

    The expression On...
  2. Replies
    2
    Views
    2,021

    Re: Add-Ins Tab disappearing (Excel 2007 SP1)

    Another thank you to Hans. At least now I know what to situations to avoid.
  3. Re: personal.xlsb not loading at startup (Excel 2007 SP1)

    Thanks Hans,

    Personal.xlsb is now loading on startup
  4. personal.xlsb not loading at startup (Excel 2007 SP1)

    I have been using Excel 2007 for about 6+ months and have been experiencing a problem with getting my personal.xlsb file to load at startup.

    I have attached screen shot of the location of the...
  5. Replies
    2
    Views
    2,021

    Add-Ins Tab disappearing (Excel 2007 SP1)

    In XL 2003 I had several custom Menus that were always visible, they are add-ins that load upon Excel startup. In XL 2007 these add-ins appear on the Add-Ins tab, don't like it, but can live with it....
  6. Replies
    4
    Views
    480

    Re: exporting pdf file (Access 2007 SP1)

    I played around a little more and found this syntax will work.

    <pre>PDF Format(*.pdf)</pre>


    I appreciate your efforts
  7. Replies
    4
    Views
    480

    Re: exporting pdf file (Access 2007 SP1)

    I get a message reading "The format in which you are attempting to output the current object is not available".

    However, I have included a screen shot of the options when manually exporting a file.
  8. Replies
    4
    Views
    480

    exporting pdf file (Access 2007 SP1)

    I have successfully used the following code to export a report as an attachment to an email for easy sending. I have been exporting the report in Snapshot Viewer format. I would like to begin using...
  9. Replies
    1
    Views
    874

    Runtime error 438 (Office 2007 SP1)

    I have listed below a section of code that I was using successfully in Excel 2003 for years, but when I run this under Excel 2007 I get a 'runtime error 438 Object doesn't support this property or...
  10. DialogSheets, adding controls (Excel 2007 SP1 MSO)

    I am in the process of reviewing all of my add-ins and macros to move them from Excel XP to Excel 2007. I came across this section of code that gives me a run-time error (the code that is...
  11. Re: Change Font Color when criterias are met (XL 2003)

    I have a similar question. I have a spreasheet that we use to track employee attendance. In cells D12 thru J65 we enter codes to specify what happened with the employee on that day. The codes are...
  12. Re: If..Then on textbox contents (Access 2003 SP2)

    Thank you very much Hans. That worked perfectly. I knew I was doing something wrong, but I rarely work with strings.
  13. If..Then on textbox contents (Access 2003 SP2)

    I have a textBox contol in the detail section of a report that displays a comment associated with the current record. The textBox is named <!t>[tComment]<!/t>. I would like to be able to use an...
  14. Replies
    4
    Views
    332

    Re: Import Excel Sheet (Access 2K/XP)

    Cell E1 had a space before the word Status that was causing the import issue.
  15. Replies
    1
    Views
    264

    Send to question (Access 2003 SP2)

    When using the <!t>[DoCmd.SendObject]<!/t> command in a module, is it possible to send more than one report in the same email message? What would the syntax be?
  16. Re: Margins are expressed as pts not inches (Word

    Thank You
  17. Margins are expressed as pts not inches (Word 2002 SP3)

    When I open the Page Setup menu to make changes to the top/bottom/left/right margins, I noticed that the margins are being expressed in pts instead of inches. Is there a setting that controls this. ...
  18. Replies
    2
    Views
    1,244

    Re: query design grid missing (Access 2003 SP1)

    When maximized the movable line was not available.

    I did try all the other steps listed, and I am now able to view the design grid.

    Thank you very much for the quick response.
  19. Replies
    2
    Views
    1,244

    query design grid missing (Access 2003 SP1)

    I have an existing query that the design grid is missing. When I open the query in design mode, I can see the tables and their relationships, but I cannot see (or get to) the design grid to view...
  20. Replies
    1
    Views
    323

    move/copy worksheet (Excel 2002 SP3)

    I have an issue that has just popped up in the last couple of days. I have tried to move/copy a worksheet from one workbook to another, and get the error shown below. This has happened to me both...
  21. Replies
    2
    Views
    351

    Subtotalling (Excel 97/SR2)

    I have a .csv file that gets created daily and emailed to me. I have written some code to extract out the data that I need, but have become stumped on the final part of the code. The data is...
  22. Re: Printing worksheets in a Workbook (Excel 97/SR2)

    Thank you very much. By adding the red code, it now works. I should have known this, as I have another procedure that loops thru all the worksheets and then prints the selected sheets a specified...
  23. Printing worksheets in a Workbook (Excel 97/SR2)

    I have written a procedure that is supposed to cycle through all of the worksheets in the active workbook and print any that meet the criteria in the code. I keep getting a run time error when...
  24. Replies
    1
    Views
    261

    Memory errors (Excel 97/SR2)

    I have a file that is used to track employee attendance. I have been experiencing some memory problems with the file. The file has been been corrupted somehow, and whenever I try to fix the...
  25. Replies
    5
    Views
    468

    Re: Page Setup Default (Word 97 SR2)

    That worked. Thanks.

    However, I didn't explain my problem well enough, or I have a different problem. After making the changes suggested above, when I open an existing document and check the...
Results 1 to 25 of 119
Page 1 of 5 1 2 3 4