Search results

  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. :)
  16. S

    Listbox displaying only numbers

    You make a lot of errors to define your relations. first of all: a primary key refers to a foreign key from the first table to the second one. You can't set a relation between two tables on the two primary keys you have to set a relation one to many between both tables: from table one primary...
  17. S

    My query keeps deleting itself?..

    I think the structure of your WHERE-clausule is wrong. You put it like this: ... WHERE table.Field1 = FormFieldProperty1 OR FormFieldProperty1 IS NULL Of course there's an error on your destination field, because you define in the first half of the WHERE-clausule the FormFieldProperty1 as a...
  18. S

    Buttons on footer to choose next / Previous Records on - SFrm

    Hi, What you have to do is to give the properties of the subform the right values: Record selectors to NO and Navigation buttons to NO. Then create a button on the main form with some code like this: docmd.GoToRecord, me!subFormOfAnyKind.Form,acNext - acPrevious - and so on. The error you can...
  19. S

    error 1004

    The numeric value was used in two places (two loops) in the procedure: once to cycle trough a table and once to set dynamically (based on user input) the size of the range in the workbook.
  20. S

    error 1004

    Have found the sollution! I had declared only one time a numeric parameter and used it in two different ways in the procedure. I have declared a second parameter and the procedure is working well. It was definitely an Access problem! Ok, in the future I will update an example program.
Top Bottom