Search results for query: *

John, I got to looking at the Caption, and when we added the brand name and then the code, the part of the end of the caption was cut off. I am not sure if this moved the caption over and deleted it as we added this. Let me know what you think. Scott

Thanks alot, is there a feedback place in this forum that i can give to you? Thanks for all of the help, Scott

Sorry to bug you again, but we have another little problem. The code you gave me works great. In the database, our Names do not have the Brand in front of it with the code right next to that. I was wondering if there is any way we can do the following: Toshiba 24AF42 24-Inch FST Pure Flat...

Thank you very much for all of your help. Let me know if there is any way to give you a rating on anything for all that you have done. Thanks, Scott

Thanks a bunch!

Thanks, that worked! Do you mind if I send you the other database sample? Either in Excell or Access. Thanks, Scott

Would you mind looking at the other distributor's database that I talked about earlier. I can either send it to you in excell form or access. Let me know, and thanks for all or your help. Thanks, Scott

Access 2000

I put this in and now I am getting an error. It does not recognize replace. We also have another database that one of our distributor sent us. All of the description will not upload into our store right. We pretty much need the same thing done, but this one you can't even use the replace...

I sent the database to you. Thanks Again, Scott

Is there anyway i could email you part of this database, I will just have one record in it, and add this. I am still getting this error. I hate to bug you like this. Thanks, Scott

I tried that, and it is giving me a compile error. "Expected: End of Statement" I put that in like you told me, and added the name of the table "Discount Tools Master Inventory" in for the word table. Not sure how to fix this. I appreciate all of the help. Scott

I am going to sound stupid, but do I add following DoCmd.RunSQL &quot;&quot;Update Table Set Caption = replace (Caption, &quot;<li> &quot;, &quot;<li>&quot;)&quot;&quot; to the immediate field and hit run. I don't use macros much. After i hit run it takes me to macro name. What should i name...

Can you explain in detail how i would go about doing this. Here is one of the descriptions i need done, out of 2000. <li> 54.6 yds (50 meters) in a dispensing box <li> Foam tape designed to be used in masking jambs, hood or deck lid openings or other areas of a vehicle which need to be...

I am having troubles using the trim function on the my caption column in the table. I am inserting captions and need to delete the spaces in between each sentence. There are over 2000 captions, and would take for ever to each at a time. Can someone let me know how i can do this. Have a little...