Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Spruce4U

  1. Spruce4U

    Cannot disable an enabled control

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

    Cannot disable an enabled control

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

    How to modify records from a Query with totals

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

    How to have Access automatically sending email when a criteria is met?

    I'm impressed! Huge thanks for the fast and pro answer.
  5. Spruce4U

    How to have Access automatically sending email when a criteria is met?

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

    How to have Access automatically sending email when a criteria is met?

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

    Drastic decrease in database size after adding new user, why?

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

    Drastic decrease in database size after adding new user, why?

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

    Access VBA: How to pass variables from one class procedure to another?

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

    Access VBA: How to pass variables from one class procedure to another?

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

    Access VBA: How to pass variables from one class procedure to another?

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

    Access VBA: How to pass variables from one class procedure to another?

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

    How to sort a column of numbers properly?

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

    How to sort a column of numbers properly?

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

    How to sort a column of numbers properly?

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

Part and Inventory Search

Back
Top