Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dkwong
  • Content: Threads
  • Order by date
  1. dkwong

    USB game controller not recognized

    I have two USB game pads that I use. Sometimes only one of the controllers are recognized. If I go into Control Panel -Gaming Options, I won't see the second controller listed. If I try to find it, it won't detect anything. After I reboot, sometimes it will recognize the second controller...
  2. dkwong

    PL/SQL Function error

    This is a test procedure to parse out lines of a memo and output it. I'm not sure why it doesn't work. It complains that it doesn't like the value assigned to the memo_field_tx variable. The error is : 'FIRST LINE SECOND LINE THIRD & LAST LINE' is not a valid integer value PROCEDURE...
  3. dkwong

    Function to parse out lines in a memo field

    Does anybody know if there is a function in Oracle equivalent that can parse out lines in a memo field? I want to take in a field that contains multiple lines separated by line breaks and return a specific line or return the number of lines in the field. What's the best way to do this? i.e...
  4. dkwong

    MEMLINE and MLINE functions in Oracle?

    Does anybody know if there is a function in Oracle equivalent to the MLINE and MEMLINES dBase functions? These functions take in a field that contains multiple lines separated by line breaks and will return a specific line (MLINE) or return the number of lines in the field (MEMLINES)...
  5. dkwong

    Putting Spool code into PL/SQL procedure

    I have the following sql script that successfully spools the result of a select statement into a textfile but I'm having trouble putting it into a stored procedure. Is there different syntax for the following in PL/SQL? How does it fit in a begin end block? [code] SET ECHO OFF SET HEADING...
  6. dkwong

    STR function ??

    Could somebody tell me what the STR function does? e.g. STR(lineItem,2,0 STR(purreq->totalCost,12,2) Is there an equivalent function in Oracle PL/SQL?
  7. dkwong

    Formatting a field to have 2 decimal places

    Is there a built-in function in PL/SQL to do the following or should I just write a function: I want to format a dollar amount field. If the field value has no decimal places, format the number to have two decimal places. If it has 1 decimal place, add a zero after it to have two decimal...
  8. dkwong

    Function doesn't work

    Why can I not assign a SQL statement to a variable? Thanks! CREATE OR REPLACE FUNCTION Lookup(id_no IN NUMBER, table_name IN VARCHAR2) RETURN VARCHAR2 IS BEGIN IF table_name = "vendor" THEN return_value := (SELECT vendor_number_tx FROM table_name WHERE vendor_id_no =...
  9. dkwong

    Eliminate spaces in spooled text file

    I can successfully spool query results to a text file. I want each column to be a fixed length (as shown below) and the fields CANNOT be separated by any spaces. I've tried many suggestions, but I can't get rid of the extra padding. Thanks. SET ECHO OFF SET HEADING OFF SET PAGESIZE 0...
  10. dkwong

    SQL not working

    I'm trying to do the following. I have two tables, t_Vendor and Vendor_Load. I want to update the t_Vendor table with values from the Vendor_Load table. Comparing records between the two tables, if the vendor_number_tx matches, then update the fields in that record. If the vendor_number_tx...
  11. dkwong

    Open Word document and automate mail merge

    I have a button in Access that I have opening a word document ready to mail merge with fields from the Access db. I want to automate this process so that the document is merged and ready for printing. I consulted the Microsoft Q209976 article that outlines how to do this uses the OpenDataSource...
  12. dkwong

    How to truncate table in PL/SQL

    I want to use the TRUNCATE table command within a PL/SQL stored procedure, but I notice that it raises a compile error (Encountered the symbol "TABLE" when expecting one of the following...). According to one source, he says ddl statements are not allowed in PL/SQL and "in Oracle...
  13. dkwong

    Union in Oracle

    I'm trying to union two queries together but they have a different number of result columns (one with 11, one with 9). But I don't want to have to add more columns to the query with the fewer columns because then I'd have to perform an unneeded join. How can I make the Union work? Is there a way...
  14. dkwong

    How to insert the Oracle user ID into a field

    I have a field in a table called LAST_USER_ID. I want to populate it with the oracle id/username of the person who creates or updates a record. Is there a reserved constant that stores the id value. How can I get it?
  15. dkwong

    Sorting for a report specified in report prompt

    What's the best way to allow a user to specify what field in a report to sort by in the report prompt? I'm thinking that the SortBy property of the report can be set in some way. I've seen code where the report is opened in design mode, the sort properties are set, and then opened in preview...
  16. dkwong

    Report Grouping without sorting

    I have a report that has three fields: Name, Year, and Amount. Currently, I have the report organized correctly with a Name header and a Year header. In the report prompt, I let the user choose if they'd like to sort the report by Name or Amount. Whatever they choose is specified in the report's...
  17. dkwong

    Getting values from multiselect listbox

    I have a form that gathers values to be specified in the Filter portion of the OpenReport method. Basically, the form passes values to the underlying query of a report. I have a multiselect listbox where the user can select as many sales code ids as desired. I want to be able to use the list of...
  18. dkwong

    How to join queries in VBA

    I would like to do the following in VBA or a mix of Access objects and VBA. Here is some pseudocode: - Assign the following SQL to a variable or recordset: "SELECT Employee_ID, Employee_Name, Employee_Phone FROM Employee WHERE " & Forms!EmployeeForm.Filter i.e. the filter specified on...
  19. dkwong

    Mail Report button difficulties

    I'm using the Mail Report built-in functionality that Access offers for a command button. I have a form that takes user parameters and feeds it into a query for a given report. Basically, the parameters are put in the where condition argument of the OpenReport method. Is there a where condition...
  20. dkwong

    Showing two fields in a combo box once selected

    I have a combo box that displays all the employees in the Employee table. In the drop down, both Last Name and First Name are displayed, but once selected, only the Last Name is visible. In the combo box wizard, I select EmployeeID, EmployeeLastName, and EmployeeFirstName and specify the key...

Part and Inventory Search

Back
Top