Recent content by RonnieODIN

Thanks Paul. That really was a quick fix. :)

Hi all, I would like to have 3 buttons on a form. When clicking Button1, Button2 and Button3 should be shown and Button1 hidden. When clicking Button3, Button2 and Button3 should be hidden and Button1 shown. How can I do this when it is not possible to manage the object being clicked...

I am filtering the mainform from the mainform. I cannot set Me.cboKunde outside quotes.

Hi all, I am having troubles getting a filter working. I have previously had succes setting a filter on a subform from a mainform using the following code: Me!subMaskiner.Form.Filter = "[Kundenavn] = [Forms]![frmListeMaskiner]![cboCurrentCostumer]" Now I have to filter a mainform but I...

Thanks a lot :)

Hi All, I am trying to make a column in a tabled form ascending when a certain checkbox is checked. Is this possible to do in VBA? Thanks -Ronnie.

Hi, Am I able to make sure that a value can be applied to only one record? If so how then? Thanks -Ronnie

Thanks. Really can't believe it was that simple. :)

Hi, I am making a DB which contains info of some components in machines I have. For instance I have info about the IP adress for the component. The info is filtered on machine and component but I would also like to display only the 3 newest updates for the component. The ID will not be...

I solved the problem by deleting the record source for the main report.

Thank you VERY much. Now it is fanally working. Thanks for your time, it is very much appreciated.

I can't find out how to use the AND keyword. DoCmd.OpenForm "frmRetKoder", , , "MaskineID = [Forms]![frmInfoMaskiner]![MaskineID]" And "KomponentID = [Forms]![frmInoMaskiner]![KtlFane45] + 1", , acDialog When I am having only one of the IDs in the condition I get the records sorted. But no...

Here is an image of how the report looks like in design view and in preview. I do not get why the records are shown twice when I have the fields and subs only once.

What if I need it to be filtered on the "KomponentListeID" as well?

No, the two issues are not related. Good question. I made the criteria relate to the field and control on my form instead and it worked. Just now I am shown the tables twice?