Search results for query: *

Hi Can someone help with this...getting error: DoCmd.OpenReport [MPSonly], acViewNormal, [Print MonthPay], "", acWindowNormal DoCmd.OpenReport RptName = "MPSonly" outPutName = "C:\MyDebtIQ\Packages\" & Tbl![SendPackage-Dialer].[First Name] & "_" & Tbl![SendPackage-Dialer].[Last Name] & "_" &...

I have to execute the following command line in a access module and then run a access macro: \\Imsco\c\MsgParse\mpengine.exe /sx Then run macro I think I can do the macro part...but lost on running the above command line. Thanks, Ebiz

I have a linked fixed width table containing undeliverable messages from my email campaign. I need to strip out any occurance of an email address and append them to a table. Thanks Guys! Ebizleads

I have a 10 digit string...need to return the first 3 digits. Any ideas? 5088850155 Returns: 508 Thanks! Ebizleads

Hi, I may have a solution to an ongoing problem. I need to save a report in pdf. I found the great free program that prints to pdf using it as the default printer in windows. http://www.go2pdf.com It prompts me to save the document when I print to this printer. SO, I need some vba that...

I have a date that i need to return the number of days since today. For instance the date may be 2/20/06 and I need the query for return a value of 3....since today is 2/23/06. Thanks! EbizLeads

hmmm....I plugged this in and everthing went to 12:00am. Int((8/1/2005-8/1/2004+1)*Rnd()+8/1/2004) Thanks for your help! Ebiz

I need to update a date field with a random date between a date range. How do I do this? Thanks! Ebiz

I have data coming in from a source and it looks like this: Address=22+England+Ave. How wold I take the Address= and the + out of this? Just want it to look like: 22 England Ave. Thanks! Ebiz

I have some values in my date field that include the time of the record...need to clean this up. Would like for the format to be: MM/DD/YY How would I update this field to do this? Thanks, EbizLeads

I'm recently moved my db to another machine running Access 2003. My old machine ran this fine on 2002: StrConv([First Name],3) On the new machine, I'm getting the error Undefined Function. Any clues? Thanks, Ebizleads

I have a sales team that I need to assign leads to as they come in. Ideally, I'd like to update lead record in the Leads table in the [salesperson] field. The sales person is retrieve from the Sales Team table. What my best approach to rotate this value fairly? Thanks Ebizleads

Yes, thanks so much for the valuable information. Looking into the cuteftp and the graphics export help would be wonderful! Ebizleads

I'm using the following to output a report to a directory. The report is missing graphics (lines, rectangles) and embedded objects. Any way to overcome this? DoCmd.OutputTo acOutputReport, "CounselorReport-Fresh-No Dial", acFormatRTF, "C:\MyDebtIQ\C-Reports\" & "Fresh Leads" & ".rtf" Thanks...

I would like to take my [First Name] field and capitalize the first letter. Would also like to take the [Address]and do the same, but this field has more than one word in it. Would like to capitalize the first letter in each word here. Any ideas? Thanks! EbizLeads

I have phone numbers in my table that I query that are 10 digit strings. They have to be this way to load into software to dial. However, I want to have a query output to: ***-***-**** How do I do this? Ebizleads

It runs another macro that runs this code: Function EPack() On Error GoTo EPack_Err DoCmd.OpenForm "Main Lead Console", acNormal, "SCEmail", "", , acHidden DoCmd.OutputTo acOutputReport, "EPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" & Forms![Main Lead Console].[ClientID] &...

How do I write an expression to stop a macro if a query returns no records? EB

ok...figured this out-FYI. Had to reference the form in the following: DoCmd.OutputTo acOutputReport, "EmailPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" & [Last Name] & "_" & [First Name] & ".rtf" To: DoCmd.OutputTo acOutputReport, "EPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" &...

I'm running this function from a macro and get a Type mismatch error...any idea why? Function EPack() On Error GoTo EPack_Err DoCmd.OpenForm "EmailPackage", acNormal, "SCEmail", "", , acHidden DoCmd.OutputTo acOutputReport, "EmailPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" & [Last...