Recent content by Spruce4U

Actually I solved it by manually setting it to 'disabled' in the properties of that button control in form design view. From then on, for no apparent reason, the VBA code had no problem enabling/disabling the control. Weird stuff...

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'm impressed! Huge thanks for the fast and pro answer.

Perfect PHV, it works. However, a warning appears that says that a program is attempting to send email in your name and that allows the user to stop the sending. Is there a way to turn that warning off? Many thanks, Sébastien

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

Thanks lespaul. Apparently, Access automatically runs the compact and repair command (which I didn't know about before you told me) when you add users to a secured DB. That's good to know. Many thanks again, Sébastien

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

Ok, now it works perfectly for passing data (via OpenArgs) from the first to the second form, thanks. Now, what about passing info from the second form to the first? I succeeded in doing it by storing data in a table to which is linked my 2nd form and getting it back with DLookup in my 1st...

Great thanks AceMan, Remou and Jebry, I'm trying your suggestions right now. Thanks again for replying so fast.

Thanks Remou. However, the first form is in datasheet view, and when in the second form, specifying Forms!frmfrom!txtText to reach the first one won't do because there are many records listed instead of one as in a single form view. In addition, the second form is in acDialog mode, which...

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

PHV, Here is the SQL code for 2 calculated fields, the second one (col) giving the sorting problems. IIf([pos_sur_plaque]<>"",Left([pos_sur_plaque],1),"") AS row IIf([row]<>"",Val(Replace([pos_sur_plaque],[row],"")),"") AS col where: [pos_sur_plaque] is an alphanumeric chain in the style of...

PHV, Thanks but actually, the calculated field uses the Val function already. belovedcej, thanks for the comments.

It is a calculated field in a query and I have put the format 'general number' to it. Do you have any more clues?