Search results for query: *

I have a VBA command that disables a button when a criteria is met. When it reaches the line: Forms!PCR_a_reprendre_options!BoutonReprendre.Enabled = False VBA tells this: Error 2164 Cannot disable an enabled control Has anyone got a clue about this? Thanks

Is there a way to modify the records in a query with totals (grouping, sums, mins, maxs, etc.)? Whenever I execute the query, there's no way to edit any of the fields, which were fully editable before converting it to a 'totals' query.

I want my DB to inform the person responsible for orders when enough records have been added. What is the command to send E-mail automatically with VBA? Thanks

My database is shared by many users, and thus is secured at user level. Recently, I added a new user (using 'user-level security assistant'), and realized that the size of my Access DB had passed from 31 Mb to 7 Mb after the procedure, but apparently without any loss of data. A bit worrying...

How can we pass any variable from a class procedure to another? For example, when the user selects a value from a combo list in a form, a second form pops up and asks a question. 1. I want the value selected in the first form to be written on top of the second form (as a title). 2. I want the...

This may sound like a very basic question, but how to make Access sort properly a column of numbers? For example, instead of logically sorting my records like the following: 1 2 3 4 5 6 7 8 9 10 11 12 Access sorts them like this: 1 10 11 12 2 3 4 5 6 7 8 9

Whenever I click on an URL in a hyperlink field of one of my Access tables, nothing happens. The link is blue and underlined, and when I move the pointer over it, it changes itself into a hand, as it does on my internet browser, but nothing happens when I click. Has anybody seen that problem...

In a combo box list which elements come from a table: When you enter a value that isn't already existing in the list, which function to use to have it automatically added to that table? Thanks a lot

Does anybody know how to sort a table (datasheet view) based on a calculated field? Access prevents the use of automatic sort buttons (A-Z, Z-A) when clicking on a calc. field column header. Thanks!

I cannot Dlookup function on a calculated control. When I use the following line associated with a control event in Visual Basic, it works perfectly well: VariableAm = DLookup("[sequence5_3_amorce]", "Liste_amorces", "[id_amorce]=" & Me![amorce_fwd]) However, when I try the same command line...