Recent content by blah

  1. B

    Extracting content from an ACCDE Database

    If they can do it, then it can be reverse engineered, apparently. So how do they do it?
  2. B

    Binary_checksum

    That's a reply worthy of a Pulitzer.
  3. B

    Select ALL items in listbox

    12 years and counting.
  4. B

    Defining Primary Key from two fields

    PH to the rescue again!
  5. B

    Docmd.Transferspreadsheet acImport fine in 2007; in 2010, not so much

    May very well be, as Unicode is yet another layer of mystery in the Dark Arts. What goes on inside the transferspreadsheet process is a little hard to pin down exactly, I think. Anyway, further research suggests all roads lead to MSysImexSpecs...
  6. B

    Docmd.Transferspreadsheet acImport fine in 2007; in 2010, not so much

    Not sure if/how that fits in to it; how that plays into the "TypeGuessRows" feature, which seems to be the cause.
  7. B

    Docmd.Transferspreadsheet acImport fine in 2007; in 2010, not so much

    Yes, I've read that it will do the trick, but it won't be feasible here -- no tampeing with the data allowed.
  8. B

    Docmd.Transferspreadsheet acImport fine in 2007; in 2010, not so much

    Today's question involves running a 2007 accdb on 2010. Only one issue was noticed, to wit: The accepted process for importing xlsx data is via the docmd.transferspreadsheet routine. When this is run on 2010, a certain column of a very large spreadsheet is present, but its values do not come...
  9. B

    Create an MSGraph chart object

    Just used a modified version of Endre's method and thank you very much! ChrisO's thing is pretty amazing.
  10. B

    VBA code to create controls on a Tab Control

    Tweaked as follows...Function MakeControl(....) as Object . . . Set MakeControl = ctlCreate . . and it's still paying dividends a dozen years later. _______________________ the machines never forget
  11. B

    Make a hyperlink in a VBA created email

    It's the quotation mark thing. Try this: "<HTML><BODY><P>irrelevant words<a href=""" & "M:\Engineering\Cooling Dev\ACE\Cooling Lab ACE\Cooling Lab New 5S\New 5S\5S Self-Scorecard.mdb""" & "> Click Here to access the scorecard</a></P></BODY></HTML>" To include quotation marks in a...
  12. B

    ADODB RecordCount

    for example, blah = "SELECT * FROM someTable WHERE theMoon = 'blue';" as previously remarked, wdik? All i know is it seems like theRecordset.recordcount ought to give me something besides -1. It's frustrating when it doesn't. But DAO usually does, and that makes me content. I fully admit to...
  13. B

    ADODB RecordCount

    well, wdik but using theRecordset.open (blah) and then ?theRecordset.recordcount is useless as well. but as I said, wdik?
  14. B

    docmd.Transferspreadsheet acExport don't work in Access 2007

    a-roo roo Roo!
  15. B

    scheduled task for access code?

    I've never tried the access ribbon routine, and am inherently non-trusting of msfts canned procedures. plus, being a code-jockey, Friday's method is my method of choice. Or something quite similar to it.
See more
Top Bottom