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

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

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

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

Hi all, I have a table with three colums. Every time when i enter value A in the first culum, value B must be entered in the second and C in the third colum. I was wondering hwo i could automate that process? Every time i enter something in the first colum, i want access to look up the values...

Hi all, I would like to create a query or filter that allows me the following: some fields have the same value fore several records in the table. If that is the case, i only want to display them once. So for example if i have this table: field1 field2 field3 A B...