Search results

I guess your problem is that the column names in your crosstab query change depending on what data is returned. Dynamic crosstab queries are possible, allthough I've never tried them, have a look at this link: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320 Alternatively, you...

Unfortunately, you can't delete records from a linked spreadsheet. Adding shouldn't be a problem though...

My problem was that I needed to somehow control over which query/table the function was run. I managed to add an extra criteria, so that has been solved. However, the performance of any query that uses this function is extremely slow for some reason. Any idea what I could to to improve this...

Hi everyone, I got the following function from the microsoft support site (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210138 ). Function MovAvg(Region As String, MPG As String, startDate As Date, Period As Integer) Dim rst As DAO.Recordset Dim sql As String Dim ma As...

Or export it to PowerPoint: http://www.access-programmers.co.uk/forums/showthread.php?t=83231&highlight=powerpoint

If you want to show a list of all available criteria then you would need a query as the rowsource. Set the rowsource type to query/table (in the property sheet of the listbox), and then the code would go something like this: Private Sub OptionGroup1_AfterUpdate() if OptionGroup1.value = 1 then...

Hi, something like: Private Sub button1_AfterUpdate() list1.rowsource = something End Sub Or if you're using an optiongroup: Private Sub OptionGroup1_AfterUpdate() if OptionGroup1.value = 1 then list1.rowsource = something elseif OptionGroup1.value = 2 then...

Okay well I figured it out, Format(FieldName,"percent"). I now have a new problem, I have two series of percentage values, and I'd like to see them in a column - line chart with two axes (with two other series for columns). Unfortunately I can't seem to get two lines in the chart. Anyone got...

I have a chart that shows a bunch of percentage values at different periods in time, nothing special. However, when I add a datasheet the values are regular numbers instead of percentages. I have changed the format in the datasheet (which corrects the values in design mode, but not in preview)...

Thanks for the reply, but that doesn't solve my problem. If you look in the attached file, object number 7 should be a child of number 3, but for some reason it ends up under number 5.... Lucas

Hey everyone, I have a treeview control which is based on a table. For some reason it won't fill properly, it doesn't add the nodes under the correct parent. If someone could look at the attached file and help me out I'd appreciate it. Lucas