Search results for query: *

I used Oracle Developer 6.0 with Oracle DBMS 8.05. I have been running Developer 6.0 with Win2000 for months but this week I switched to a different PC. I now getting the following error (in the sqlnet.log file) after running a form, or after running a SQLPlus command. I reinstalled the...

How do I turn off the Confirm Record Changes, Confirm Document Deletion and other confirmation messages in an application (the run time client)? I know how to turn off the messages in the DFull Access client, but I can not figure out how to make that setting go down to the run time. Any...

I am trying to copy a file in Oracle Forms 6.0 using the Host command. An example follows. HOST ('COPY longfilename.txt longfilename.bak'); The command does not appear to work if the filename is longer than 8 characters (it must be using the DOS 8.3 format). I welcome suggestions or possible...

I am looking for hints on how to and/or sample code for Forms (6 or 6i) that can be used to perform a listing of files in a Windows Folder and then to click on a file and select it? Thanks. Mahatmt

I have created a LOV. In the block (which is the first block), I am using a field to query the record and have the LOV name property set to the LOV and also marked validate using the LOV. The LOV pulls the correct data, but the field is allowing records that are not in the record group. Any...

I have used the Add_parameter command (afer creating the parameter list) to a Forms trigger. The parameter is called pf1 and I pass a value from the form (:block.fieldname). I created a parameter in the Oracle Report and call it with Run_product, but when the report invokes, the parameter...

I have a main form and a sunform that is a spread sheet type display. The rows contain data with a date. I would like to make all rows where the fields are Enabled = False if the date has already passed. I welcome suggestions on the most efficient way to do this (I assume it will be with...

I want to hide a feild on an Access 2000 Report. I have done this before, but for som reason can not get it to work. I have a hidden field on the report. if that field is NULL i want to hide other field, but it does not seem to work even though the debugger steps through it and appears to...

I want to create a runtime application with MS Access 2000 (has some VBA code also). I know I can generate a MDE, but do I also need to link tables to a another database in order for multiple users to use the application. Let me ask a different way, in quick terms how do I generate a runtime...

I know you can use the SendTo command in the Reports/File menu to send a report by Email, but this does not appear to send the report exactly as it appears in the report viewer. For example (when using a RTF format), lines are not shown. Also, the company symbol shown as an image on the Access...

I am using the DoCmd.OutputTo method with the RTF format. The document is fairly long. I would rather not have page breaks. Is there a way to turn off page breaks either in the code or in the RTF file setup? [my code: DoCmd.OutputTo acReport, stDocName, acFormatRTF, strfilename, False]...

Is it possible to open an Access Report (called by the DoCmd.OpenReport action) in a reduced zoom so that the entire report is viewable without scrolling of chaning the Zoom with the Fit setting? I have a landscape report that is large than the screen resolution when it is first opened. Thanks.

Is it possible to append to an existing file using the OutputTo action. The file type is RTF? Thanks. Mahatmt

has anyone integrated Goldmine (ver 5) with Access VB (such that a contact entry made in one can be updated in the other)? Thanks. Mahatmt

I want to show a date in YYYYMMDD format. The date is stored in the Short format as mm/dd/yyyy. Would I format the date in the Query SQL select statement or in the Control Source parameter for the report field? What is the correct syntax for the reformat? Thanks. Mahatmt

I have a form with a combo box to retrieve a list of customers but the form also has a button that calls the New Customer form. I can go to the new Customer form and enter a new record. i then issue a combobox.requery command, but the box is not required (until I oerform a cancel on the...

I have a report that resembles an invoice. It can have multiple line items that can expand (grow) in size depending on the size of a Description field that is included in the line. The total of the line items print in the Footer section. In some cases, all of the line items print on page 1...

Is it possible to incorporate a Combo Box in a form that allows users to select existing data (I know that is possible) but type in a new value that is not found in the list? Thanks. Mahatmt