Search results for query: *

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

I have the following table. Client Store Products 1 houston shirt 2 austin jeans 3 dallas pijamas 2 austin socks 2 austin Sandals 3 dallas shoes I need to write a query in Access that will...

I have a child (detail) block in tubular form. I need to have a field that will number the regults after the master is queried. ie. MASTER = company details= employees details block looks like this: NUMBER | NAME | LAST_NAME |ADDRESS 1 2 3 4 so I need that for every record on the...

I have a master table (contracts table) with about 20 variables. (about 20 records/ contracts in it) the records are static, they only chage once every 5 years. The idea is that a user queries a customer, if the customer does not have a contract assigned to him/her, the user will open a LOV...

I am doing data dictionaries for our small dept database. About 40 tables and 1000 variables. I will be doing this on Excel. The columns that I will be using are: Name | Description | Var type | Null?| Label | Constrains as you can see some of those are the output of the Describe command so to...

So thanks to your help. I was able to sent the parameter list from "FORM A" and call "form B". now I assume that I am still missing something as I get the error messange that says something like "not such parameter name exist in form B" the idea is this, I want the user to be at a record...

this is driving me nuts! I have it on a preinsert trigger at the form level. it does not give me any errors, it just does not write anything on the auditing table at all!. :( ------------------------------------------------------- DECLARE v_block VARCHAR2(30); v_username...

when the user clicks on displays the seveal options, by default it places the cursor on the very buttom of the list, is there any way I can change that to place the cursor at the top of the list? thanks

I have read the sintax and its very clear what I need to do, however, I am getting an error the says "cannot read form myform2" myform2 is the actual name of the file, so the name is correct. I think my problem is the actual physical location of myform2.fmx or fmb, where are they suposed...

is there any way to get rid of the Find button? I dont need it, I only have 5 values displayed. If this is possible how? thanks

I have created one and everything works except when the user selects a value, this values does not get transfer into the new field. the new field. Anyone knows why? did I miss something? by the way, the LOV show labels and i think it sends numbers, the field that is suposed to receive the new...

So I would like to have all of the error messages that forms displays on the lower left to be displayed on a popup to the users. I dont not a custom message just whatever forms says, but in stead of showing it on the default area to display it on a popup can you guys please help me with the...

I have two list Items, I am trying to perform the following. 1.-List ITEM drop down choices A of B If choice is A, then list ITEM 2 should be populated with RED,BLUE else if choice is B then List ITEM 2 should be populated with ORANGE and brown. the selection of LIST ITEM A is done at...

It seems to be that by default, the labels are centered on each tab when your tabs are set to the top edge of the canvas. I switched the direction of where my tabs will show to on the left side of the canvas(edge), but the labels are not centered anymore, they moved to the right and it looks...

Can someone please help me with this procedure? It works sometimes and sometimes it does not. i think it may have something to do with decimals in the arythmetic operation. any suggestions? thanks! PROCEDURE minute_interval IS BEGIN declare total_minutes number; begin total_minutes:=...

I have a form with a master-detail blocks. I would like that as a new detail record is created, a sequential number is generated for that particular master record only for instance. master record Jonh details (brothers) mary Susan Karla so I want to have a column next to the detail names...

I have a form with a master-detail blocks. I would like that as a new detail record is created, a sequential number is generated for that particular master record only for instance. master record Jonh details (brothers) mary Susan Karla so I want to have a column next to the detail names...

I am not a DBA, I do own my own schema on a box, I was wondering if I could somehow monitor my users that have login in into my schema. I am not exactly sure what priviledges I have over my schema users or how to do it. I do have their passwords. The database is running under 8i. Thanks for...

I have one application with only one canvas and one window, I just saw another depts application and they undock or are able to move the screen off of the Browser area of the applet how do you undock the window off of the screen? thanks!! joey