Recent content by Frenstall

Hey lagbolt, this looks like what I'm looking for, just couldn't seem to find it when I searched... thanks for the help!

Hello, I am wondering if there is an efficient way to create an explorer style drill down for a location/equipment table I have i.e. -Dept +Finance +HR -Quality +Supplier +QA -General +Etc1 -Etc2 +Production I have used the tree control to acomplish...

Hey thanks, I got it going and it works relatively quickly (considering there's over 20,000 records)

Well, heres the situation. I have a complicated query that refuses to work all the time using a linked table for the data (data is gathered from a FoxPro DB). If I copy the data into a local table in my database then the query will run fine. The data needs to be updated only 1/month but I don't...

I really doesn't matter, it could be a date and it would still work fine. The query that captures the funtion return performes a datediff so a string is acceptable. I am not sure if there is a difference time wise.

Thank-you for the help Gizmo! I also realized that the field I was trying to access (txtDate) is calculated from a combobox selected by the user. Cosequently when the form loaded the txtDate field contained #error since the calculation contained a Null value. I modified my code to detect if...

I am trying to resolve an issue of being able to use a query from many different forms where the query is dependent on the date selected in the current open form. Right now it calls the function getDate() which works fine. Unfortunatly the function is called before the form is fully loaded and...

I have a database where all reports are by month. I want a simple way to allow the user to select the month/year and want to know if I can use the header portion of the calandar control for this (although I can't seem to figure that out). The alternative is to use two combo boxes (Month and...

I have a multi-pivotchart I am using to display data. Each chart shows a score for the month (taken from the date field). What I would like to do is display the three month average as a fourth column in each chart. (or at least the average alone since I only show 3 months anyways) i.e. jul, aug...