Search results for query: *

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?

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

Fneily, Thanks for the fast answer. No panic here, there hasn't been any calculated field made in a table. I was actually done on a form, which itself was based on a query. I understand from your answer that the calculated field is done directly on the query itself rather than on the form...

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!