Replies

I found a solution! I’m doing a refresh on the form in the after_update event procedure of one of the bound controls. This causes SQL Server to assign the id and shows it on the form.

Thank you, Hans!! Despite the fact that the column contained dates formatted in 2 different ways (i.e. a) 100103 b)10/1/03), the Text-to-Columns feature worked to convert the entire range to dates. Kudos.

Thank you, Hans!! Despite the fact that the column contained dates formatted in 2 different ways (i.e. a) 100103 b)10/1/03), the Text-to-Columns feature worked to convert the entire range to dates. Kudos.

Thanks guys. I appreciate your help. I got the task done by creating a macro similar to John’s. I guess there isn’t any built-in Excel function that would have done the work for me, huh?

Thanks guys. I appreciate your help. I got the task done by creating a macro similar to John’s. I guess there isn’t any built-in Excel function that would have done the work for me, huh?

Thanks for your help, I’ll have a go at it with the clues that you gave me, and hope for the best!

Thanks, John. I’ll post it to the VB/VBA forum. I’m actually not looking for a step-by-step, how-to answer. I just would like to know if such a thing is possible,and if so, can someone point me in the right direction. Thanks for your help, though.

Guess what? The problem was in the vbcrlf that I used to place various parts of my string on new lines. The vblf part was indenting the line by one space. When I changed the vbcrlf to vbcr, problem was solved. I really don’t understand this because from what I know, a carriage return just takes the cursor to the beginning of the line, it’s the line feed that gets it to the new line. However, if this worked, I can live with it!

Thanks for the help,
Taibe

Thanks for the tip, Stuart. I did “view all” and found a lot of things that needed fixing in the template that I’m working with. I received this template from someone else, and did not realize there was so much “gobbledy-gook” in it.

Thanks, I’m not deleting Section objects, just my own definition of sections within the document. Actually, I’m marking off the sections with text in brackets eg. [Title Page] (before the title page section) and [end title page] (at the end of it). I was deleting everything from the first [ to the final ]. Now, I got smart and am deleting everything from the ] of the end of the previous section to the [ of the beginning of the next section (providing of course that they’re not the first or last sections of the document. It seems to be working better now.

Thanks, Leif – good point re: the hidden info. I passed your response on to my boss, and we will seriously consider the pdf option. I hope that there is a batch conversion facility – that will save a lot of tedious work.

Taibe

Actually, it’s not important that it should be in Word at all. The user just needs to view it, not edit the document. The question really is whether to make our client convert all of his word docs to pdfs in order to create this website. Is there an easy way to do this? Does Acrobat have to be purchased in order to do this?

Thanks for the help,

Taibe

Thanks, but it didn’t answer my basic problem. How can I show this Word doc to my users without making them change settings on their computer? If there are hundreds of users, I can’t make them all change their computer settings.

Taibe

John,

Thanks for your reply, sorry it took me so long to pursue this. The problem only happens in Outlook – not with any other Office program or any unrelated program. It’s hard for me to believe that a hardware issue would only show up in Outlook. I ran a defrag and a disk cleanup and now OL seems to be behaving, so I’ll just pray that it continues to do so, for now!

Taibe

Thanks all for your input, help, and support. Unfortunately, my Dell computer shipped with Windows XP home, not pro, thus, the problem. I’ll have a look at the web server(s) you suggest. I don’t necessarily need to use frontpage to create my asps. I actually loaded frontpage onto my computer under the mistaken notion that I could run asps locally from frontpage.

Thanks again!