Search results for query: *

I'm looking for what I think is a System Profile Option within Oracle Financials that will allow me to open Concurrent Program Define at the same time as Concurrent Program Executables so that I can copy and paste from one to the other. I can do this in our Dev. Environment but we recently...

I am a newbie to Unix and sed so although I saw some posts that were similar to what I'm having problems with I couldn't get the suggestions to work with my problem. I am modifying a previously built .prog that has a sed command in it that builds an ftp command when the .prog is ran. My...

I am using PLSQL to call the Payables Open Interface Program. Everything runs rather smoothly except for the fact that the Payables Import will only import 15 records at a time. After that it gives me the errors The account created with overlay is invalid and Invalid distribution account The...

Hi, I am very new to Oracle and SQL Loader, this is actually my first sqlldr program that I have written. What I am wondering is why this does not work when it appears to work for everyone that I have found on the web. My Control File is below OPTIONS (SKIP = 1) LOAD DATA INFILE...

Hi, we recently converted to Access 2007 and I am having trouble with one of my forms. I currently have a form where you enter search criteria in and hit "Search" the form builds a query and then uses an unbound form to display the query results. However, when I login as a user this form is...

We are currently converting from Access 2003 to Access 2007. I have an Access app that is going to be very difficult to convert. This App is used by people that are out in the field and are a long distance from where our Access Databases are. So that is why we have Replication set up. So...

I created an MDE with Access 2000 but when I try to use this mde on a PC with access 2003 I get the following error: requested type library or wizard is not a vba project I have other MDE's that I have made with Access 2000 that work fine with 2003. And the MDE that errors will work if I...

One of our users is getting the following error when she tries to send out Auto Emails. This error comes up at the part of code "domSession.Initialize ("")", we use Lotus Notes 6.5.4. The Auto Email works on other pc's including mine. Her actual error is as follows: Microsoft Visual C++...

I'm trying to create a VBA Code that on open of a spreadsheet it will write to an Access database. The purpose of this is to track how often our spreadsheets are used so we can eliminate non-used reports. I need all the help I can get. I am currently using Excel 2003 and Access 2000. I can...

I am currently using the following code to open up lotus notes and send an email out. However, the code that actually opens Lotus Notes prompts me for a password everytime. I was wondering how can I pass a password through so I can automate this? This code (Maildb.OPENMAIL) opens notes and...

I have an auto email program that currently works on an older version of Lotus NOtes. Now I'm testing it on the version we are supposed to go to (6.5). And I am getting the following error when it tries to run this code: domSession.Initialize The error is as follows (One you hit ok it closes...

I'm trying to write an agent so that when I receive a certain email with a certain attachment Lotus Notes will Automatically detach the file and place it in a specified directory. Then launch MS Access for an update that needs to go along with this file. So far I've successfully detached the...

Hi, I'm trying to place a custom button in Outlook 2003 that calls some VBA code (that automatically detach's files to a certain folder). Problem is I can't find where to call the file within outlook. I can do it within MS Access (Custom). What can i do? Is there anyway I can program it so...

I have an access database that has been running with no problems (and no changes) since September 05. Today it started getting the following error: 34464 Application Defined or Object Defined Error. This is erroring out on a SQL Coded Append query that is in VBA. There is an append query...

I have a program set up on my PC that sends out automatic emails from MS Access via Lotus Notes. This program was running fine until I received a new PC today. Now when the program runs and it gets to domSession.Initialize("Password") I get the error "Notes Error: Could not open the ID File."...

I am trying to find the top 50 values per month from 3 years of data. Each month has over a 1000 records. Other than doing this manually how can I get Access to return the top 50 of each month? Here is the SQL for one query I ran. Which is just grabbing the Info for one particular month...

I have a query where I need to print a record that is located in the middle of the table first. I don't need to worry about any special sorting for the rest of the information. It's alphabetical the record starts with a "P" and there are 40 records within the table. I was wondering if there...

Why is this placed in a macro when you record it from Extra. Is there anything special about this code?

I have built a piece of code that enters Part Information into a screen, inquires on it, and if necessarry enters the necessarry information into the screen. However, i've found that i need to clear the screen before i enter the next part info into it. I was wondering how can i do this? Do I...

I'm trying to yank some data from Access and place it into screens in Extra. I basically have a long list of Numbers with a couple of other fields. So I need to have it cycle through the information. Can anyone help me get started?