Search results

Thanks for this, but... (there's always a but) in my siblings field, I want to be able to link MANY records from the table, i.e. the current student may have 2 brothers and sister who are listed in the table. The example you sent only seems to allow ONE record to be linked. Any ideas ? Al

I have a table [tbl_Students] which holds Student Details. In the table I want to add a field which lists any siblings a student may have in the same school. To do this, the siblings field has to lookup the table that its in, but I dont think Access will do this. I tried to create a Junction...

I want to insert a Multi Page tab control inside another tab control. I have tried it but it doesnt seem to work. Any suggestions ? Thanks in advance Al

Hi I have a table (Property_Match) which has some Multi-Value fields in there. For the purposes of this, lets use the Furnishing_Level field. This has "Unfurnished" , "Part Furnished" and "Fully Furnished" as the 3 options. I have created a form (frm_Property_Match) in which this control is...

Ive solved it - almost accidentally

Hi Mailman No the employee will always have the same Role in each Quotation. As Im a bit of a newbie to this, Im not sure I understand what you are suggesting. Could you expand on this for me please ? Thanks Al

I have a table which (to make things simple for now) has 2 fields in it... Employee_Role Employee_Name I have another table (tbl_Quotation) where I want to enter various data, of which 2 fields are Employee_Role and Employee_Name. Now it would be easy for me to Select the Employee_Name...

Ive created a database and I have converted it to a Runtime Application. It worked and installed correctly on my PC, but I dont have any Access buttons, like Filter, Export to Excel etc. How do I ensure the users get some Access buttons when I deploy my Application ? Thanks Allan

Hi Coach Thanks for this. I thought the Master/Linking linked my Sub Form to the Parent Form , which in my case is the Patient Form. Are you saying I link Sub Form2 to Sub Form1, Sub Form3 to Sub Form1 (or do I link that to Sub Form2) Also, how do I requery a Sub Form ? Thanks in...

I have 2 tables in my database, a Main table (Patient) and a Sub Table (Appointment). I've created several forms based on the Appointment table, all including the Primary Key but each form displaying different fields. See below... Appointment Sub Form1 Appointment_ID Date Venue Nurse etc...

In a table I have 2 fields for the Primary Key (Patient_No and Date). I have created a form for this table and I want to check that the same patient does not have 2 appointments set on the same date - hence the 2 primary keys. I have managed to capture the Error that is generated when a...

Here is the file in question Any help would be greatly appreciated Allan

Hi All I just cant get this to behave as I expected it would. I might have to post the database up here so someone can take a look to let me know what Im doing wrong. I have 3 MAIN Tables... tblCLIENT (this is a table that lists all the companies that have the vacancies) tblVACANCY (the...

Many to Many Problem Hi Pat / Ann I am creating a database for a friends recruitment agency. I have a very similar problem where I have CANDIDATES (Job Hunters) and I have VACANCIES (Jobs posted by Companies). Obviously a Vacancy can have many candidates and a candidate could have applied for...

Many to Many Problem Hi Pat / Ann I am creating a database for a friends recruitment agency. I have a very similar problem where I have CANDIDATES (Job Hunters) and I have VACANCIES (Jobs posted by Companies). Obviously a Vacancy can have many candidates and a candidate could have applied for...

Here is the offending file If anyone can give me a bit of practical help, I will name a tree in my garden after you Thank you Allan

Thanks Gary I opened up you file but it makes no sense to me and I cant find any code In there I am a complete novice to this.

I have a definitive list of all towns and cities in the UK and their corresponding counties and regions. I bought this list from the Royal Mail/Post Office and it is all accurate, normalised and without errors. One thing I wanted to avoid with this database was user TYPING in certain parts of...

Thank you for this but this didnt really help me - Im not sure what Im looking for. I have to stress Im a complete novice to this. My simple understanding of it was, I have 3 columns of data (3 fields in the Town_County_Region table). I am selecting the town from column 1 of the table and want...

Thank you for this. I feel like Im getting closer but when I change the town city on the form, the value in the county box isnt changing ???