Search results

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...

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...

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...

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...