Search results for query: *

Hi, I'm trying to create a sproc that is using parameters for dynamic field names. The following sql statement is causing problems with using the sproc parameters in the GROUP BY clause. Is there a way around this apart from writing an IF statement for each field iteration. SELECT...

Hi, I have a general question regarding the crystal RDC and VBScript. Currently I'm using the Crystal API to automate the running of over 500 reports which are exported to a file server as pdf. I'm using a VBA app on a workstation but now its time to migrate to the RDC and run these suckers...

I'm a VB programmer just starting to get to grips with crystal formulas. I created a formula field @myField and I need to assign it's value based on another fields value. I tried a simple select case but I keep getting the error "Statement expected here" Select Case...

This seems like a basic question but unfortunately it's not obvious. I want to display the sender's email address in my inbox without opening the email. I'm not interested in the sender's display name because it's easy to spoof. I have checked the "field Chooser" with no luck. Thanks...

Hi, I'm trying extract the email address from a message without using CDO (this is a client side macro that strips the message down and inserts it's key elements into a db table). The closest thing I've fouund is Outlook.mailItem.SenderName which only returns the name and not the address within...

I'm trying to convert a string in the format "2002-03-04 00:00:00.00" to a Date format. I have tried CDate(val(Mid({Query.Edate},6,2)), val(Mid({Query.Edate},9,2)), val(left({Query.Edate},4))) but get the error "A month number must be between 1 and 12" Thanks in advance.