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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: th2002
  • Order by date
  1. th2002

    DoCmd.RunSQL and parentheses in field name

    Hi! Table name: Table1 Field name: OrderNumber(AutoNumber) I need to run SQL using this field name and now parentheses in the name is giving me hard times. DoCmd.RunSQL "DELETE * FROM Table1 WHERE OrderNumber(AutoNumber) LIKE " & intNumber & " ;" This statement would...
  2. th2002

    Opening form based on combo box in other form

    This is one way to do it... Private Sub select_Click() Dim Client As Variant Client = Me!clients DoCmd.OpenForm "View_amend_client" DoCmd.GoToControl "ID" DoCmd.FindRecord Client DoCmd.Close acForm, "Select_client" End Sub -TH-
  3. th2002

    Choosing BackColor when control isn't enabled

    You're right! I tought I tested that and thought it does work, but... Thanks to you both, Maq and hennep!!! -TH-
  4. th2002

    Choosing BackColor when control isn't enabled

    Thanks for your reply, Maq! I forgot to tell that I need to change the value in the disabled control. I change the value by VBA so I could unlock the control before and lock after the change. But somehow I still feel like there got to be easier way to do it. -TH-
  5. th2002

    Choosing BackColor when control isn't enabled

    Hi! I'm having trouble with back color in text box control when Enabled property is No (False). Access changes back color to grey when I change this property to No. But I would like to keep it white like it is when Enabled is Yes. I have tried to change the back color from control's...

Part and Inventory Search

Back
Top