Search results

Great. Just what I was after. Thanks.

In Oracle SQL, there is a function NVL() that allows you to test if something is null, and then if it is, replace it with a value of your choice. I.e. NVL(fieldOne, 0) Is there an equivelent function in MS SQL, I have searched the internet, but cant find anything.

I cant seem to get that to do anything. It hides the whole data part of the form. I want it to be there, but I want the text boxes to be empty.

SCREEN SHOT HERE I dont think you understand what I mean. So I posted the screen shot. Basically if you choose something from either of those combo boxes at the top, the rest of the screen is loaded with data. When THIS form is first opened, I want it to be blank, I dont want it to show the...

Its an enquiry form. The user makes a choice from a combo box AND THEN the data is shown on the form. I dont want any data to be shown when it first loads up, until the user makes a choice in the combobox, because it just looks a lot neater.

I want to open a form so it is blank. I have looked through old posts, and the only way I can see to do it is using: DoCmd.GoToRecord , , acNewRec However, this is no good for me, as I dont want to allow data entry AND I have default values for one of the fields. Is there a way to do...

Can anyone help on this? I have two combo boxes. When you select a value in either of them, the record populates the form. However, I want combo box 1 to update combo box and vice versa.

I have. Do I use a different notation to you guys as well? The underlined field shows a PK and the [] shows a FK. I need the form to look up the value of price band, depending on what the user selects for rarity and region. I then need the result to be stored in the product form. Sorry for...

Great thanks.

I have: Product (prod_id, prodName, prodAge , [price_band_id]) PriceBand (price_band_id, price, rarity, region) Then I have a form that allows the user to enter a new product. I only want to store the price_band_id next to the product, to prevent me storing the same combination of region...

I have a tabular sub form, which is just used to show the user data. It is not editable, and the user can not do anything on the form other than choose a record from the PK, and thenview the data. How can I prevent the a blank row from automatically being added to the bottom of the subform. I...

I want to run an sql query inside a function i have written in vb. I need the function to return the result of the query. can anyone help? Also, if I have written a function that returns an int, and i am then displaying this on a form, by setting the control source of a text field to the...

Following Pats guide, ive now got the form to display the calculated level. How can I now save the value it calculates into a record of my choice, when the user saves the rest of the record?

Ive written the function, but I get "Undefined function calcLevel", when I try to use it an a query.

Ive been taught solely using oracle sql*plus, so it seems normal to me. Its more writting the check constraints etc that I find easier. Thanks very much for the help.

Is it possible to use SQL to code tables and set up constraints on your fields? I know quite a lot of Oracle SQL, and im used to working within an SQL*Plus command line type environment. I know the syntax is different, but if I can use access in this way it would really help. Can someone tell...

I want to have a coloumn called "level" which is generated depending on what "height" and "width" and "age" have been set to. I have a table: stats(name,height,age,width,level) i want level to be worked out automatically, such that: if height > 10 and wieght > 10 and age 10 then level = 1...

I want to create an attribute called "order_line_price", which is basically the quantity field * the cost per product. I have written the following SQL query which works fine: SELECT Order_line.order_number, Order_line.product_number, product_name, quantity, (quantity*price) AS [Order line...

I have the attribute "order_line_price". I want to be able to calculate a value to put into it, depending on the product in the order line and the quantitiy in the order line. How can I get a query to use the value that has been selected in the product_number field of the order_line table, to...

Heres something I dont understand about the lookup wizard: Ive done a lookup wizard on one of my fields, so that now the user gets a drop down list of options to choose from: 0;1;2;3;4;5;6;7;8;"NTSC";"PAL" Ive also set "Limit to list" to yes, so that these are the only options the user can...