Search results

On my switchboard i've got several forms, whenever i click a link to a new form that form opens in a new window, how do i stop this so that they all open in the same window?

Also where can i learn how to code validation like this, i realise it is relatively basic, but if u do not know the commands then u cant really start..

On the same subject, I have two fields within a table: - Rental Start Date - Rental End Date both these fields are set to data type "Date/Time" I want to set a validation rule so that the minimum time period is 3 months and the maximum is 12 months rental. How would i go about doing this?

Thanks for that, thats brilliant..

I have a table called Inspection, there are two fields: - Damage To Property // data type is Yes/No - Damage Comments // data type is text How would i go about setting the validation - if Damage To Property is data type "No", disable the "Damage Comments" field. (ie grey it out). any help...

Rak, Thanks very much for the help, have now sorted the database out and it is working out the subtotal :) 1 Problem, it still doesnt work out the quantity, it takes into account the discount & subtracts that from the total price, but if the unit price is $330 and you have 22 of them quanitity...

This is the query that is working at the moment to create the "total price" however it is not working out the discount, nor does it take into account the quantity .. (it's only assuming 1 unit is brought each time). (i really don't understand this code... hence i've struggling..)

Ok well i've got it sort of working, however it is not calculating the quantity or the discount in the total price, so it's not fully working. My current SQL code for this is: SELECT [Total Price of Order Details].OrderID, [Total Price of Order Details].CompanyName, Sum([Total Price of Order...

So where exactly do i put this "code"? am i putting that as the control source? or do i have to do something else with it?

Well i've double checked and i've already set these format options. Still getting "#Error" don't understand why.. i don't know if this will help but here is a screenshot of the mainboard in design view for you: (See Attached)

See Attached I have created the text box: Order Sub-Total and put the control source as "=Sum([Price])" saved it and run in view mode only to recieve a "#Error" in italics. If i am doing something really obviously wrong, could you layout some very simple instructions as this is getting...

See Attached (again) I have included a new screenshot of the control source i am using in relation to the "order sub form" (calculates the total) and it isn't working, what have i done wrong?

First off can someone link me to a helpful page if there is one so that i can learn all these formulas, i know excel v.well but not access.. My query is: i have the fields: Product Quantity Unit Price Discount Discount Total Price prod1 2...

Sorry newb questions, how do i add all the prices in the "Prices" column together in "Sub Total" ?

my point is how do i do those calculations?

Hi all, i run a breakers yard and have made a small invoice / order database to make life more organised for me in access. Anyway it's quite late and i'm v.tired, i have literally one last thing to do to complete it, if you view the screenshot attached i have: Quantity Unit Price...