Recent content by PedroSantos

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

I have a listbox, and I want to create a query based on what I choose in the list box (although in the example it always creates the same query). I'm receiving a type mismatch error, and i'm using access XP. thanks. Pedro Santos

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

No, that's not what i want, because I wanna be able to order the results by one field, and then, by other field. So, the query must be done using all the records, and then sorted properly... thanks anyway Pedro Santos

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