Search results

  1. I

    Dos commands in Access vba

    You can use the Scripting (tools, references, microsoft scripting runtime reference) to loop through the folder A. For each one there, evaluate if the filename contains (let's say) .jpg in it. If so, add it to an array, then delete all files in array. Something like: dim fso as...
  2. I

    Can't update unbound textbox

    EllenR: Syntactically speaking, there is nothing wrong with this code: Me.numcomingtxtbox.Value = DLookup("howmanycoming", "numcoming") & " Coming" IF howmanycoming is the name of the COLUMN from the query, and numcoming is the name of the query itself. I have to guess that may not be the case...
  3. I

    Recordset vs. DAO.Recordset

    You absolutely should have it prefixed with DAO, use. Recordset is also an object in ADO, so if you had a library reference to ADO and it happened to be above DAO in the reference list, you'd have total chaos. Sure it may have worked in previous versions ... And it may work in later...
  4. I

    Run a Function

    pbaldy is correct - Run isn't what to use, (although application.run is possible, but doesn't make much sense unless you're automating access from another database or another office app) - just use the name itself. However, generally you use a function to pass a parameter to it and get back a...
  5. I

    Docmd.Echo not working

    I know this thread is old. But I wanted to add this note. This actually happens to me occasionally in access and A LOT in excel (where it's Application.Screenupdating=False). If you have a lot of code that would normally do a lot of aggressive screen updating, and that code starts really...
  6. I

    Using combo of Excel VB, Access--to create auto-letters in Word!

    you mean, look at word bookmarks to be used from wtihin Excel coding? see , there is so much information out there for how to generate letters in word using information already contained in Access FORMS. But my problem is, the informatino is not in a FORM. It will be queried. I want people...
  7. I

    Using combo of Excel VB, Access--to create auto-letters in Word!

    I have word, access and excel. I can handle basic VB coding in Excel, as well as writing Access .mdb queries in the design grid. I'm somewhat familiar also with basic Access built-in macros. I need to create and print letters in word, I want to get to the point where a user can simply...
Back
Top Bottom