Search results for query: *

Could someone tell me how to turn colored PDF into Black and white PDF? I do not want to use Image option because then PDF will no longer have tags and I cannot search for anything in the document. I have tried everything reasonable but Distiller keeps outputting colored PDFs. There must be an...

I apologize it is a Combo Box that I am trying to do multi-select. You can do this manually. I wanted to achieve it by VBA. I should have clarified.

Could someone tell me how to make a multiple selection by a single click on the Command button? I know it will be an event procedure on the CMD button but I do not know how to code this in VBA. The selection is always the same. Lets say that you see the following in the Dropdown(Combo Box)...

Hi, I have recently solved one of my problems of not being able to extract data containing over 255 Characters from Access Query. This was done by appending the query results to a table that has Momo fields to accomodate the long text field. Now I want to export this table with Memo fields to...

Anyone, I have been trying to output one of my quesries from Access using OutputTo method to diplay the content in Excel Spreadsheet which works just fine. After that I am trying to format Excel Spreadsheet(Coloring etc). What I dot not understand is sometimes it works when I step thru but...

I am using Outputto method in Access to output a query to excel spreadsheet by specifying a file name. My question is: "Is there a way for Access Application to Prompt a user when the same file name exists in the directory specified within the Output Method parameter? Right now, it overwrites...

Thank you very much for your response. You mean: You also may need to check the datatypes for a ADO recordset string query to see what its max size is? The resultant query is fine because I can run it in Toad. For the statement "rs.Open strSQL, strConn, adOpenForwardOnly" Is there a max size...

I spent whole day trying to figure out this error. "Operation is not Allowed when the object is closed" and came with no answer. What I am simply trying to do is set a cursor for this particular record set. I know the code below works with simple SQL statement but as soon as I put in very long...