Search results

I found a bunch on callback functions, but all of it is about filling the listbox with pre-existing lists (ie directory contents)... does anyone know if I can just have the callback function parse the string I've been using as the rowsource and somehow use that to fill in my columns? I can't...

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

Yep.

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

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

Okay, my problem was I wasn't calling to the Document object correctly. I made it WordObj.Documents(1).SaveAs and it worked perfectly. Thanks.

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

Yeah, I had thought about doing it, but I was trying to create the entire document from scratch from within Access. I ended up putting a long string of gobbly-gook into what was being exported to Word and then using WordObj.Selection.Find.Execute FindText:="@$#@$#***&", Forward:=True...

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

Got it! I didn't realize the default value that opened the report would automatically print it. I set it to acViewPreview and it works flawlessly. Thank you so much. Nick

Yeah, I'd tried that but hit some snags. Mostly, I can't figure out how to call to the Report I've opened in the OutputTo function. Here is my code: Private Sub Command32_Click() On Error GoTo Err_Command32_Click Dim DocName As String Dim WordObj As Object Dim RptWhere As String...

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