Search results

i have tried (for example) putting in the control source for the Allocation field on the form as: =(select sum ([FORECAST]) from [RAP Course Demands] where [COURSE ID] = [Forms]![RAP Manager]![RAP Courses subform]![COURSE ID]) but it doesn't work. Any ideas?

you mean do the summation in a form? That would mke sense. How do i do SQL summatiuon queries in the variable control?? Thanks!

just to clarify, this is the query that calculates all the data from which the form does a 'dlookup' for the calculated values: SELECT [RAP Courses].[COURSE ID], [RAP Courses].[CAS HEADER ID], [RAP Courses].START, ([START]+([DURATION]*7)) AS [END], [RAP Courses].LOCATION, [RAP...

Thanks so far guys! i appreciate having your attention! Basically, i have a query that sums up all the demands data for each course. This allows me to display the summary details of the course in the same line as the course itself. WHy do i want it this way around? It's so the user can ADD...

Hi, i'll explain my setup. I'm using Access 2007 to build a database of courses run by a collection of schools. It's a favor for my parent's friend because i thought i could do it... i think i've made a mistake! Anyway. There are 3 main tables: Courses (which include: Course ID, Header ID...

Thanks FoFa - literally as soon as you posted that, i tested dlookup and it worked! thanks for giving me some assurance.

Hi Guys, i have just solved it. For those who need to know also - make the default value to be: =dlookup("[result]","query_name","criteria=#") Damn, that was so obvious!

Hi Guys (i posted this in the VBA part - but realised it's more appropriate here), quick question - i'm a bit of a noob when it comes to Access so this might be really easy. I am trying to set a default value of a field to be the most common value within the table. Any ideas? I have built a...

Hi Guys, quick question - i'm a bit of a noob when it comes to Access so this might be really easy. I am trying to set a default value of a field to be the most common value within the table. Any ideas? I have built a query to find the most common value but when i set the default value of...

Thanks Simon, thats a fantastic idea. I just gave it a quick go - but i'm having trouble editting the Course Details part of the table if it's filtered by whether the header is C or O. It says recordset not updatable - which i assume is because if thedata is via a filtered query, it becomes...

Hi Guys. I have 5 tables: Current Courses Current Course Demands Old Course Header Old Courses Old Course Demands Basically - the Current Courses table lists what courses are on this year. The demands are simply another table linked via a one-many relationship (Current Courses -> Current...

If anyone else had this same problem, the solution is as follows: In the after update control of a controlling combobox (calld comLoc in this case): Forms![RAP Manager Interface]![RAP Courses Locked subform].Form.Filter = "Location = [comLoc]" Forms![RAP Manager Interface]![RAP Courses Locked...

Thanks Cyberlynx. Just to make things easier, the main form is called [RAP Manager], the Parent Table (from a query) is called [RAP Courses] (its form is [RAP Courses subform]). The Child Table (from query) is called [RAP Course Demands] (its for is [RAP Course Demands subform]) I have tried...

Hi, I think this might be quite common but i cant find anything relevant on google. I have 2 Queries in a form in Table View - one the subform of the other. I want to requery the parent table after updating the child form. i'm using this VBA code (it doesn't work) : DoCmd.Requery ([Parent...

Hi, I think this might be quite common but i cant find anything relevant on google. I have 2 Queries in a form in Table View - one the subform of the other. I want to requery the parent table after updating the child form. i'm using this VBA code (it doesn't work) : DoCmd.Requery ([Parent...

Does anybody have an idea about this? Thanks guys! Chris

Thanks Heedaf. I dont fully understand your suggestion though. I haven't programmed in VB using access before - i'm more of a C programmer so this is quite new to me. I had noticed that in Access (2007 at least), on top of each table column is a small button that lets you filter records. If you...

Hi Guys, I was hoping to be able to have a drop down box to filter records in a table without going via a query. The reason being is that when you use a query to filter the records in a table, you cannot add to the dataset in table view. is there a way of using a combo box to invoke the...

Hi guys, i was hoping to control two tables with one scroll bar - meaning that all the rows are in line to one another. Basically one tabl;e view is the stored data, and another is the calculated data. I cant use a query to make one table as i get the "recordset not updatable" error. Cheers...