Search results

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...

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)...

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

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...

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

what code do i need to use to copy the info in an unbound combo box, to a record from the click of a button? i ant to keep these field unbound by the way. thanks Adam

I need to update a subform each time a differen date is clicked, but there is no onClick in the prefrences of Calendar Contol, so i can't work out how to do this. Could someone please help. Its driving me mad. thanks adam

is it possible to use calendar control 11 to select records in a subform that are from the date selected (there is a field in the recordsource table with the dates for each record). so when you click on 1 date in the calendar records from that date automatically appear in the subform from that...

ok - i've made a couple of databases for my workplace (a secure unit for 11-14 year olds), and they have really helped out. I hadn't really used acccess before but thought i would give it a go. anyhow, these databases took me hours and hours, because i was learning how to use access whilst...

I have a form that has a running sum on it of a value. each value has a date attached to it. so for example Childs name 1 week start points total points -relevant values for that child- Childs name 2 week start points total points etc etc etc...... so anyhow it appeared...

I know the theory behind what i want to do, but need some help programming this into my report. I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does...

well basically i have a field that displays a running sum, and what i want it to display is the running sum upto 350 and then start from 0. What i was thinking, is it possible to code the text box that displays the running sum to store the value of the running sum, but the code says only show...

I have a running sum on a report. What it does is add up points students at a school get each week. now the students get bronze award for reaching 75 points, silver for reaching 150, gold for reaching 250 and platinum for reaching 350 points. when they reach 350 points any additional points...

I've designed the following report but cannot get it to do what i want. The source of the report is all from the same query. What i want is for the targets(1-5) to be displayed based on the record from the last set of fields displayed on the bottom section of the form. here are the print screen...

I've opened a merged word document from a button on a form on my database, but is it possible to also have it set the data source on the word document to the current database when it opens it from the form button? Im using access 2003 btw. Thanks

using ACCESS 2003 This code should do what I want, and it seems to, but every time i run it it says: No Current Record when i ctrl+break it the debug get hung up on the end sub. heres the code, any ideas? : Private Sub Command16_Click() On Error GoTo Err_Command16_Click Dim i As Integer, cnt...