Search results

i've just removed: 'Clng' from the code and now it seems to work, will this have a negative effective?

in my system, i have Quanity X price = Line Total. but the problem is that the line total keeps on coming up as a whole number everytime. e.g. Price *Quantity = Line Total. £1.67 * 1 = £2.00 my 'line total' code is Clng(([Quantity]*[UnitPrice])) . do i need to change my code...

There will be lots of components, hence lots of prices for those components. but each customerID will have a different component so i carnt show one value.

i need to make combo boxes, i.e. in the first combo box, the name of the computer component, in the 2nd combo box, the list of the corresponding price. are there any step by step tutorials that i can follow?

i made a form in design wizard with a crappy white backgorund with pencil like marks. Could someone tell me how to remove the background? edit: i have just uploaded the pic: here it is

its just a normal text box, but is drop down.

in my main form, i have a the text box called: "Emloyee" which comes up as e.g. "Smith,John". i.e. if my end user ever gets more employees then they can use the drop-down list. i want it to select "Smith,John" when im making a new record, usually the box is just empty even after i go into the...

thanks for that guys, such a simple piece of code, who would thought... :eek:

i have a form with a datasheet, the important fields are "Unit Price" and "Quantity". i want it to display the sum of: "Unit Price" Times "Quantity", i have gone into design view, added a new field and written this: Clng(([Quantity]*[UnitPrice])AS[Line Total] with "line total" as the name...

im interested in the 'TransferSpreadsheet' by marco approach, can you provide any info on this or some links to tutorials?

im creating a query which is basically "Price" of selected CPU X "Unit". the problem is the price is in the component field as you can see here in design view, i have made the statement: Line Total:Sum([AMDprocessors1]*[unit]) as you can see here if you look back into the 1st link, the...

thanks for the help len

sorry about that len. basically when a car is sold, the date of sale is put into a field in my main 'AllCars' form, now when that date is in-putted i would that record to archive into another sheet.

thanks for the advise, i've looked through the search results and carnt find anything which is relevant.

help, i have almost the same problem as kabir has. i have two main fields: 'price' and 'Quantity' (and 'Item') i have times them together and have made this statement: Line Total: Sum(([quantity]*[price]+[Valet Price])) (set as a 'Expresion') which works now, if i choose more than 1 item...

i am creating append/delete queries but am having a little trouble making them work. basically, when any date is entered into a date field in my main form i want that record to append to a new table and delete. now, im not sure what to put into the query criteria? [i assume it will be the same...

for me to select a component from the drop down list, should i make a query which has all the component tables selected? hence, i could make a 'look up' in table design which would use the query.

is there a tutorial for this 'orders' template in Access?

thanks for all the help Parker. i am modeling my database using the 'orders' template. no doubt that as i progress with this databse, i will have more questions. my first question is: i have a field called quantity, if i select a component such as e.g. ''Intel Celeron NetBurst 1.8Ghz Rtl (Skt...

Thank you for your advice Parker; I will follow what you have said. You say to link the tables from Excel, do you mean via “File> Get External Data> Import” or “File> Get External Data> Link Tables”?