Search results

ok problem solved: here's the code i finaly used: TRANSFORM Sum([AttendancePercentTable Query].Present) AS SumOfPresent SELECT [AttendancePercentTable Query].CompareField1 FROM [AttendancePercentTable Query] WHERE ((([AttendancePercentTable Query].CompareField1) Is Not Null) AND...

basically, there are more fields in the table. the percentags are manually input for each student for a given date (when i say date i mean a given name for a term for example, so not an ACTUAL date). what i want to be able to do is have a list of all the dates for a particular child on a form...

been driving me mad btw so it would be very much appreciated for he help. the reason i need the ifo displayed in this manner is for graphing purposes. thanks adam

I have a table that has the follwoing fields: -student name -pesent percentage -compare value 1 (a number) -compare value 2(a number) now i want a query to display the following fields as an output -Student name -Compare value -present percentage 1 -present percentage 2 so where "compare...

just to add to this it then says:

also another problem is on a form with a graph on it, and when i open it i get the error this doesn't happen when i open it on my computer, but it does at work. thanks Adam

its says MISSING: CalAdapter1.1 Type library. thanks for the help by the way.

how do i do that?

i have been developing a db at home for people to use at work. it has been going well, until more recently. most of the time when i open the db at work and i've made changes to it at home, there have been problems. all sorts of things. i will give an example of the most recent: i havean...

i have a graph, and it is based on sql to generate its values. TRANSFORM Sum(redscount2.[CountOfCard Code]) AS [SumOfCountOfCard Code] SELECT (Format([fldDate],"dd mm yy")) AS Expr1 FROM redscount2 WHERE (((redscount2.[Childs Name])<>"False")) GROUP BY (Year([fldDate])*12+Month([fldDate])-1)...

managed to work it out.

ok well, the code is: Private Sub Combo5_AfterUpdate() Me.OLEUnbound0.RowSource = TRANSFORM Sum(redscount2.[CountOfCard Code]) AS [SumOfCountOfCard Code] SELECT (Format([fldDate],"dd mm"" '""yy")) AS Expr1 FROM redscount2 WHERE (((redscount2.[Childs Name]) = "frankie graham")) GROUP BY...

im trying to paste some sql behind a combobox in vb, i wont explain it all. but basically, i know i have to have the sql in " SQL " but what do i do if the sql contains "" within itself, then it is causing problems. is there either something i can put infront of the " like \" for...

ok, basically i work in a special school for kids with behavioural difficulties. we have a system where the kids get "red cards" if they behave badly. they get different types of red cards depending on what the behaviour is, and these are recorded dailly and repressented by codes (representing...

is it possible to generate multiple graphs based on records from 1 field. like you would on a report, generating a page with information for each entry in a certain field? and any ideas on how to do this, seeing as from what i understand that graphs have to stay unbound (i may be wrong)...

how can you run a running sum on a graph? i can only get my line graphs to display each value as a single value, and not add onto each other. you get the idea. anyway, has anyone got any insight into this? thanks adam

sorted the problem, was calling the textbox on the subform wrong. heres the correct code: Private Sub Calendar0_Click() Dim varCal As Date varCal = Me!Calendar0.Value Forms!RedsForm!RedsForm3.Form!Text3 = varCal Forms!RedsForm!RedsForm3.Form!Text3.Requery End Sub

i'm getting this error^^^ i'm trying to update a textbox input in a subform from my calendar on my form. here's the code i'm using: Private Sub Calendar0_Click() Dim varCal As Date varCal = Me!Calendar0.Value Forms!RedsForm.RedsForm3.Text3 = varCal Forms!RedsForm.RedsForm3.Text3.Requery...

well, i actually using 1 table as like a temp table, to get aroubd another problem i am having whilst linking calendar with a subform, but i wont go into that(see other recent posts). I actually think if i write the data to another table and the cut them and add them to update the other table...

could someone please help me out with the code in can put behind a button on a form, that will copy all records from the tabe in the current recordsource and add them to another tble with the same structure. thanks Adam