Recent content by automaticbaby

That worked! Awesome!!!! Thank you SO much for your help!! This is not a big deal, but when the link shows up, it looks like a generic gray icon and not the icon of the Word document. Any ideas on how to fix that?

taupirho, Your new line works to help view the form/document and I was able to incorporate most of my old code into the code you provided. I'm still missing something though because it's not creating the link. Everything I read uses Attachment as a variable or a field name. I don't know when...

taupirho, Thanks for your help. Let me start off by saying I'm very confused. I'm trying to attach a link to a document in Lotus Notes (so that in the end, in the field of my choosing, there is a Word icon that when I click on it will open the document where it is actually stored), but all I...

I should have added that I searched endlessly and all I can find is info on how to send an email with an attachment using Lotus Notes. I cannot make the code you linked to work with what I'm doing. I don't really know much about Lotus, but, for example, the like in that code that reads...

I have searched endlessly for some help with this, but so far I have not come across anything useful (or maybe I'm missing something). From Access, I am trying to open a database in Lotus Notes, open a new document and fill in some of the fields and attache a document. I have been able to do it...

I have a form that has a query as the record source. The query combines about 8 tables. Some of these tables have repetative field names, like First Name, Last Name, etc. I have code to open Word and populate bookmarks in Word. Here's the code: .Item("NominatedPerson").Range.Text =...

Herman, I'm not sure I understand what you mean with the original master link. On the other hand, what you've described is exactly what I want, but I don't think I need the check box. I've taken you code and adapted it, but I get an Object required error. This is what I got...

I have a form with a subform that shows all the records in one table. I would like the form to show the record I select/highlight from the subform. If it's possible, how would I go about having the form show the selected subform record? I think what I'm aiming for is having the selected...

Thanks for all your help guys. I figured out my problem as I was questioning if I was missing something. Apparently I needed to reference the Excel Object Library. To quote George Costanza "I am Costanza, King of the Idiots!" Thanks again for the suggestions. Albert

Yeah, sorry about that, Skip. I need everything to the right of the ( gone. I only want the number. PH, I'm not sure about the destination, but it works in Excel. I would think it would carry over, but what do I know, since I can't make this work.

I've recorded a macro in Excel and even adapted code from an old thread (1033329) but neither has removed the unwanted data. Here's what I've got: With oApp .Columns.("J:J").Select .Selection.TextToColumns _ Destination:=.Range("J2"), _ DataType:=xlDelimited, _...

Thanks, Skip. Not the answer I wanted to hear, but it does solve my problem.

The problem I'm having is analyzing the expression. Currently, I'm stuck on getting MATCH to work. I get a Type Mismatch error when I combine the 3 cells, but when I do each of them individually, to see where mismatch occurred, it works fine.

Sadly, no. For me, protecting the cell is a pain in the a$$. And then trying to remember passwords? Forget about it! In the end, though, I would like to have just a Yes or No appear in the cell, not the formula. If that can't be done, then I would at least have the formula in the code so...

I have a really long formula that works in an Excel spreadsheet, but I'd like to get it out of the cell due to people accidentally deleting it... continuously. I'd like the cell to only show the end result (yes/no). Is there a way to convert the formula to VBA? Here's the formula (broken down...