Recent content by JungleJme

Thanks! That has worked a treat Thanks, i overlooked this property - i'll have a play with it and see how it fits in :)

Hi, I've got a form that sits on the top of a table (company_table). Will (eventually) allow the user to add a new company to the table by entering a text name in the control Company_Name. I'm to put a bit of logic together that will stop duplicate records being created. I thought i would...

OK, well. For now, i'm attempting to create a form where the parent/child relationship between Companies/People and Projects/Testplans is displayed via cascading combo boxes. The user can manipulate the drop downs and if the item doesn't exist they can click a button which fires a popup form...

Hi, First of all, thanks to everyone who has helped me so far on this little project i've embarked on as my first ever database. I would not have got as far as i have without the time & knowledge that people have kindly shared with me on this forum :) So. My database allows you to log issues...

I've looked at the subform again and it has only got controls for the 6 fields specified...take a look at the screenshots to see how the subform looks in Design View and how it appears normally with the blank columns at the end.... screenshots uploaded here: http://dropcanvas.com/10q98

SELECT issues_table.issue_PK AS ID, issues_table.issue_title AS Title, issues_table.testplan_reference AS [Issue No], Issue_Statuses.Status_Name AS Status, projects_table.ProjectName AS Project, issues_table.issue_raised_Date AS [Date Raised] FROM Project_Statuses INNER JOIN (projects_table...

Hi, I've set up a simple query that returns 6 columns of data. This query then shows on a sub-form elsewhere in my DB. The problem is that the query always appears with a horizontal slider. Allowing the user to scroll across to see the other columns in the query... The problem here is...

Thanks to you both for responding, sorry i've been slow to reply - i'm attempting this project in my spare time! I've now got my validation up and running :) thanks so much to you both!

Thanks very much, i'll try it at form level as you suggested and see how i get on.

Hi guys & gals, This is yet another stop on my Access Education (i'm building my first database) and i was wondering what people's thoughts are! I have a table, which when i first set it up i decided that a couple of the fields had to be mandatory. So, i set the "Required" property of the...

thanks for the link, that all makes perfect sense! I shall stay away from using look-ups at table level!

But the response is still appreciated - another neat trick learned, so thanks! :)

Thanks so much for the response - i knew it was going to be something like that - just couldn't figure it out! I'm just starting out so i guess i'm going to trip over things like this quite often for a while....:p OK - i think i may be too liberal with my lookups. Seems that it would be best...

Well, the inevitable happened! I've got stuck. I think i know WHY i'm stuck but i've struggled to fix it all the same. So, i've got my issues table which has a project name & a test plan name in it. However, those two fields are themselves Lookups to another two tables. So although they...

Thanks for the quick response! That is excellent in terms of the cascading combo, that sort of relationship is exactly what i was looking for :) Thank you! I will try and work this in to my database and see what success i have. Thanks a lot,:) J