Search results

Just a little background why I need this. I am trying to run this query so that a user won't have to enter anything manually. I am going to have this running on our server every week for the prior week's data. That is why I am trying to get this date criteria to work. Thanks for any help.

Thanks for the response FoFa, however, it isn't working for me.

I am trying to have a criteria of Between Date()-7 and Date()-3 in my query, however, it isn't returning any data. I also have tried using datediff, but without any luck. Could someone shed some light on what I may be doing wrong? Thanks

Correct, but how can I say take Expr3 -1 to take the ")" out to only get the value? Thanks

I have the following expression: expr4: IIf(InStr([expr3],")")>0,[expr3],[tick]) The above expression is returning this result: TM) How can I write an expression that would remove the ")"? I can't use the left function because the field varies in size (I've tried). I have tried : expr4...

Bob Have you been able to work on the text file?

Thanks Bob.

Sure. As you will see, some of the files won't have a ";" comment line. Thanks

Bob I have attatched an example of the information. I have tried to get everything on one line, but I haven't had any success. Thanks for your help.

I have the text file linked as a delimited file and using a query off of that table. This file can have anywhere from 100 to 1000 entries.

Yes, we get this report from another vendor and it comes accross this way.

But how would I get all of the information on 1 line (i.e. the same field) like: 12345 ;This is the comment line.

I thought of that; however, it is in the same field as the account number (from the text document). If if was in a different field, I can see doing a concatenate, but since it is within the same field, I can't do it.

I have a text document that is linked and am trying to run a query off of that document. I have all of my queries working great except for one thing......if a comment line drops to the next line, I'm not able to capture it. Example: 12345 ; This is the comment line. I need to get the comment...

The error is being caused by the following code> DoCmd.SendObject acSendReport, "Transaction Notice", acFormatTXT, "", "", , "Transaction Notice", "The following dividends and fees were reported on today's report." & Chr(13) & Chr(13) & _ Chr(13) & Chr(13) & "Thank You" & Chr(13) & Chr(13) I...

Yes, I am trying to capture or Trap error 2501 I was trying to use if err.number=2501 then ' Do nothing else docmd.sendobject acsendreport,"................" But it isn't trapping the error.

I have a report that suppresses if it has not data in it (cancel=true.....do nothing). However, I am trying to send the report through sendobject and it works well until there isn't any data to display.Great! it works, however, it throws an error message asking me if I want to end or debug. How...

rainman thanks for your help......

Hello, I have the following code kicking off an email based on a query result: DoCmd.SendObject acSendReport, "Transaction Notice", acFormatTXT, "jams@corwell.com", "sweeny@corwell.com", , "Transaction Notice", "The following fees were reported on today's report." & Chr(13) & Chr(13) & _...

Hello All I am trying to import an Excel spreadsheet using the docmd.transferspreadsheet method ; however I am getting a "Can Not Decrypt Data" error message. I have narrowed down the source of this error message to be my shared workbook. I have to unshare the workbook to import it into...