Search results

  1. A

    more than 3 conditions formatting ??

    seems that conditional formating is very nice in Access2000+ , BUT how can I define a conditional format with more than 3 conditions ??? In fact, I have six colors for the user to select in a combobox , any idea ? Thanks :o
  2. A

    requery multiple forms ????

    :confused: I'm having multiple forms working at the same time. All the forms contain a combobox to select "client" (limited to list). The idea is there's another form to manage the client information. However, I have no idea how to update all the combobox in other forms when I updated the...
  3. A

    BACK to current record after Requery ???

    i'm deleting some records in subform after a combobox selection in mainform. However, after Me.requery (in the mainform combobox afterupdate), the mainform always go to the first record !!!! HOW could i go back to the CURRENT record in MAINFORM ???
  4. A

    BACK to current record after Requery ???

    i'm deleting some records in subform after a combobox selection in mainform. However, after Me.requery (in the mainform combobox afterupdate), the mainform always go to the first record !!!! HOW could i go back to the CURRENT record in MAINFORM ???
  5. A

    Get result from summary query into textbox

    :confused: hello, I have created a summary query to calculate a "total" , the query is giving only ONE number (i.e. a table with only 1 row and 1 column) .... but , HOW could I get that value and put it into a textbox ????
  6. A

    Result of summary query into textbox

    hello, I have created a summary query to calculate a "total" , the query is giving only ONE number (i.e. a table with only 1 row and 1 column) .... but , HOW could I get that value and put it into a textbox ???? :confused:
  7. A

    how to set unbound textbox as numeric ???

    hello, I need to use the numeric value in a unbound textbox in the WHERE clause of query .... how could I set a UNBOUND TEXTBOX as NUMERIC ??? :confused: thanks
  8. A

    where to place Trim(UCase(xxx)) ???

    Hello, I would like to transform the data entered in a textbox by Trim(UCase( )), such that I can make sure no space and lower case letters in text field. Where (which event) should I place that macro such that the transformation takes place BEFORE data validation and integrity check ? i.e...
  9. A

    Reusable Macro using [Me] ??

    Hello, Is it possible to have some "general" macro such that I can format text boxes using "self-reference" like "[Me]" ?? e.g. SetValue [Me]!Value to Trim([Me]!Value) It seems ridicious to refer to different text boxes each time Thanks a lot
Back
Top Bottom