Recent content by Richio

I have a db (unsplit with approx 10 users) it keeps corrupting but I am looking into why. When it does corrupt sometimes I seem to lose data and it messes with the table relationships (ie it deletes some of them) When I re enter the relationship and try to enforce the ref integrity I am unable...

Arrrrggghhh My database has just gone mad. 90% of the records from the main table have vanished. All the related records in other tables seem to be still there however. the relation is based on a contract number starting 0001 - up to 6500. All the ones starting with a 0 are still there but the...

Thanks..... I see exactly where you are coming from....it is all to easy to jump in and get something that works only to discover later why it was a bad idea. I will see how I get on with this method R

Neil Are you saying have a brand new table, so my exising table would have Product1 for example and then a further table would include nine price bands for this? why not just list the nine products in the first table. I am confused However.......since looking further into it I have got it to...

I have a simple "orders" database. A main order form with a subform. the subform lists the product with a combo box and then enters the unit price from the same table automatically. My problem is that a product can have 9 prices dependant on price band. (Unfortunately there is no common...

Moose Right here goes........There is a training Company www.d-l-r.co.uk which covers this area - he comes highly recommended and is apparently one of the best when it comes to access. He covers both the training and development side of things. My wife has used him for access training with some...

Moose I am in Peterborough (just up the road) - My wife is software, trainer although she does not cover advanced access, she knows people in the local area. To be honest, I find that access is so large the only way to learn is by picking it up as you go along - courses can be beneficial if...

Many thanks for the help......still a few problems when entering more than one product but I have managed to work out a sloution to that. Now I can move on to the next stage. Thanks again

Ooops As I copied the tables / forms to a new db I forgot to include the relationships on the tables on the attached - does not seem to interfere with my problem however Sorry

Elana Attached is db - not fully functional but should get the idea - If the Order details SubForm is opened only, by selecting the category in the first combo only the products in that category are shown in the next combo However in the Orders form (containing the Order Details subForm)...

I have checked out the code from the ms knowledgebase and needed to amend as code in subforms is different to that in a form, but it is still coming up with the same error unfortunately. Does a filtered query on a combo box work in a subform? Thanks R

I have set up a form with two combo boxes - the first is a "category" drop down the second combo box is on a filtered query which only selects the criteria of a particular category. Ie first combo select "fruit" as the category, second then only lists apples, pears etc (using [Forms]![Order...

Thanks for the advice - I can see where you are coming from on the category side....but a little lost still on the colour pricing. Alternatively - I have been surfing the web looking for quotation software to save me a job! - seems to be alot of quite complex stuff around - does anyone know of...

I am just about to start a new project (not that i have enough on the go at the moment), but before I get stuck in I was wondering if anyone could give me ideas on which way to go. The project will be a quotation system - I will base it on the "Order entry" template in access - (albeit...

I've tried and I am sure it is simple......I need a message box to appear when a duplicate entry (tel no) is attempted to be entered onto a form and to proceed if OK I have put the following in the before update on the field property on the form If Not IsNull(DLookup("[Tel No]", "Lead Slip"...