Search results for query: *

Some of the descriiptions in one of the table contain the ampersand sign &. When I do a "echo $Desc" in php, it cuts off at the & and the rest of the string is omitted. Is there any work around? Thanks.

I have this sheet that I download a large number of rows of records from another program everyday. I programmed in the delete rows to clean up old record before copy/paste the new record into the sheet. The sheet has 20 columns of data. This will work for a while, but after a month or two, the...

As I am learning more about using vba in Outlook, I've learned that quite a few of the functions and methods are available to Outlook Exchange. We don't have Outlook Exchange. My Outlook 2003 is part of the MS Office 2003. We use Pop3 to poll mails and send mails thru my ISP @att.net. What...

We created a vba routine in Outlook. It ran in when we developed it. Now we save it, created an icon in tool bar and when we wanted to run it, it said we have to enable macros. But there is nothing in Option to let me enable it. Do you know how? Alex

I am proficient in vba (primarily in Excel) and vb6 but never done any coding in Outlook. I need some help to get me started. Here's what I want to do: I have the preview option/window open in my outlook, when I highlight the message in the inbox, I can see most of the content in the preview...

I am quite proficient with vba in Excel and VB6, but I've never written any code in Outlook. I do have a need to create some macros in Outlook. I constantly have to type a few sets of canned answer to customer's inquiry. I would like to create those answer in a module and create an icon in the...

I have a routine that send emails thru Outlook (using Redemption). When Outlook is not open, the mails will go to the inbox instead of being sent out. I would like to write a block to detect if Outlook is already open, if not open it. Can someone help please? Thanks. Alex

I posted a question regarding auto response rule and was not gettng any response. Do anyone know if there is other forum I can post the questions? Alex

We run a business in the interenet and have a very large email pst file. It would be nice if the outlook program, or at least the pst file is installed on a portable hard drive so I can carry it from office and home. I think I tried it once and when I took it home, the computer at home can...

We set up rules to Auto respond to a certain type of emails we receive. These emails come from Paypal and most of the time it has the member's email address on the "Send from" area. But, some of them has the following there "sendmail@paypal.com; on behalf of; xxxx@xxxxx.com ". If we hit the...

We set up rules to Auto respond to a certain type of emails we receive. These emails come from Paypal and most of the time it has the member's email address on the "Send from" area. But, some of them has the following there "sendmail@paypal.com; on behalf of; xxxx@xxxxx.com ". If we hit the...

When I am in Excel and want to record a macro, there used to be a pop up so I can click to stop the recording. I must have clicked the x on that pop up, now the icon doesn't come on anymore. I have to go to the menu to stop the recording. How can I bring back the pop up? Thanks. Alex

Right around the time Microsoft introduced .net, I got out of the programming field as a professional. My training basically stopped after VB6. I've been using VB6 and VBA to develop applications that help me in my business. And it works just fine. Recently, eBay gave me a block of workable...

I have the following code in my Excel. It worked perfectly until I install Norton Internet Security 2006 yesterday. Here's the code: Sub RedemptionMail(xAdd, xMsg, subj) Dim SafeItem, oItem Dim OL As New Outlook.Application Set SafeItem = CreateObject("Redemption.SafeMailItem")...

I have the following code in my Excel. It worked perfectly until I install Norton Internet Security 2006 yesterday. Here's the code: Sub RedemptionMail(xAdd, xMsg, subj) Dim SafeItem, oItem Dim OL As New Outlook.Application Set SafeItem = CreateObject("Redemption.SafeMailItem")...

I've done it before but forgot it because it's been a while. I want to create a bunch of routine (sub's) which I can use in all my other worksheets. For example, I want to create a button to auto fit all the columns in any workbook I open. I don't want to duplicate that sub in every workbook...

I have a screen where the datagrid is tied to adodc recordset. After I deleted a record from the underlining table, I want the datagrid to refresh to omit the record that was deleted. I use the data.refresh and datagrid.refresh command after the deletion query was executed. The datagrid would...

The following example read the first line of the file, which contains multiple lines. How do I move to the next line? Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile("C:\Endicia-output.prn", ForReading, TristateUseDefault) x = f.ReadLine Thanks. Alex

I have an adodc object in my form. When I execute the following query statement using openrecordset statement, I have 400 records. I got the same number of record when I use the adodc.recordsource/ adodc.refresh statements. SELECT Inventory.Description, Sales.ItemNo, Sales.SalesDate, Sales.Qty...

I have a form with a width of 15000 and an object inside the form with a with of 14000. It works fine for a while. All of sudden, at design time, the form's width shrinked to 13200 and I cannot adjust the width either by dragging the form in design view. If I launch the code, I can make the...