Search results

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?

Yes, my subform is showing all filtered records matching the criteria. E.g. I had 4 records in my subform but only one record (the first) in the opened form. The name of the field related to the main form is "MaskineID" but I also have a tabbed control which a field called "KomponentListeID"...

Hi, I am having some trouble getting my report work correctly. I have a report, repKomp, based on some sub-reports which are based on queries. I have two criterias for the queries - the same two for all - saying that two FK's must be filtered on a variable, Mask and Komp respectively. I...

Sorry for my late response. I have tried both of the following codes: DoCmd.OpenForm "frmRetKoder", , , "KodeID = " & Me!subKoder, , acDialog DoCmd.OpenForm "frmRetKoder", , , "KodeID = " & Me!subKoder.Form!KodeID, , acDialog The first line will result in error while the second line will...

But as I mentioned earlier: Using the code on the first page only returns 1 record for me.

I can't make it work. I have suited the code for my application: Dim rs As Object Dim lngBookmark As Long lngBookmark = Me!subKoder.Form!KodeID DoCmd.OpenForm "frmRetKoder", , , , , acDialog Set rs = [Forms]![frmRetKoder].RecordsetClone ' This is where the bug appears...