Search results for query: *

I have 12 tables (T_JAN, T_FEB, T_MAR etc..). I want to write a single procedure that can be used to extract data from any one table and output it to a csv file. How do I get a dynamic table in a cursor?? I've tried passing a variable (of JAN or FEB or MAR) into the procedure as follows...

I have a table full of data (called ORIG_DATA) that I need to insert into another table. Depending on which month I do the insert determines the table I insert into (i.e. if I do it in January then I want to insert the data into a table called JAN, if its February then into FEB and so on). I've...

Does anybody know how to get MSHearts working on a Win2000 machine? I used to play all the time on my old Win98 machine, but MS seem to have ditched it on Win2000!! I've managed to find the files needed (MSHEARTS.EXE, MSHEARTS.HLP and CARDS.DLL) but when I run the exe I get "Cannot Find...

I need to calculate the number of working days between two dates using pure SQL (ie can't use WORK_DAYS). Anyone know how this can be achieved?? many thanks in advance. timboa

My company is in the process of buying a CRM package that runs on the IBM iSeries Server running AS/400. My remit is MIS and Reporting. I know that AS/400 comes with it's own query tool (AS/400 Query), but from what I've seen this is totally "green screen" based and not very user...

I currently have a date field in a table that is being written to from an Access Front End. However, sometimes (and I haven't yet found out why!!) the date is written from the access client machines in DD/MM/YY format, but other times it's in MM/DD/YY format. I need to create a trigger that...

I want to write from a table that will display the results matrix style. The table contains UserIDs and the Roles they have been granted, for example :- USERID ROLE SCOTT SALES ADMIN SCOTT FINANCE CLERK SCOTT CREDIT MANAGER What I want to display...

I'm trying to connect to an Oracle 8i Db via Acces using ODBCDirect. My code (located in a module) is :- Sub CreateConnection() Dim wrkODBC As Workspace Dim ConnOracle As Connection Dim strCon As String ' Define Connection String strCon = "ODBC;DSN=dev;UID=scott;PWD=tiger" 'Define...

I'm looking at upgrading my Compaq Presario 5170's harddrive. I currently have a 6Gb disk, but am looking at putting in a Maxtor Diamondmax D740 40gb. The problem I have is that I'm not sure whether my PC is compatible - I've read that it has to be Ultra DMA compliant ?? Can Anyone...

I've created a module (called Parameter_Pass_Through) and added a function for a pass-through query to my Oracle DB as follows :- Public Function ParamSPT(MyProcName As String, MyParam As String) Dim MyDb As Database Dim MyQ As QueryDef Set MyDb = CurrentDb() Set MyQ =...

I have a Crystal Report which is produced using Customer data from 2 tables. I need to add in a further field (email address) which comes from a 3rd table, joining it to table 1. However, the 3rd table contains multiple records for each record in table 1 (Primary email address, secondary...

I have been trying to install a new HP4300C on to my Compaq Presario 5170, with the scanjet hook up via USB. If I install the HP Software first, then run the hppsapp.exe program, it opens up fine but says that it cannot find any scanner (as I would expect). When I then plug the scanner into...

Ooops !! I've been mucking about for a while trying to install a USB scanner and I have accidentally deleted the STIMON.EXE application. My PC is a compaq and came with Win98 preloaded - I don't have a copy of Win98 CD-ROM. Can anyone tell me where I can download a replacement STIMON.EXE...

I have a table for customers (containing approx 45,000 records) from which I am extracting Account No., Name and Postcode as follows :- Select a.account_no ,a.name ,a.postcode from customers a I have another table which contains valid UK postcodes (approx 1.6M records). I have been asked to...

I need to create a query which extracts data from two tables, something like this :- select 1.name ,1.code ,2.name ,2.code from data 1 , data 2 where substr(1.code, 2) = substr(2.code,2) (+) But, my outer join (+) won't work, I get ORA-00933 SQL Command not properly ended. I've tried...

I have a CSV file which I need to import into an Access 97 Db. The file is delimited by commas. I am using File|Get External Data|Import. I get the message "One or more rows of data in your file contain too many characters to import. The maximum characters per row is 65000.&quot...

I've just replaced my single card of 64MB RAM with a new single card of 512MB RAM. Upon reboot, the PC now shows 256MB RAM installed, not the full 512MB. How do I getbthe full 512MB to be recognised. For info, my PC is Compaq Presario 5170, Pentium II 350mhz. The original 64mb RAM was 100hz...

I'm not sure which Forum is best suited to my query, but I'll try here first !! I'm creating a CSV file using UTL_FILE from Oracle 8.1.5 with out any problem. My problem comes when a User attempts to open the CSV and read the data. One of the fields I'm outputting is a Numeric field that is...

I need to be able to merge the data from two cursors into one record for example :- Cursor Fred contains Record A which consists of an account number and name & address details. Cursor Mary contains Record A which consists of an account number (same one as in Fred's Record A) and balance...

I have a query which looks something like this :- select acct_no, type, sum(amount) TOTAL from table1 group by acct_no, type; The results look like this :- ACCT_NO TYPE TOTAL 123456 DEBITS -2500 123456 CREDITS 4000 What I really want is this :- ACCT_NO DEBIT...