Search results for query: *

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

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

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

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

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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

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

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