Search results

hi again... this time, I have a sells table, and I want to create a chart, displaying the evolution of the number of sells through the years... but again, I have no ideia of what to do... I just want to group the number of sells in all the years, and then, create a chart based on that... it's...

Hi, I have a dynamic chart like this: in the x axe I have the name of the produtcts and in the y axe I have the value of money. each product is divided in 4 parts: Q1, Q2, Q3 and Q4. When the type of the chart is columns, everything works fine... But when I try to change the type to Line...

I, I have a query with this line in it: WHERE (((Compras.Date) Between #01-01-2001# And #31-12-2001#)) but i want to turn it more flexible, letting the user to choose the year he wants. But I don't know how do i join the day and month to the year choosed by the user... I've tryied stupid...

thanks. Private Sub CC_AfterUpdate() Dim db As Object Dim rcdset As Recordset Dim qdef As Object Set db = CurrentDb Set qdef = db.CreateQueryDef("Top_", "SELECT TOP 10 * FROM tops") Set rcdset = qdef.OpenRecordSet() Me.Recordset = rcdset db.QueryDefs.Delete...

Hi, is it possible to force a form to display only, say, 10 records at maximum? I've trying to use maxrecords property, but i guess i must playin' around with ADO and stuff like that, and I just can't do that... I'm creating a database to a work for school, so, my teacher didn't tech that kind...

Hy. I'm a newbie to MS Access, and I would like to know how can I change a form's subform dynamicly, at run-time. For example, the main form is "Persons". If the current record or person is male, I want the subform to be "MyCars" with all cars' properties. If the person is female, I want the...