Search results

cheers that was spot on

I have a form with 3 subforms and I want them as view only and have separate forms to add/edit and delete rows, my question is how do I "lock" the fields on my main form?

Cheers - the crux of my problem is that I need to count those in treatment at the end of each month, but they might have started before that month so they dont have any date values in that month.

I have pre christmas developers block and cant figure this out, it appears simple!! I have a table with Date Started Treatment, Date Treatment Completed going back 3 years. I need to produce a monthly summary for the last 12 months to show how many people were in treatment at the end of each...

ping - any help - I am still looking for a solution

I have a line chart with 3 years worth of months on the X axis (36 points) and I have a 3 year trend line. what I need is another trend line for the last 12 months, I have added a field in my data with just the last months data points but when I add a trend line to that one it goes right back to...

I have a line chart with 3 years worth of months on the X axis (36 points) and I have a 3 year trend line. what I need is another trend line for the last 12 months, I have added a field in my data with just the last months data points but when I add a trend line to that one it goes right back...

Got there evetually - I had to tirck it by adding more columns that I needed - the line came in on the second and 5th column in the data table and any new column I inserted got a line not a bar! so I had too many bar fields by adding a couple of spares - this enabled me to delete the line on the...

Simple... Just create another query based on the 2 queries you already have and join them on the month Field, then just show one month field and the data fields from each sub query, then use this "Parent" query. Make the graph and lines on 2 axis type so you will have revenuse on the left Y...

:o 2000 with MSGraph.Chart.8 I have a simple crosstab source query going into a bar chart and I want one line to use as target - I have changed it to the "classic Bar/line" graph type and I can change the colours fine, but I cant seem to control which fields use bars and which use lines - also...

I have 12 months worth of appointments and need to show totals per month so I make month/year with datepart "m" & "yyyy" but the months dont come in the right order on the cross tab. Has anyone got a trick to resolve this please?

I want to build something like this: http://gis.chicagopolice.org/ using access 2000/ MAPx 5.0 and Map info:( I have got all the street maps and Geo data I need, what I would like advice on is how to build a neat and funky GUI app for my end users to have an experience like the ESRI...

I have Access 2000 and Mapinfo 8.5. I would like create an interactive map (maybe on a form) where users can choose what to display on the map, Schools, Hospitals Ect. from a drop down box I have all the Geo data to create what I need in Map info, but I want to use Access to roll it out...