Search results

nice one mate, start searching now finish in about a week. cheers

hi, have tried this in queries but i think i shoudl have put it here: i have a query which when the user selects a value in a combo box it pulls up the other details of the item, such as price. i have noticed though that if i try and enter a new item into the list, through the combo on the...

hi, i have a query which when the user selects a value in a combo box it pulls up the other details of the item, such as price. i have noticed though that if i try and enter a new item into the list, through the combo on the form and then enter a price, it gives me error 3101 (something to do...

hi, thats what im looking for, but could you just explain the dsum bit again. im not a wizz with access but i can do a bit. ie never used dsum before and not sure what each item is int he formula. jjames

hi, i went to staples the other day to see what the had, but there were none there and the sales guy looked at me stupid. the nearest PC world is 35 miles away and i dont particularly want to use the net as i want to read it to see if its what i want. can you let me know where to get them. i...

come on guys, i need help on this one desperately. jjames

hi, sorted it now, jjames

hi, i have two subforms on a main form, both have a total field on. i have set a field on the main form called subtotal so that its control source is =[frm_invoice subform].[Form]![Total]+[frm_service final subform].[Form]![Total] the problem is, when i start typing on the main form, the...

hi, i have two three tables linked, tbl_invoices is to linked to tbl_invoice details and tbl_service details as one to many relationships. tbl_services lists the parts and prices for use in tbl_service details. the probem is, when i open the form for invoicing which has tbl_invoice details...

Hi, i have an invoicing form which has two seperate subforms from seperate tables. one from tbl_service details and one from tbl_invoice details. tbl_invoice details is linked to the invoicing table and when delete is pressed, it updates both tables a appropriate. but because i cannot put...

hi, is it possible to have a form where you enter a word in a text box and it searchs a table and brings up all records which match it, but it doesnt have to be an exact match. e.g. you enter : the results : the car the bike etc. any help appreciated. jjames

hi, is it possible to have a form where you enter a word in a text box and it searchs a table and brings up all records which match it, but it doesnt have to be an exact match. e.g. you enter : the results : the car the bike etc. any help appreciated. jjames

hi, i used null, not in terms of acccess, but in terms of clearing the field of its value and inserting a 0. i have put in your code as above and it only clears the first record. the tabular form i have is a list of loads of different items and how many to order. the [additional] field is...

you dont seem to understand me here. i want it so that all values are "nullified" on load of the form and set to 0. i want it to wipe all current values and set them to 0. thanks jjames

additional: i currently have: onload event of the form is [Additional] = 0 but this only puts the first value in the additional column as 0, the rest stay as they are. jared james

hi, if i have a form which is in tabular format, is it possible to have it so that when the form opens, all values in a particular column are set to "0"? Jared James

additional: i can put text boxes on, but when i enter additional numbers to order, it sets that number down the entire coloumn for every item. jjames

hi, i have a query which gives the number of items to be reordered. basically it opens a form which displays the item name and how many to order. i want it so that the user can add an additional number of each item and then have it total them for the user. example: item: bulb to order: 3...

thanks mate. much appreciated. ive been working on this too long and its fried my brain. dont suppose you know how to do a sort of general search on a table do you? basically its the same table, with a list of all the items. how can i get it so that the user simply enters a word and it...

hi, thanks for that, but in my rush i forgot a very important detail: i dont hold the quantity in stock. i have "total bought in" and "total sold" i have a query which takes one from the other to give me the number in stock. so i have the number in stock from a calculation on a query, and...