Recent content by flofi

Check the RecordSource of your mainform. Probably, you included the table which your subform is based on into the RecordSource your mainform. So the underlying query of your mainform and your subform always have the same number of results. Remove the join you use in the mainform. I hope that...

Hi again I was able to come a bit closer to the error, but could not solve it yet: I'm using a table with 5 predefined series on it. Before creating the chart I update the table and then some series may stay blank (Null). So I always have 5 SeriesCollections but they do not always contain...

Hi I'm using a report with a Microsoft Graph 2000 chart on it. On this graph I'm setting some data labels on and off. This works well when opening the report for the first time. If I open it a second time with the same data it works well, too. But if I open it with different data (having fewer...

Thanks a lot SJ McAbney for beeing so patient with me. But this BeforeUpdate event didn't change anything when I removed it. So I forgot about it. What finally worked was to put the selection of the list row some lines more downwards. I still don't know why this changes so much, but I have my...

I don't really understand what you mean. My textField is called projectShort and is bound (I said the opposite above) to the field called the same in a table. In the properties of this textField there is absolutely no Event procedure associated. I don't use Before/AfterUpdate, OnExit or...

There is no code associated with the unbound textField. The error must occur in the code before anything can be done on the form. The code does the following: 1. create the query having one record as result 2. define the query as the recordSource of the form 3. requery the form 4. override data...

I don't have code Thanks for your answer SJ McAbney. The problem is that I don't have code manipluating recordsets. But i found the code line causing the situation. (The error only occurs after I try to exit the active control on the form. I still don't understant why this causes problems...

Hi Starting form a form on a empty NewRecord I'm looking for a specific record on a search form. When i chose another record I update the recordSource of the initial form and requery the form. After that, if I want to move from one field to another I get this error message: "Update or...

print the forms out Hi What do you mean by "transform to a paper version"? Can't you just print out the forms? Regards flofi

If I understand it correctly, you must just link one table from one database to the actual one and then perform an append-query where you append all fields form one table to the other table. flofi

Hi Probably an easy thing to do. I have a query with different names which are numbered. But there are some numbers missing, like this: name number Joe 1 Joe 3 Joe 4 Joe 6 Tom 1 Tom 4 Tom 5 ... How can i renumber the query without using vba to get this?: name...

I have a query based on 3 tables all of them linked by a one-to-one relationship. I'd like to update the data of the table at one end where a condition in the table at the other end is true. Unfortunately Access doesn't allow me to do that. Why? The same thing works in if I just have 2 tables...

That's good stuff! Thanks to you both

Hi How can I address a subform with DoCmd. E. g. to save the current record or goto another record in the subform. I can't use Me... because the command button is located in the mainform. When I was using Call DoCmd.GoToRecord(acDataForm, subformName, acGoTo, recordIndex) the subform was not...

Hi I've changed the underlying query of a subform. Unfortunately when I use Forms("mainformName").subformName.Requery the subform stays empty even if the query shows entries. I don't want to close the form and reopen it. For the mainform I was able to solve this by renewing the RecordSource...