Search results for query: *

thanks :)

how do you do a standard input prompt with a shell script?

here is what i ended up with come to find out if i grab just the surcharge totals i am g2g #!/bin/sh awk '/DATE OPENED/,/MERCHANT 00002726/' jan.txt > jan1.txt awk '/DATE OPENED/{id=$2} /SURCHARGE TOTAL/{print id" "$5}' jan1.txt > testem.txt

How do I print all of that information for only the items between /DATE OPENED/ and /MERCHANT 00002726/ ?

nm I figured that out by adding /E N D/{stop} to the end

done... how would i make it stop at ********** E N D O F R E P O R T F O R P R I N C I P A L 1 0 0 **********

well it worked... but i have no clue how it worked lol please help me understand! :)

oops the end was cut off... The record begins with 00002726xxxxxx and ends with the line 00002726xxxxx. I need to take that 00002726xxxx number and use it as an identifier. After that I need to pull out the number corresponding with SURCHARGE and match that up with 00002726xxxxxx. But NOT...

Good morning heres the issue. I have a text file with many records in it formatted like so 0000 0000272600111 MERCHANT 01/31/06 SERVICE REP.. DATE OPENED 09/09/03...

nm I fixed it.

That worked. I used an On Error statement. Heres the problem now. I have this function run in a macro like so RunCode Function just created RunMacro Which opens a macro that runs a series openqueries And some more stuff... It validates the table and then quits everything... here is...

that works like a charm. now I need to have it run a macro if the table doesn't exsist at all.

it errors on Data = DoCmd.RunSQL SQL

here is what I have so far Option Compare Database Dim SQL As String Dim Data As String Sub query() SQL = "Select FIRST(OtherFee) From OtherFees" Data = DoCmd.RunSQL SQL End Sub Function VerifyIT() query If DataGrid1 Is Null Then DoCmd.RunMacro "stop" End If End Function

Afternoon, I need to create a module that will stop a series of macros with an error if a specific table is empty. I am not sure how to go about setting this up.

DoCmd.TransferText did the trick. I didn't see anything under DoCmd.* that might allow me to ftp something though... Am I chasing my own tail on this one?

oh and for an added demension of fun after it is done I need it to be ftp'ed to a specific ftp server.

I need to create a button when on click it exports a table to a CSV file that is comma deliminated and has double quotes for field qualifiers. The name of the file must be addmmyy.csv ie for today it would be a022306.csv. I don't even know where to begin. Any help would be appreciated. Thanks!

We are looking for a quick and dirty way of doing inventory control. We want to be able to print labels for a specific serial number on the fly. It looks like the bar code font should accomplish what I am looking to do.

Does access have the inherit ability to create bar codes or do I NEED to purchase third party software to make it happen?