Search results

BUMP (please if there is no way then state this so that I know) TIA Computerfreaks

I have a form which holds an product enquiry from a customer..... if the customer changes the enquiry I have a second form which takes all of the values from the first as default values and allows them to be edited... this stores the edited enquiry seperatly so we have a record of both. The...

I have a form which can be opened via two buttons, the one button will open the form and find specific data based on a combo box..... I want the other button to open the form and goto a new record. How do i do this? if the second form has the on Open property et to add new record then the...

bump

Hi, i need to know how I should set up my criteria. I want to create a report every half a year for the current data from January to July. I have two columns - date (of record) and year (of record). For the year one I have set the criteria [Enter year], this gives the correct year as...

Cheers guys, I shall get to work asap, you never know maybe one day i'll be answering peoples questions on this forum! I'm off to build a new server now, will let ya know if I run into anymore probs. Cheers

If anyone could create a simple demo of how they'd do it and e-mail it I'd be very grateful..... I can offer web design help in return?? or troubleshooting of computers

I have made the combo box as you have said, does this allow for different costins though... What I mean is that if theres a machining cost it could have all different forms of costings for it, rate per hour may be different, time, set costs e.t.c. The combo box seems to only give a choice of...

I understand all the theory of that, and it sounds great. How exactly do I create a combo lookup on the form? So far, I have made the three tables, defined the foreign keys, made two forms, one for CostNClink, one for NC, dragged the CostNCLink table onto the NC to create it as a subform...

What exactly is a foreign key? I have searched through the help and can't see anything, is it just an expression you use meaning they are linked via realtionships? Many many thanks for the help guys

Pat I'm being really dumb here but how do you have more than one primary key?? I thought that was the idea of it being primary? cheers

Will it allow me to have multiple entries for the same NC Numberif NC number is the primary key? for example..... NC Number | Cost type | Amount -------------------------------- 456456 | Admin | £50 -------------------------------- 456456 | Inspection| £20...

Also if I have multiple tables for each different type of costing, sorted by their NC number, how would I then be able to query all of the data? I have tried this before, but because you don't always have different costings for a non conformance some tables have no information for that...

If I were to create seperate tables, how would i ensure data could be entered from a form into these seperate tables, for example, if I had seperate tables for each cost, and currently in the form I have a drop down menu to select which type of costing you wish to enter data for, how would I...

I posted a message the other day about my non conformance database, I was told I need to make two tables. One for Non-conformances, another for the costing of the non-conformance where I could then sort the costings into the type of cost e.g admin cost, machining cost e.t.c. The problem is...

I'm an IT technician, but have no experience in access, I'm trying to make a Cost of Quality database: Whenever theres a non-conformance it has to be detailed as to its costs involoved, there is then a printed record of that non-conformance. Then these records must be collated for a monthly...