Search results

  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.
  16. B

    Error 2427

    ' oh get over it. maybe you should have been a paramedic.
  17. B

    Error 2427

    { "excellent" }
  18. B

    Save images as raw-binary (BLOB) data

    very helpful answer. gawd, somebody give this guy an award.
  19. B

    Filtering split form records from combo box

    Bob, you're amazing, and I want to thank you for all your contributions to the developer community. Now then, how does one govern the behavior of the combobox on the datasheet side of the split? Does it not act weird? It seems to want to apply the selection to all the records, not just one...
  20. B

    Can we programmatically set the default ribbon?

    I don't think that works. Ribbons are loaded automatically -- making them "available" to choose. If the desired ribbon xml isn't in the database, that command will put it there, but it won't "launch" the Ribbon. It appears the question is "how to choose the ribbon programmatically." I've...
Back
Top Bottom