Recent content by accessforum93

I am having problems opening my Microsoft Access 2007 in Windows Vista. I am getting mscomct2.ocx error message. If I am required to install mscomct2.ocx file, which free link can I get it.

Unfortunately, I was unable to get enough information. I mean ran into a "dead end" solution. Thanks for your help anyway.

Thanks a lot. I will try it.

I tried it, but it did not work. This is driving me me crazy. Thanks a lot

Do you have any suggestions on how to solve this problem? I need your help. You have been very helpful. Thanks!

VBAInet, I declared the original field as a memo datatype. However, the calculated field does not have any datatype assigned to it. I displayed the Product_Decription field before using it as part of a calculated field and the entire data was displayed correctly. Is there a way I can assign a...

VBAInet, Thanks a lot, but what does Nz represent? It is partially working, but it is truncating some fields. Oringinal Query Data: Product_Solution <ul><li>The certificate names (axebrandguide.com, secure.axebrandguide.com) do not match the host's fully qualified name.</li></ul>...

Rick_A, Thanks a lot, but it did not work. I created a calculated field (e.g. Detail_Run: Replace([Product_Description],"$Detail",[Product_Solution]). The output looks like the below: Original Data: Product_Solution Product_Description 888 THNopl This...

I have two columns from MS Access query result. The table columns are: Original Result Query Result: Product_Solution Product_Description 888 THNopl This product have an invalid $Detail key solution I will like the final query result to look like: Final Result...