Search results for query: *

VALUE=`sqlplus -silent user/password@instance <<END set pagesize 0 feedback off verify off heading off echo off select name from t1; exit; END`

Well the variable is set by a select stsement MACHNAM=`sqlplus......` How would you do it now?

How do I pass a variable into a consub which contains spaces??? I need to retain its form (like MACHNAM below), not to be broken up. MACHNAM=THIS HAS A SPACE Example: CONCSUB ${FCP_LOGIN} XXCA 'CUSTOM INTERFACES' KRAMER WAIT=10 \ CONCURRENT XXCA XXCLICDLAA "${COMPANY}" "${TWO_TASK}"...

Hi All, I need some ideas.... Back Ground: - I need to add a company logo to AR statement in in Oracle Reports (ARXSGPO.rdf) - We only have the ability to print Text output - Using Develper 6i - Can not import image, can not use Link File boiler plate My only option is to use an image overlay...

I figured it out. I had to put in the forms ok button click sub code like the following. Forms![form1].Form.Requery

Hi, My Issue: I have a data entry form (form1). When user is done entering their data they press an export button. This button opens another form. This new form (form2)has another command button which preforms several steps, creates a report, updates some tables, removes data from backend...

me.requery won't work. I am using a macro call throug the buttons property window. The macro calls the second form (modal). When you hit ok on the second form it goes through a series of vba commands, then closes. The first form never closes. It sits in the back ground and I guess becomes...

Where would I put that? How?

I am having an issue with the word #Deleted being displayed in my text boxes on a form. The form is a data entry form. User enters data on the form which is loaded into an ACCESS table in the same database. When records are all entered by the user a button is pressed which trggers a few...

Awsome help! All is working as suggested.

That creates the log file! Awsome help! Do you have any code suggestions to read the log file? Search for code 226 transfer complete? I have no experience doing this. Once again, awsome help!

sExe = sExe & "ftp.exe -s:" & q & sScrFile & q & " > c:\ftp_log.txt" didn't work. I would be hard for me to do it in notepad because variable are created in the access app.

Hi AccessGuruCarl, I apreciate the suggestion.... I have tried: sExe = sExe & "ftp.exe -s:" & q & sScrFile & q & "> c:\ftp_log.txt" And it does not work. The file does not get transferred nor does it create a log file. Any other suggestion?

I have looked into the trace sub command but am unsure how to add this to my code. Do you have an idea?

I commented out the DoCmd.Echo command and that appears to have worked. Thanks! Whats the point of this statement if it causes freezing issues?

...As String Dim sLocalFLD As String Dim sArchiveFLD As String Dim sArchDest As String Dim sSource As String Const q As String * 1 = """" sLocalFLD = DLookup("LocalPath", "tblDirectories") sArchiveFLD = DLookup("ArchivePath", "tblDirectories") DoCmd.Echo False...

...Dim sSource As String Dim sArchDest As String Dim iFile As Integer Dim sExe As String Dim sFTPErrLog As String Const q As String * 1 = """" On Error GoTo Err_Handler sArchiveFLD = DLookup("ArchivePath", "tblDirectories") ' will break if empty folder exist...

Beauty! Works perfect. Thanks!

Hi, I want to assign a variable to a value retaine in a table. I am unsure how to do this. sUID = "SELECT tblTransferInfo.User FROM tblTransferInfo;" MsgBox "UID: " & sUID I want the value for the Field User to display.

...Dim sScrFile As String Dim sSource As String Dim sArchDest As String Dim iFile As Integer Dim sExe As String Const q As String * 1 = """" On Error GoTo Err_Handler sArchiveFLD = sLocalFLD & "\ARCHIVE" ' will break if empty folder exist so error to pass '...