Search results

  1. N

    Listbox rowsource maximum length

    When running some overly general searches I repeatedly get an error that my RowSource property string is too long. Does anyone know the maximum length for this property? Better yet, does anyone have any clever way of fooling it into not existing? Cheers, Nick
  2. N

    Columns and commas in listboxes

    I want to display currency values in one column of a listbox, but the commas kick the zeros to the next column. I thought this was unavoidable, but the help file says that records should only be seperated by semicolons, not by both commas and semicolons. Is this just something that was left...
  3. N

    Modifying Table From Form

    I don't know why this of all things has got me so stumped. I have a textbox (Text37) that will take a single digit integer. I have another Integer (CurrentID) as well. I have a Table ("Article: Ratings"). The Table has three fields (Rating, Article ID, Primary Key). I need a piece of code...
  4. N

    Word SaveAs - Method not supported?

    For some reason when I try to use Word's SaveAs method from Access I get an Error stating that the Method or Process is not Supported by the object, which is silly because I can clearly see in Word's library that it is. I've been using WordObj.Document.SaveAs to no avail, I've also tried...
  5. N

    Inserting File into Word - Setting Selection

    Hi, Well, I've hit another roadblock. I need to, from access, insert a file into an already open word document after a certain line of text. I am new to VBA and I simply don't know how to tell word where I want this document inserted. I know I should use the select method, but I am not sure...
  6. N

    Putting a single record into Word

    Hey, I've got a (most likely) simple question for anyone with the time to answer it. I have a report set up and I want to be able to export a single record to a word document. I know how to export a report with OutputTo, and I know how to open a single record with OpenReport, but I can't seem...
Back
Top Bottom