Recent content by so10070

  1. S

    Solved TransformedRowSource-error

    Problem solved: I control the graph via a query (in vba) and the transformed query is then generated automatically. And ofcours the transformed query isn't editable through vba. It is read only! :)
  2. S

    Solved TransformedRowSource-error

    Thanks! I will contact isladogs.(y)
  3. S

    Solved TransformedRowSource-error

    Yes, grfBloedkenmerk is a graph control (rowsource). But by creating the graph through Chart Settings, there is no need to use a crosstab query to get a .TransformRowSource query. That I don't understand. See image (sorry it's in Flemish). My question is: how can I write this out in a...
  4. S

    Solved TransformedRowSource-error

    Got the following error : "cannot map to a read-only property". I don't understand this error. :( This is the code which I use: Private Sub Form_Load() Dim sqlBron As String Dim sqlTransform As String sqlBron = "SELECT tblPatientenLijst.PTN_ID, tblPatientenLijst.PTN_Naam...
  5. S

    Solved Theoretical question

    Thanks all for the very useful information. As I understand it, one have to choose what method he or she will use.
  6. S

    Solved Theoretical question

    It is possible to make a link between child and master through VBA, like this .RecordSource = sqlOffertesWijzigenBasis .subfrmOfferteProductenWijzigen.Form.RecordSource = sqlProductOffertesWijzigen .subfrmOfferteProductenWijzigen.LinkChildFields = "OFID"...
  7. S

    Update Front End

    I use this and it works now for several years Open BatchFile For Output As #1 Print #1, "@Echo Off" Print #1, "ECHO Delete old version" Print #1, "" Print #1, "ping 127.0.0.1 -n 5...
  8. S

    Form empty after delete record

    Thanks pbaldy! :). The WhereCondition of my delete query was the cause of this problem. I have no records anymore in the form. By setting again the recordsource of both the form and the subform I got a filled form again.
  9. S

    Form empty after delete record

    I have a form with one subform. Through the button "Delete" I can delete the records in the subform and the record in the form (referential integrity enforced). However after the deletion of the records my form is empty. The command "Me.Requery" doesn't do anything (see picture). How can I...
  10. S

    Solved Navigation pane appears spontaniously

    vhung, thank you very much! :giggle:
  11. S

    Solved Navigation pane appears spontaniously

    @isladogs: Fantastic! Thanks!
  12. S

    Solved Navigation pane appears spontaniously

    @isladogs : is the popup of the navigation pane avoidable?
  13. S

    Solved Navigation pane appears spontaniously

    I hide the navigation pane when starting my application but after this code it appears again? Strange? CurrentDb.Execute "SELECT * INTO [;DATABASE=" & txtDatabaseFilePadNaam & ";].tblOVSGToetsresultaten " & _ "FROM [Excel 12.0;HDR=Yes;DATABASE=" & txtBestandPuntenBestaat & ";].[Pagina1$];"...
  14. S

    refresh subform field

    Here you find a lot of examples to refer to a form/subform: http://access.mvps.org/access/forms/frm0031.htm
  15. S

    My query keeps deleting itself?..

    Right, that was new for me. :)
Top Bottom