Search results

Hi Thank you for your reply and the example. Im not sure I understand. Do I have to create a form for each table and then put them in as tabbed/sub forms? My head is swimming from looking at examples and trying to work out why the way Im doing them isnt working. So far Ive used the instructions...

I have found this most useful! http://office.microsoft.com/en-us/access-help/using-the-tab-control-on-a-form-HA001230049.aspx#BM3 Now I dont know or understand how if I create pages from the tables I have, how they will work. For example No 1 Customer has 2 horses. How do I record details of...

Thank you! I do not understand where I put that but I will work it out! LOL Im trying to design the actual forms so will make more of an attempt to work out what to do with the instruction/code in a little while! Very confused atm! Ani xx

Hi please help I have been watching/reading lots of tutorials about creating and designing forms and am now totally confused. I have 7 Tables as follows: tblCustomerDetails tblHorseDetails tblInvoice tblInvoiceDetailsjctn tblPastureManagement tblProduct tblResults I need to design a form with...

Hi I have just started to create forms for my tables. I have a couple of data entries that are age related. Can someone please tell me if it is possible to keep the age current with present day? eg If I enter the age of a horse today as 9 yrs 4mths and this time next year the horse will be 10...

Thats hugely helpful, again. Thank You. At present I do three tests on each sample but each test is the same, the tests are repeated for scientific accuracy. So I will only need one table, I think. There are three repeated tests, each test has 3 numerical results. So the 9 numerical results...

Ok, I have just looked at all my tables again. I think I need another table with Sample details fields. I do not have anywhere to record the sample processing, analysis or results at the moment! Seems ridiculous that I could have missed something so obvious! Your question asking if a sample...

Hi OK, Thank you. I have definitely got confused with the junction table rules and overcompensated. The three in red I added after you explained I needed the junction table so will remove those. Yes Invoice Value will be total of that invoice. I will have to work out how to add that to a query...

tblInvoices ******** InvoiceID (PK) CustomerID (FK to tblCustomers) InvoiceDate * other attributes of each invoice (not including line item details - those go in a different table) tblInvoiceDetails ************ DetailID (PK) InvoiceID (FK to tblInvoices) ProductID (FK to tblProducts)...

Oh WOW! That makes so much more sense! Thank you. I can see what the junction tutorials meant now, I got so confused with that! Brilliant...that must have taken some time to type out, Im really grateful! Ani xx

Yes I can see the Table structure is the same throughout. When you start looking at creating other things there seem to be differences in the ways that it is done. Some of it I understand! :-0 Cheers Ani

Thank You. Those points make sense. I run a very small service examining horse poo for worm eggs. The pasture management table is very important, it allows me to advise the customer the best way to manage any worm problems the horse may/may not have. II will now look at some more tutorials...

Hi Im new to access and the forum The above seems like the answer to how I want to set my forms up from the data I have. I have 5 tables. 1 Customer details table then 4 tables with information in that is pertinent to each customer. I want a main form with the customer details and then the other...

Thank You! LOL I will have a look and see what I can do then. I really like the idea of doing this little project myself but there are so many tutorials and different ways of setting things up it is quite overwhelming! Im sure I will be asking questions again, I want my db to work. Thank you...

Re: Design & layout-using tabs

Hello Please help. I dont know quite what to do now. I have created 5 tables Tbl-CustomerDetails-Primary key autonumber Tbl-HorseDetails -Primary key HorseID autonumber -with CustomerID as foreign key -Number Tbl-PastureManagement - Primary/foreign key -HorseID - with CustomerID-number...

Design & layout-using tabs Hi folks I have 5 tables. These tables have been related but I will not know how well Ive done that until I set my forms up and enter data. I want to design the user 'Forms' so that each table has a form but so that all 5 forms show at the same time as different...

Hi folks It is a long time since I used a MS forum but have always found them invaluable in the past. I am trying to set up a db for myself and am going to need lots of help! Apologies in advance if I am a bit slow learning! Cheers Ani