Search results

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

Hi, I'm new to Access and attempting to build a database to improve my skills. I'm a BA so i'm converting my excel issues list into a database with a front end where i can create new issue records this uses a form that sits on top of the issues_table. Howver, i have created a table called...

Wahoo! I got there, the duplicate lines were caused by the fact that i had included the "Activity" field in the Group By Clause. Thanks for your help!

I had this problem at the very start of trying to figure this out. I tried the IIF and got that same syntax error - have tried "1" & '1' - i've checked the field on the table and the type is AUTONUMBER - is that an issue?

I couldn't get your IIF statement to work, Access kept returning an "Incorrect Syntax Near '=' " error... My SUM/CASE kind of worked but returns two rows for each customer i.e Customer1: 3 "" Customer1: "" 12 Instead of Customer1: 3 12 ...getting closer though!!

Thanks very much i will try this now, literally just as this e-mail came through i was trying sum(case when tbl_Activity.Activity IN (3,4) then 1 else null end) Visits, sum(case when tbl_Activity.Activity IN (1,6) then 1 else null end) Calls It has returned "something" - but not yet checked if...