Search results

thanks mate, have uploaded it now :) its in the "order" query, i dont see why the auto number thing isnt there

i kinda solved the problem in my original table, but now in Query, in my "order" query, it wont give the autonumber so i cant add a new field, can you help. i've uploaded it EDIT, wtf, i've deleted some reports, yet it still says 1.03MB ! u got msn messenger mate?

im a bit confused at how u got the different VAT ratings

thanks, got it sorted before u replied. yes, i have the cost of the book in the stock table. my next problem i have hit is: VAT calculations each book has a Catagory ID: Humour, Fiction and History. Humour books have a VAT rating of 17.5% and history + fiction are rated at 0%. im not sure how...

i have to set up a invoice. my database is about selling books, if a customer wants 20 copies of a book, then i enter the book id into the table, but how do i get the books unit price to appear at the same time as well ?

im trying to create a field where by, 2 other fields are multiplied together: "qty" and "cost". so i set the criteria to: ="qty*cost" but all fields return blank. im at a loss at where the problem is, this should be one of the easiest things to do in Access, but its not for me.

thankyou dave, thats worked a treat :)

i would like to list all people if they are under 35, i thought it would be "=now()-35" but it isnt, anyhelp please?

hi Ken, Thanks for the quick respons. For my assigmnement, one of the objectives fo the database is to, target different age groups, namly the 35 and under and the over 35. So that LM books the company can then mailshot the correct group for the products that they will be interested in...

I have a problem with a Paramount query. All I would like the query to do is, look through all the dates of the customer table. Use the date of birth to devide the customers into two tables for the 35 year olds and under. And 36 and over. But I just cannot seem to get my head around it. I...

the code for the macro is: Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Products" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command15_Click: Exit Sub Err_Command15_Click...

i just created a macro using the wizard via the toolbox.

if i open this form through the objects window, then it opens in datasheet view which is fine. but on my navigation form, i have created a macro which links to this form. everytime i click on the marco. the products form appears in design view, not datasheet view. what settings do i need to...

thanks for the help ghudson i have a slight problem, when i type in e.g. 0113 2402425, the 0 doesnt appear. it just displays 113 2402425. im puzzled by this. can you help me?

thanks for that spacepro. i have another question, when opening my database i would like my 'Navigation form' which opens firstly, i would like it open in medium size, not 'maximise'. what settings do i need to change?

im consistanly getting error boxes when i try to type in a phone number such as e.g. : 0113 2346410 the input mask for the phone number field is: 9000#\ 0000000 could somebody tell me on what i need to change in the input mask code?

i have a form which needs to be in Data sheet view. but when i double click on it in the objects window it goes into 'Form View'. i've changed the properties to: Allow Formview as 'No' and the other views bar Data sheet' view. how do i make it go into 'Data sheet' each time i double click on...

i have been testing my database that i have built. in the process i have deleted some customer records from my 'Customers' table. my prblem is that Autonumber does not remember that i have deleted them when i add a new record. e.g : currently: Autonumber | Name...

thanks for that guys, richo, you are right, i've done what you've suggested and it works a treat. thanks :cool:

i have a report which acts as a invoice, it displays the selected pc components and related prices for that customerID. now, when i want to calculate the sub total, i have put this formula into a text box: =Sum(CLng([Quantity]*[UnitPrice])) but i when go to view it in print preview mode, the...