Recent content by tekkyun

Just the job - works exactly how I need Thanks again Duane Mike

Thanks Duane, I did try that but have not found answer. Can you point me to appropriate thread? thanks

Hi, Does anyone know an easy way to join text data within grouping query? For example, I have data like this:- Field1 Field2 A Gr1 B Gr1 D Gr2 E Gr2 F Gr2 and would like to get result like this:- Result1 Field2 A B C Gr1 D E F Gr2 Thanks

Hi, I am responsible for maintaining a number of ms access databases on our company network. These are all written in access version 2000/2003 and all use the Excel 11 code library. I have recently upgraded my pc to office 2007 and now find that when I perform any updates the code library...

I have tried that but this just transforms the stacked bars so that I see dates instead of the booking codes. I am still unable to see x axis labels.

Yes, most properties can be set but not x axis category labels using source data option as per excel it seems. I can understand that the data source is different in access and I will be unable to just select a range as per excel, so maybe the answer is in the data structure? I have currently...

I have a stacked bar chart in MS access 2003 and need to set x axis labels (currently not displayed). This is easy in Excel as I can select Chart / source data option from menu. Unfortunately this option is not available when using Access. Does anyone know of way to to this?

thanks for quick response guys, The recordset is a table that is generated on the fly by users selecting options on a form. This table is then used as a recordsource for a subform. I am currently switching the sourceobject of the subform to another table, then updating the temp table with the...

Can anyone point me to some code which will delete a field from a recordset? I have tried to use Delete Method (Fields.Delete field) but it won't allow deletion whilst recordset is open. If I close the recordset then how do I refer to the fields to delete? What I am trying to do is:- 'Open...

That's it! Far too simple! I was using .recordsource and not .sourceobject to switch focus to another table whilst refreshing my temp table. I assumed that fields in form would refresh in line with recordsource change but it appears that they don't. thanks Duane

I have a subform that has a source object based on a temp table. This temp table is re-created when users select options on the main form. The fields within my temp table also change accordingly. How can I 'refresh' the subform to reflect the changes to the fields in the underlying table...

Thanks guys. That's useful to know.

Does anyone know why my database file size increases by about 50Mb when I import 936 Kb JPEG image file to a form? I have tried compacting the Db but it doesn't make any difference. How do I import image to use as form background without this problem?

That's it. I just added Dim Rs as recordset and used this:- Dim rs as recordset Set Rs = Ctl.Form.Recordset Rs.FindNext "OrderNo = " & PO & " And OrderLine = " & POLine Seems to work great! thanks for your help

I am just using the subform recordset, ie ctl.form.recordset.