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! :)
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...
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...
It is possible to make a link between child and master through VBA, like this
.RecordSource = sqlOffertesWijzigenBasis
.subfrmOfferteProductenWijzigen.Form.RecordSource = sqlProductOffertesWijzigen
.subfrmOfferteProductenWijzigen.LinkChildFields = "OFID"...
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...
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.
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...
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$];"...