Search results

I subscribed to your videochannel my friend.

Its solved, the button of the other field was set to a embedded macro instead of event procedure. :)

Ooh yes you are right, thanks so much! It was set to Embedded Macro probably because I copied the button or something.. +rep for you.

Thank you so much for making a video, I learnt a lot! I got it working by putting some VBA as I wanted a multi selection box. (try clicking on the button in the attached file) but the second one doesnt seem to work, so I put that question under the VBA section. Thanks!

So My Toggle Filter works for the first field when you click on the button in the form 'Mut ' . But the second button/field doesnt work. any idea why? Caused by blanks so it cant focus? Code: Private Sub Command216_Click() Form.Projectnr.SetFocus DoCmd.RunCommand acCmdFilterMenu End Sub

I have put a toggle filter button on top of each field. (Form ' Mut' ) When I click the button, nothing happens (probably because there's no code) How do I make it pop up the selection of that particular field so I can select whatever I want of that field? (like in Excel) I remember in 2010 I...

Ah yes your right, its working now, thank you =) +rep

When I click on a Lastname in the Navigationform I get this error: Specified field 'klantnaam' could refer to more than one table listed in the FROM clause of your SQL statement. Probably because my form is based on a query that has two tables with Klantnaam in it. But they are all the same. I...

Very good, thanks a lot +rep

I want my textbox FirstName to work. So I have a Dlookup that has to search for two criteria. I need to lookup the FirstName field in the table Klanten. It just stays empty in my form after I click a Customer and contactperson in the comboboxes. txtnaam contains the customername that it has to...

I have a query ' Mut1' and I want it to show in a new field the running total of the field Rent but only for the rows where the event = 'in'. So it should skip counting the values if the event is 'out'. Any idea how I can get it in the query (probably an expression) In the report I can do a...

I corrected it now. the query is super slow. (for example, click on the filter of Date..) And the Runtotal doesnt make any sense, its all the same. It should be going up with the field ' inuit'. So if inuit is 1 the runtotal should go up +1. And if inuit is -1 the runtotal should be total -1...

I created an expression in the query Mut2 called: RunTot Its supposed to be a running total.. but its not working. And above that , the query is super slow because of that. First field has to be the date, from old to new. Any idea how I can make the runningtotal, and a fast query? RunTot...

Got it: =Count(IIf([Mut]![Rent3]='Rent';1;Null))

My query Mutaties1 also counts the empty cell (2019/10) of field CountofRent3. How is that possible? Anyone who could help me out? thanks! I tried in the criteria of query Mutaties1 of field Rent3: =Count(IIf(IsNull([Rent3])=False,1,0)) <>Null

Solved it. Had to delete the .company as I renamed it it to another name.

When I click in the form on the 'TO OUTLOOK' button after filling in some fields i get the error. It used to work but It says there is an expression error. Any idea how to solve it? thanks! (when clicking on the button, your outlook will open and all the fields will be automatically filled in...

Thank you for your answers. Autocenter was already set to NO, and Moveable cant be set to YES as stated in my first post. I tried the repaint but didnt do anything either Private Sub Form_Load() DoCmd.Maximize Me.Repaint End Sub I guess its like AccessBlaster says, its too big, so it does...

My form doesnt open on top.. how do I make it open where I see the top and all the tabs of my form? Something with Me.move 0,0 on the Onload ? That didnt work. The form setting Moveable cant be set to Yes somehow.

Got it with the builder Forms![Navigation Form]![NavigationSubform].Form![NavigationSubform].Form![POnr] Thanks for the help!