Search results for query: *

Hello, I'm sure this will seem like a strange question, but I'm risking the possibility of getting flamed and asking anyway. I was wondering if it is possible to connect to another server and execute a SQL script from within an Oracle database. Specifically, I'd like to perform the following...

Hello, I am looking for some insight on how to create a Perl script which would allow for automated partitioning of an Oracle 10g database. Presently, partitioning is being done manually and this process is taking quite some time to complete due to the size of the database. Therefore, it was...

Mufasa, Thanks for the quick reply. I will try and answer your questions the best I can. The senior developer mentioned to me that she did not want any hardcoded values in my queries as the GENERAL_TYPE_IDs and the corresponding GENERAL_TYPES may change due to client requests (e.g...

Hi, I'm trying to determine the best way in which to replace an old query. The tables and fields that were used in the old query no longer exist due to database re-design. It has been suggested to me by a more senior developer, that I use DECODE or CASE. The old query is as follows: SELECT...

I apologize, I should have been more specific. I would like to replace the views with a package. I was wondering if it is a simple matter of inserting the SELECT statements that are currently being used in the view into the package structure. If anyone could post an example of a package which...

Hello, I am fairly new to the process of creating packages in Oracle and would like to know if it is possible to create a package which is based on several views. The views that are currently being used are not very complex but do contain some UNION statements. An example of how to create a...

Good morning, I am currently experiencing an issue with reports that are part of an Access 2000 project whose data come from SQL Server 2k stored procedures. The problem is that I can run the reports without any issues whatsoever but other users cannot run the reports without an error message...

Hello: I was wondering if there was any way to make a cell/field mandatory? I have a worksheet containing several cells that I would like to ensure the user completes. I'm familar with how to do this in Access, but for some reason, Excel has me stumped. Any assistance would be appreciated...

Skip, Thank you for the information. I apologize for not being more clear in my definition of a "form". I am not making use of a UserForm. The control resides on a worksheet. So, because control objects cannot be children of Window objects, I assume there is no way to prevent my combo box...

Hello, I am currently working on a MS Excel 2000 form which makes use of a combo box. The combo box is working properly for the most part, however, when a user scrolls using their wheel, the entire worksheet scrolls down and the combo box scrolls along with the worksheet. Is there any way to...

Thanks so much Bob! I used the form property setting of Allow Additions and set it to No. This solution was just what I was looking for. Thanks again, Scott.

Hi all, I am having a small problem with the navigation buttons on one of my forms. When I go to the last record and then click the "Next Record" button, I am taken to a blank record. This does not happen when I go to the first record and then click the "Previous Record" button. In that...

Thanks very much Greg. I just noticed that when I removed the control source. I will do an update query to make all the existing records have a "true" entry for that field and then test it out by adding a new record to ensure the default value works. Thanks again! Scott.

Hi, I have a simple Access 2000 form in which I would like to set the default value of a check box or radio button to checked/on. I have tried setting the default value in the properties of the object to Yes, True, 1, to no avail. The form still does not display the check box as being...

Hello, I am working on converting our Access 2000 database application to a SQL Server 2000 back-end with an Access .adp front-end. The conversion has gone pretty well so far, with a few stumbling blocks along the way. The most recent of these is concerning converting the reports that existed...

Thanks so much pyoungmwl! That worked perfectly! Scott

Hello, I have implemented a process within my Access 2000 application (with tons of help and info from the experts on this site!) that automatically sends an email to a specified recipient using fields from one of the forms within the application. The process works very well with one...

Good morning Sam_F and Carl, Thanks for your quick responses. I will be working on testing out both of your suggestions this morning. Thanks a lot guys and I will keep you posted as to how these suggested solutions work out. Thanks again, Scott.

Hello, I have an Access 2000 application that exports table data to an Excel spreadsheet. The spreadsheet is then manually edited in order to meet corporate standards before it is posted on the intranet. I have created a macro in the Excel spreadsheet in order to eliminate the manual editing...

Hi: I am experiencing a problem that is rather strange. I have an Access 2000 database that I have converted to an .mde for deployment to users in my team. The strange thing is that the .mdb file opens in approximately 5-6 seconds while it takes almost 40 seconds to open the first form with...