Recent content by Tj.b123

I was wandering if anyone could help me? I have three boxes which something needs to be eneterd in whenever anyone creates a new record on the form. I.E before you can save, a message box appears saying you must enter something in the box? Any ideas?

Yeah thats what I mean. I have email to email relationship. it was there but then i added a new category to the design view and its gone. How can i get it back. In the products table its still there. i.e when i clcik lego it displasy everyone who needs it. Someone once told me theres something...

I have a table in access with peoples names, address etc in it. I have another table with what prdocuts they are meant to recieve. They are linked by email address. How do I get a little + next to each record to show all the products that that person needs?

I have a form and it has Truw or False boxes in it. How do I get it so that it only says true or false if its whats enetered. At the moment it says false if nothings enetered. I want it to remain blank.

university

Basically my 2 tables are customer which is basically company account numbers, company name, address, phone etc. Then i have master table which has all individual people related to each company. So comp1 has one entry in customer but 15 people in master. I want to search for 23456 account...

Thanks, Its really useful, however i am an access beginner. so am not very confident with this level of complexity. Is there any chance you could create a dummy table with the details as above for me to work from ni my master one please?

would it be useful if i sent you a blank database that has no data in it?? Just a database with the master and customer tables in it. If not, in the customer table its just company name, account number, address, postcode, phone. the customer details in the master table are name, address...

Hi, Great news that its possible. Is there any chance of you creating some form of a template with some dummy data. I have a two tables of data but its confidential so I obviously cant give it away for anyone to see. Basically my problem is that i want to search by account number. in the box...

Hi All, I am currently working on a project for uni at which I have a database which I need to create a form for. Basically I need to have a search bar at the top of the form by which you can search by company name. I want a box below that which displays that companies name and address once it...

Im in the process of making a database that will be able to geenrate specifi lists of people and their requirements. there are many customer types and many brochures. For example, search for customer type 1, customer type 2, and customer type 3 and then brochure 1 so that it displays all people...

Im creating a database at work relating to all the brochures that we have. I have used the cool search tool as a basis for this as it is the best thing I have found. I have one table with all my details in just the same as the orginal. I have one query set out the same as theres. What I did was...

Im creating a database at work relating to all the brochures that we have. I have used the cool search tool as a basis for this as it is the best thing I have found. I have one table with all my details in just the same as the orginal. I have one query set out the same as theres. What I did was...

Dear All, I am currently creating a MS Access database relating to books with around 15 diffrent fields all in one table and they all have to be in one table. I have created a test version with all fields filled in relating to 7 books. It will be used by a number of people that i work with. They...

Thanks for the links DK. You seem like a very expereinced user in MS ACCESS, and I greatly appreciate your advice. What I want is to have a search box with a reset button on the side. Below this, I want a list box which details the four fields I mentioned in my first post, along with all the...