Search results

hi, i would like to recreate the "apply filter" button on the toolbar in VBA. It should be able to: * apply a filter when i am in "filter-by-form"-mode * remove a filter when one is applied * (optional: re-apply the last filter) How would i do that? I dont think docmd.applyfilter is what i...

ok, i found that i should do the calculation in a query instead of in the form. Now it is indeed stored. But the problem now i that i cant add data in a form thats based on a query. So back to the same question again: how should i proceed?

hi all, i have a mainform with a subform. in the subform i have 2 fields: duur and subtotaal in duur i enter a number. in subtotaal a calculation has to occur: =20*([duur]/60) i tried to do this calculation in VBA but then i got the same value on every record in the subform. But now the...

thanks, but it seems to be rather a standalone program? How does it relate to Access?

i was wondering if anyone could give me some help with this: I am looking for a way to retrieve the EXIF information in a *.jpg file in access. I think its possible, but dont have a clue how. Thanks!

hi, i found a very easy way: make a new query based on the 2 others mentioned above, and then in the field i type this formula: totaalsom: [inBalans BTW in]-[uitBalans BTW in] this works for me! thanks!

ok, but what if i dont want to sum but substract those totals? i think this wont work then?

hi, i have a query that calculates totals per month. I have 2 of those query's, and i would like to sum those totals once again, also sorted by month. How should i proceed? Thanks! Matt

anyone please?

i think it adds one record when i press enter (at that point the messagebox appears that asks if i want to add it), and then a second time when i enter the data in frmExample. Question1: why does it only do so when i select a recordsourse for frmStart Question2: how can i get around it so thet...

just checked and the limittolist property for the combo in frmStart is set to yes

i added this so you could more easily see what i mean

Ok the script u gave me works fine on its own. But from the moment i select tblExample as a source for frmStart, and i want to add a new value in the combo, it adds it twice to tblExample. Moreover, when i reopen frmStart, the newly added values only show something in the combo, and not in...

ok, i tried the example u provided and that works fine. However then i transfered that to my own database, but i do not get it to display the message "... is not in the lest do u wanna add it". I have exactly the same event procedure added to the "not in list" situation of the combo. What am i...

ok my bad, it seems to work for now...

thanks getting a VB runtime error however when entering a new value ("you cant assign a value to this object")

nobody who would like to help me out here?

I already did that but it doesnt work either. I'm sure it can be adapted, but im not a VBA scriptwriter, so i wouldnt have a clue how to to that...

yes, but i am talking about data that is not stored yet. so i need to enter a value in the combo, that is not yet in the combolist. And together with that i also have to enter new values in the second and third field.

Hi all, I was wondering if it is possible to update more then i fields in a table by entering a new value in a combobox? Right now when i enter a new value in the combo, it puts that value in the first field. But i would like to update 3 fields (of wich 1 is the combo), because i cannot update...