Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.02 seconds.

  1. Excel 2010: Visual Basic Error on Closing Excel

    Hi All Excel Experts,

    I have just edited an xlam file and reinstalled it. The VBA procedures within that file are working as expected.

    However, now every time I close (exit) Excel I get the...
  2. Hi RetiredGeek, Thanks, yes that does exactly...

    Hi RetiredGeek,

    Thanks, yes that does exactly what I desire - it toggles the Subscript on and off depending on how the last character in the string is set.

    Cheers

    Trevor
  3. Excel 2010: VBA problem toggling subscripts

    I have strange behaviour with a Macro to toggle a Subscript in an Excel 2010 Cell.

    My Macro will toggle the values show in Row 1 to have the final character of the string in the selected cell...
  4. Replies
    4
    Views
    352

    Hi RG, I suspect you are right because my...

    Hi RG,

    I suspect you are right because my database is certainly not fully Normalized. The main table in my database has grown like topsy to about 90 fields as I've self taught myself how to use...
  5. Replies
    4
    Views
    352

    Hi Maria, Thanks for responding. The...

    Hi Maria,

    Thanks for responding.

    The Report is based on a Query filtered using other criteria.

    However, I cannot use the query filtering approach because then the whole record for a Trade...
  6. Replies
    4
    Views
    352

    Hiding Blank Data Fields on a Report

    I have a Report that displays information about a Trading position that can be made up made up of at least 1, and up to 4 Orders. Each Trade Record within the database Table has fields for all 4...
  7. Hi, To finally close off how I solved my "Not...

    Hi,

    To finally close off how I solved my "Not Genuine" Issues.

    After trying to get Microsoft to resolve the issue for me I gave up because they were unhelpful:(

    To complicate the issue, I...
  8. HTH, Actually all I did was insert the wrong...

    HTH,

    Actually all I did was insert the wrong graphic:rolleyes: Now corrected:o

    Trevor
  9. Hi Guys, A good night's sleep brought a bright...

    Hi Guys,

    A good night's sleep brought a bright fine morning with clear blue skies with all things outside looking absolutely great, just right for an early morning walk on my local beach, which I...
  10. Okay, now you've got me confused. What is an...

    Okay, now you've got me confused.

    What is an "elevated prompt" and what is "SLUI3"?
  11. Thanks for the suggestion. Unfortunately it does...

    Thanks for the suggestion. Unfortunately it does not work. Here is the result of following the instructions provided in the link you suggested:

    36276

    Note that there is no "Activate Windows...
  12. Windows 7 Ultimate "Not Genuine" After Windows Update 10 Sep 2013

    My Lenovo Thinkpad T500 is currently running a genuine (fully registered and activated) Windows 7 Ultimate 64 Bit and has been doing so very successfully for over 2 years.

    After a Windows 7 Update...
  13. Hi Browni, Thanks for your prompt suggestion....

    Hi Browni,

    Thanks for your prompt suggestion.

    Yes, I'd tried keyboard commands but not all dialogues use them, either that or they didn't/wouldn't work:(

    As I've noted in another post a...
  14. Hi R4, Thanks for your suggestion. Yes I...

    Hi R4,

    Thanks for your suggestion.

    Yes I had tried Safe Mode and Restore had failed. After you'd prompted it again I had another go and darn me but it worked. Don't know why my first couple of...
  15. Thanks for your prompt response. I should have...

    Thanks for your prompt response. I should have addressed that question in my original post.

    It occurs with my Logitech Bluetooth Travel Mouse that I've been using for years. I've also tested with...
  16. Win 7 Ultimate 64 bit: Right Click Menus Missing

    I have a Thinkpad T500 that has been running Windows 7 64 bit very successfully for the past few months.

    Yesterday after rebooting the computer I couldn't:

    Access any right click menus in any...
  17. Replies
    4
    Views
    1,081

    Hi AliC, At times patience runs out as...

    Hi AliC,

    At times patience runs out as frustration takes over. Something really screwing was happening with my chart report - it was causing my computer to freeze completely:mad: That frustration...
  18. Replies
    4
    Views
    1,081

    Hi AliC, Thanks for responding. I tried...

    Hi AliC,

    Thanks for responding.

    I tried Me.Dirty = False, but that doesn't resolve the issue.

    A fundamental problem with the standard error dialogue is that it doesn't indicate what "object...
  19. Replies
    4
    Views
    1,081

    Access 2010 Report Close Dialogue Issue

    I have an Access 2010 Report that contains an OLE unbound object that is linked to an Excel Chart.

    The Report Activate Event Procedure is:


    Private Sub Report_Activate()


    ...
  20. A Solution

    It looks like I've found a solution to this issue. In the Report I have included the following Event Procedure:


    Private Sub Report_Activate()


    Me!OLEChart.Action = acOLEUpdate


    End Sub
  21. Access 2010 Report OLEUnbound Object Not Using Lasted Excel Chart Data

    I have an Access reporting process that:

    1 Using a Report Selection Form, which allows the setting of Query criteria,
    2 Runs a Query, which then
    3 Opens and Excel Workbook, and
    4 Deletes...
  22. Replies
    7
    Views
    1,804

    Access Query Export to Excel for Access Report

    Hi Jeremy,

    Thank you for your suggestion. That looks like a pretty complicated solution so I haven't tried it, having found a simpler solution before I read you post.

    I used the...
  23. Replies
    7
    Views
    1,804

    Hi RetiredGeek, Thanks for the very quick...

    Hi RetiredGeek,

    Thanks for the very quick response. I tried your suggestion. Unfortunately it made no difference, so still looking for a solution.

    Seeing my query has 6 fields and the 3016...
  24. Replies
    7
    Views
    1,804

    Hi RetiredGeek, Yes, the query works...

    Hi RetiredGeek,

    Yes, the query works perfecting if run interactively and when used in a tabular report.

    Yes, it is getting the required parameters from a form that is used to select the report...
  25. Replies
    7
    Views
    1,804

    Getting Access 2010 Error 3016

    I have a VBA routine in my Access database that returns Error 3016:


    33806

    I've narrowed the problem down to the following VBA statement (by placing status messages boxes each side of the...
Results 1 to 25 of 105
Page 1 of 5 1 2 3 4