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...

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...

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...

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...

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...

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...

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...

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...

Good afternoon: I am interested in finding out how I may replace values in a table using an external text file (.csv). Currently, one of our tables stores hyperlinks to documents located on one of our servers. Our office is moving locations and therefore, the server storing our docs is going...

Hello, The Access 2000 database currently used by my team has several reports that are run on a daily basis and then posted to our corporate intranet site. The process used at this time is basically as follows: 1. Macro creates temp table based on query. 2. Temp table data is exported to...

Hello, I have a function that obtains the user name of the current application user. For testing purposes, I have set the control source of an unbound text box to display the function results. What I would like to do is to make use of this function to apply some simple database security...

Hi, I am attempting to add a new item to a combo box. On the NotInList event, I have the following code which brings up the error "Error 13:Type Mismatch": Private Sub cbo_Building_NotInList(NewData As String, Response As Integer) Dim wrkJet As Workspace Dim dbFCSData As Database...

Hi, Recently I received excellent info from Zathras and some other members on developing a comparsion procedure to compare two Excel spreadsheets and exporting the exceptions to a new spreadsheet. I would like to automate this process and to do so, I would like to perform the following (I...

Hi, I am looking to compare the values of two MS Excel 2000 spreadsheets. I would like any exceptions to be exported to a separate spreadsheet. Therefore the basic logic breakdown would be as follows: - Compare spreadsheet A and B - if values are the same do nothing - if values are...

Hi, I am looking to compare the values of two MS Excel 2000 spreadsheets. I would like any exceptions to be exported to a separate spreadsheet. Therefore the basic logic breakdown would be as follows: - Compare spreadsheet A and B - if values are the same do nothing - if values are...