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?

Hi, My application is freezing up. I am unsure why. I am running the following code. Form frmfrmDataEntry is open, a button to create a file is pressed and Form frmExportWarning is opened. I hit OK button on the frmExportWarning and then a FTP form is to open but it does not appear and the...

I guess I should upload the other functions that are called. This all works but I need to error trap. Module API_Functions: Option Compare Database Option Explicit Private Const STARTF_USESHOWWINDOW& = &H1 Private Const NORMAL_PRIORITY_CLASS = &H20& Private Const INFINITE = -1& Private Type...

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.

Hi I am executing a statement which calls ftp.exe. I am unsure how to error handle. It works when the proper user name and user id are entered. But if wrong user id or password is entered I have no error handling. How can I capture the output of the attempted ftp? And determine if the...