Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    340

    OK I'm replying to my own post :-) Access/VBA...

    OK I'm replying to my own post :-)

    Access/VBA does it all for you - passing the rich text into a class object using string properties preserves the formatting.
    The reason for posting was that I...
  2. Replies
    1
    Views
    340

    Using Rich Text in VBA

    I am developing an application in MS Access and need to capture some information using rich text ie I want it to be formatted whenever presented on forms or reports.
    Generally I do not use bound...
  3. Replies
    4
    Views
    348

    Thanks - I'll give it a go.

    Thanks - I'll give it a go.
  4. Replies
    4
    Views
    348

    Thanks WendellB, I'll give that a try. Not...

    Thanks WendellB,

    I'll give that a try. Not being able to link it shouldn't be a problem as I can achieve the same thing through VBA code. The trade off will be though that I will lose the...
  5. Replies
    4
    Views
    348

    Linking a Form to a Datasheet

    I'm developing an Access application where I have a large form containing details about a Survey Request. This form, called Survey Task Sheet, contains a tab control and the tabs contain either...
  6. Replies
    6
    Views
    3,302

    Thanks all for the replies/suggestions. With...

    Thanks all for the replies/suggestions.

    With the format painter I was only doing single controls so the behaviour is different from previous versions, but it only appears so if the ribbon was...
  7. Replies
    6
    Views
    3,302

    Problems with Office 2013

    I've had Office 2013 installed on one of my laptops for about a month now. I hated it when I first got it and I hate it still. I don't like the fact that the MENUS SHOUT OUT AT YOU in their large...
  8. Replies
    0
    Views
    495

    Code Windows Not Open in Excel

    I have just had my company laptop replaced. The old one was an XP/Office 2007 machine and the new one is Windows 7/Office 2010.

    I am just making some changes to an Excel based application I...
  9. Separating the UDTs had no effect :-( As I...

    Separating the UDTs had no effect :-(

    As I said above I'll wait until I've finished the current round of changes before trying to convert UDTs into classes.

    Thanks
  10. Thanks for that. I'll try separating the UDTs...

    Thanks for that.
    I'll try separating the UDTs first to see if that fixes it.
    I'll have to wait to convert the UDTs into classes as I would not feel comfortable incorporating that in the next...
  11. Hi Rory, Thanks for the suggestion. I need to...

    Hi Rory,

    Thanks for the suggestion. I need to get my head around how to implement that but would be interested to know why you think that would work - not doubting it just interested to know :-)
  12. Error Message: Too Many Local, Non Static Variables

    Apologies for the long post but I feel I have to provide some context in order for anyone to be able to help me.

    I have an app (Access 2007/VBA on XP SP3) which I've been using and enhancing for a...
  13. Thread: Compiling VBA

    by njl100
    Replies
    7
    Views
    4,312

    Thanks RetiredGeek, I've had a play with it by...

    Thanks RetiredGeek,

    I've had a play with it by adding new code that I know will be executed, introducing a deliberate error and running. It looks like it compiles each function prior to executing...
  14. Thread: Compiling VBA

    by njl100
    Replies
    7
    Views
    4,312

    Thanks RetiredGeek. What I don't understand...

    Thanks RetiredGeek.

    What I don't understand though is why the application will not trigger an error when it runs as the code still refers to non existent controls.
  15. Thread: Compiling VBA

    by njl100
    Replies
    7
    Views
    4,312

    Compiling VBA

    I have been doing stuff in VBA for a while now and have reached the point where I feel quite proficient.

    A colleague of mine has developed an Access Db which also uses some VBA behind the forms...
  16. Replies
    1
    Views
    1,909

    I've solved it - after much head scratching. ...

    I've solved it - after much head scratching.

    The function CheckWorkbooks() is called to verify that all the sheets it needs are open and it tries to display what it finds on some traffic lights on...
  17. Replies
    1
    Views
    1,909

    VBA Seems to hang with Excel UserForm

    I have an application in Excel using a UserForm and VBA. The application uses a number of spreadsheets to generate reports. The main spreadsheet I am using is called the Generator because it...
  18. Thanks for the tip re Wepawet. One thought struck...

    Thanks for the tip re Wepawet. One thought struck me though. If a URL sent to you is unique to you as a recipient then will using Wepawet identify you to the scammer as a real email address and so...
  19. Replies
    7
    Views
    1,561

    Thanks for that Bender. I created the test app...

    Thanks for that Bender. I created the test app also.

    The code you provided wouldn't compile on my machine for 2 reasons.

    In frmMain the declaration statement "Private fMatchList As New...
  20. Replies
    7
    Views
    1,561

    I've moved both the class declarations (cMatches...

    I've moved both the class declarations (cMatches and frmMatchList) to form level and tried both Dim and Public. I've also tried instantiating cMatches when frmPlayerProfile opens rather than in the...
  21. Replies
    7
    Views
    1,561

    Thanks Bender, It was creating a new Property...

    Thanks Bender,

    It was creating a new Property for the form that was the missing link for me. Once you'd explained that I seemed to get it. Fortuitously I was working on another area of the...
  22. Replies
    7
    Views
    1,561

    Calling forms from within classes

    I have an Access 2007 app which uses lots of VBA. I am trying to improve it by making it more object based but am struggling conceptually to understand how to do something. I am still trying to get...
  23. Replies
    1
    Views
    1,457

    What OS and version of Excel are you using? ...

    What OS and version of Excel are you using?

    I've just created a new xlsm file, copied your VBA into the Worksheet.Open event and entered some data containing proper words and misspelt words in...
  24. Replies
    5
    Views
    9,898

    Strangely, very strangely, the problem has now...

    Strangely, very strangely, the problem has now fixed itself......

    I tried downloading the toolbar once more before resetting to defaults and it worked!! Also I've gone into the Tool Bar Options...
  25. Replies
    5
    Views
    9,898

    Thanks Joe I had just tried that as well as...

    Thanks Joe

    I had just tried that as well as clearing cache, deleting cookies, history, removing Google toolbar and several reboots and that seems to have fixed the problem. Why - I don't know.
    ...
Results 1 to 25 of 54
Page 1 of 3 1 2 3