Search results

Thanks Pat, that was the trick (as your signiture says). I found the master/child field thing before but it gave me inconsistent results so I quit trying. Now that I force requery it works perfectly. Thanks again. SWK

I am trying to create a report where there is one graph for every record in the detail section of the report. I can place the graph in the detail section but I don't know how to generate a different graph for every value. I tried to change the rowsource property of the graph in the OnFormat...

Wow Wayne, this was great, worked perfectly. I could have spent an other lifetime figuring it out. Many thanks. SWK P.S remove brackets from - RefreshNode(nodX, Depth + 1)

I have a very simple recursive function below, which seems to work well. I would like to be able to specify how deeply the recursion can go - how many levels to refresh, but though I spent a long-long time trying am still unable to find a way to do it. Thanks for your help in advance. SWK...

That is what I thought. I will need to convert all SQLstring= _ "Select .................." rst=cn.Execute(SQLstring) Me.DropdownControl.Recordset=rst Into SQLstring= _ "Select .................." Me.DropdownControl.RowSource=SQLstring which is not a big deal in most cases but sometimes...

Silly me - I thought that if I told Access2002 to save my adp file in an Access2000 form it will be Access2000 compatible. Access2000 gives the following error message:"Method or data member not found" at the line Me.DropdownControl.Recordset=rst Its probably because of the different versions...

Hello, I have a command button in the detail section of a continuous form. Can I grey out and enable/disable this button for individual records? I couldn't figure out how to do that. Thanks for the help. SWK

That was it. Many thanks. SWK

Does somebody have a suggestion how to do, or emulate the context sensitive right-click in Access? I can generate now a recordset of the available functionalities and it depends on what the user right-clicked on, but I don't know how to display those functionalities so that they most closely...

I've got it now: Set objTree.ImageList = Me.ImgList.Object Do you know how to change the picture on expand - not on select.

I use this line of code - it looks similar to yours. Set nodCurrent = objTree.Nodes.Add(, , strKey, strText, Image:=1) But it gives an error message: Cant add child - Imagelist must be initialized before it could be used.

Ok, so I can create and add images to the imagelist through the GUI. But how do I tell the Treeview to use the imagelist I have created?

Hi Fofa, yes, but how do I add and initialize an imagelist and how do I add images to it in VBA? Many thanks for the help. SWK

Hi I started to work with a Treeview control. I ran into two problems. 1. I couldn't find out how to add images to nodes - I see that i have to work with an imagelist, but I don't know how. 2. I would like to use context sensitive menus when I right click on a node. I can get a message box...

First thing to say is that I haven't tried this myself yet - but I may need to do something similar soon, so I would be very interested If you posted back your solution when you find one. I would experiment with the References object: - IsBroken property, could list your broken references...

Thanks for the reply FoFa, If I understood it correctly the method you are suggesting is very similar to the one I was thinking about. The common language table would look like this: UniqueID (int) TableName (varchar) ColumnName (varchar) UniqueIDinTable (int) LanguageID (int) -- eg...

If I run the report withouth grouping the field is displayed correctly, but if I move the same field up to be a group header I get an error message "can't find the field referred to in your expression". The text box has the same name as its control source - all in all it doesn't look like a...

I am assigning a recordset as the recordsource of a Report (the recordset is coming from SQLServer). The report runs fine but if I try to group on a field in the report I get an error message saying that Access cant find the field I am referring to. Is there a workaround to this problem - or...

Hello all, I need to store names and descriptions of records (like ModelName, TestName, NormName, NormDescription etc.) stored in different tables on different languages and enable users to translate them into their own langueges. What is the usual method for this - do I create a separate...

I did put the object creation in a public variable in a standalone module but I didn't no that I need to keep a form open in order to reference the public variable - this is good to know. I tried an other way meanwhile and it seems to work for me. Instead of keeping the reference I check if I...