Search results

Thank you all! (y)

Can I hide this pull down menu on run time?

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! :)

Thanks! I will contact isladogs.(y)

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

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

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

vhung, thank you very much! :giggle:

@isladogs: Fantastic! Thanks!

@isladogs : is the popup of the navigation pane avoidable?

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$];"...

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

Right, that was new for me. :)

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

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

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