Search results

Yes point taken and understood. Many thanks again!

here it is

Adam, thanks very much for taking the time to do that - that cleared things up for me and you have achieved what I am trying to do. My DB is slightly different in that there is only one field for the name (not first and last names) My combobox has 2 columns (FatherID and FatherName) I select the...

I have. It just seems to show what Access can do if you are an expert - no instruction/explanations. I like my dinner served in small digestible pieces.

ok it seems to be working now - thanks for your help

Thank you David for taking the time to respond. You will have to forgive me, as your simple explaination went right over my head - yes my understanding of Access is that bad. I am not familiar with VBA or coding of any sort. I tried converting the images from .jpg to .bmp files and then...

My text field entitled 'Picture' contains the paths for each record (e.g. C:\Pictures\pic1.jpg, C:\Pictures\pic2.jpg etc.) My image control, entitled 'ImageFrame' has a control source, set to 'Picture' and in its properties, Picturetype is 'linked' and Picture is 'none'. On saving the form...

I have read that Access requires additional software or coding to do this. If you know how to do this without the need to install additional software, please let me know - and I am new to Access so would appreciate it if you broke it down into steps (particularly if it involved coding) I have...

any ideas??

Adam, yes you have the situation exactly right, but it might clear things up if I explain what I am actually trying to do. I am trying to create a family tree. I have the columns in the table: ID, Name, Father_ID and Father_Name. I create a form for this table, which includes these 4 fields...

Basically I am asking how you get different columns within your combobox connected to their respective fields, so that they will update all the fields on selection of one particular value within the combobox. E.g. When selecting 'John Smith' from combobox list, it updates ID field, Name field...

Thanks for your suggestion. so I created a 2 columned combo box with hidden ID and Name (called combobox140). I tried having the control source as 'Name'. This resulted in a dropdown list which, on selecting the desired name, makes a note of the corresponding ID in the Name field and does not...

Thanks for your response. Even if I change the ID, the Name does not automatically fill in itself either. I should have said, I am new to Access so need a bit more information - I am aware that it may have something to do with relationships (I have not set any self joins up for my table). In...

Please consider the following situation. customer_ID 1 2 3 Customer_name Bob Henry Jo On the form I have a box for both the ID and the name. I know them by name rather than ID, so when I type 'Bob' I want the form to autofill '1' into the customer_ID box. Any help would be much...

Thanks Dave. So BirdID would correspond to each egg and its respective bird if the egg hatches. I will try a few things out.

Many thanks Gemma, Good point about PK - I will need to put in information before a ring number is assigned. The breeding details are important, I intend to add more fields than I have mentioned here (such as incubation time) but want to better understand the software first. I want to look...

Dear all, Firstly, I am very new to MS Access and indeed the forum (hello!), so I am very pleased to have stumbled upon this website and hope that some of you might be patient enough to help me out. The situation: I breed birds as a hobby, and I am trying to build a pedigree database to keep...