Recent content by Lagwana

Could someone please give me a run down on how to use the Immediate Window correctly?

The references are the exact same between the two.

Run Time Error 9: Subscript is out of range. I get this error when I try to run my module of ExportClassifieds. Public Function ExportClassifieds() ' Oct. 18, 2007 'VARIABLE DECLARATIONS Dim db As DAO.Database ' this database Dim rs As DAO.Recordset...

Quite possible, since it references to a CS5 application, I think. I am CS5 illiterate, so I am at a total loss. Also, this code was written a long time ago. Some of the words might be outdated and no longer work. (Code was originally for Access 2003 and CS2, then updated to Access 2007 and CS5.)

Ok, same code, different problem. In line "oPoint.Contents = words(0)" I am getting the error "Run-Time Error 9: Subscript out of range." Could someone explain that error in more clearer terms, Access Online Help is too confusing. Also, if you have a solution, I would not mind that either.

"User-defined type not defined." That is what error I am getting when I try to access my module for exporting classified ads (text only ads.) The error is happening on the "Dim oInDesign As InDesign.Application" line. Public Function ExportClassifieds() ' Oct. 18, 2007...

It worked. Thank you.

Yes, and Yes.

The text box is only showing the ID of the date in question. It is supposed to show the actual date. I would convert it back to a combo box, like the one in the box, but then I could not have it vertical, which is also vital..... Does that help elaborate a little?

The form has two fields that use the same information, one using a combo box, and the other a text box. They have the same source formating. How do I get it that the combo box information shows up in the text box? The GIF attachment is a picture of the form in its traditional format. The jpg...

Of course. The data at the top of the design view is the postcard, and the data underneath that is all haphazard is what needs to become vertical. I have not been able to do much with them, since I have no idea how to rotate them.

Actually, what I am trying to do is make the text read, if you turned the printed page 90 degrees, in the normal way, from left to right. There is two portions that need to be differentiated from each other. The first is a postcard style version that has all the data in a horizontal format...

Is it possible to turn text boxes and their labels 90 degrees in order for them to be vertical when looking at a page in landscape? If so, could someone please explain it to me? If this is impossible please tell me, so I can look for new things to try.

EDIT: The problem has been solved.

Neither of the codes worked. I tried the first one and got the same error. I tried the second one and got "Runtime Error '52': File could not be found." Thanks anyway. Any other suggestions?