Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.05 seconds.

  1. Which version of Excel are you using? I...

    Which version of Excel are you using?

    I believe it's an option in Excel 2010 (and presumably 2013 too), but unfortunately I'm not on my Excel 2010 machine at the moment. For earlier versions of...
  2. Searching for a missing reference is the way to...

    Searching for a missing reference is the way to go here.

    Is your macro stuck in break mode? Click on on the Reset button on the VB Editor toolbar or go into the Run menu and select Reset, then try...
  3. Well as you correctly recognize, you can't really...

    Well as you correctly recognize, you can't really help properly without full details of the configuration and error message(s).

    At the very least, you need to know whether their Access database is...
  4. How very weird! I've just tried this in Excel...

    How very weird!

    I've just tried this in Excel 2007 and get the same. With 3 dots in A1 (...), the function LEN(A1) reports 1.
    And LEFT(A1,1) gives back ... again. Interestingly, CODE(LEFT(A1,1))...
  5. Replies
    8
    Views
    320

    It looks like your drop-down list has had a macro...

    It looks like your drop-down list has had a macro associated with it at some point in time. If you right-click on the control and select Assign Macro from the context menu that appears, is there a...
  6. Replies
    9
    Views
    407

    I wouldn't disagree with this per se, but...

    I wouldn't disagree with this per se, but remember if you use this technique to compact the database regularly - Access will not reclaim the space that was used even if you delete the data from the...
  7. According to your Access screenshot, the field is...

    According to your Access screenshot, the field is called Titile, but in the code it is referred to as Title. I assume Title was your intention :)
  8. Replies
    4
    Views
    241

    Alan, just a thought - does the CLEAN function do...

    Alan, just a thought - does the CLEAN function do what you need? (It's supposed to remove ASCII characters 0 to 31 from strings.)
  9. Replies
    3
    Views
    224

    It looks like the contents of a text field called...

    It looks like the contents of a text field called text221. Do you have an object on your report with that name? It's not very meaningful, which suggests it's the default name of a textbox or...
  10. You just want something like for each fld in...

    You just want something like


    for each fld in tdf.Fields
    if UCase(Left(fld.name,2)) = "FY" Then
    fld.Name = "Town"
    exit for
    end if
    next fld
  11. That will crash because your fld variable isn't...

    That will crash because your fld variable isn't pointing to a field when you try to check its name! I think the intention was that you enclose your code in a loop like this:


    For Each fld in...
  12. Hi Steve, I did some playing on Excel 2007 last...

    Hi Steve, I did some playing on Excel 2007 last night and the following code allows some of the desired functionality:



    Sub GFN()
    Dim fd As FileDialog

    Set fd =...
  13. Alan, I'm not sure that GetOpenFilename supports...

    Alan, I'm not sure that GetOpenFilename supports file filters other than by specifying the extension. If you have Office 2007 or later you might want to check out the FileDialog object which has...
  14. Hi Alan, glad you had fun writing this. You...

    Hi Alan, glad you had fun writing this.

    You may want to check out the Split function in VBA. I don't think it was available in earlier versions because I remember having to split strings manually...
  15. I've just tested a pipe-delimited spec in code...

    I've just tested a pipe-delimited spec in code (albeit in Access 2007) and it worked fine to my c: drive so I'm not sure why you get an error.

    Just one question: does your code set Location =...
  16. Usually the best way to learn these things is to...

    Usually the best way to learn these things is to record yourself creating a PivotTable with the desired layout on one worksheet. The macro recorder will probably record some redundant code which...
  17. Replies
    1
    Views
    947

    Since no-one else has replied I'll throw in a few...

    Since no-one else has replied I'll throw in a few suggestions:
    what do you mean when you say the tables aren't updating correctly - do you mean showing fresh data, or not sorting automatically?
    I...
  18. Replies
    11
    Views
    679

    Where are you calling this code from? Do you have...

    Where are you calling this code from? Do you have a VB main form with a ListBox object and a command button that runs this code?
    Not sure what that close() statement is doing towards the end of your...
  19. Replies
    11
    Views
    679

    I've been away from VB Express for a while but I...

    I've been away from VB Express for a while but I think (as you have found) that if lb is a ListBox object then the correct syntax for adding an item should be:

    lb.Items.Add("sometext")

    If your...
  20. Replies
    2
    Views
    391

    Not sure if macros allow error handling these...

    Not sure if macros allow error handling these days, but if you're using VBA make sure you turn warnings back on within an error handler, otherwise they'll be left off if an error occurs in the code!
  21. Replies
    10
    Views
    1,245

    Part of the problem may be that this is not the...

    Part of the problem may be that this is not the typical way that a function works!

    A function should be written in such a way as to return a value which can then be assigned to a cell value e.g....
  22. My own knowledge on this is fairly limited I'm...

    My own knowledge on this is fairly limited I'm afraid - I was hoping that it might be possible to identify the particular page element as you can with Javascript, and somehow manipulate that object...
  23. I can't see any jpg image I'm afraid. I'm out of...

    I can't see any jpg image I'm afraid. I'm out of ideas without a live website to practise on - perhaps someone with more web experience can help out :)
  24. Can you provide a link to one of the URLs in...

    Can you provide a link to one of the URLs in question and an indication of which dropdown box / value is involved, or is this a private site you are accessing?

    I don't know if what you want to do...
  25. In Access 2010, if I add a Web Browser control to...

    In Access 2010, if I add a Web Browser control to a blank form and leave it with its default name of WebBrowser1, then the following code demonstrates simple page navigation using this control (note:...
Results 1 to 25 of 217
Page 1 of 9 1 2 3 4