Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    Thanks Steve for the first time the DLookup is working and getting the wuantity,the only problem it does not change the label color but it changes the all label writtng.The label was minimum reach but now when the minimum is reached it s writtng white.What can be missing Steve



    Regards

  2. #17
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    Yes it did work Steve thanks a lot.But the label just remains Red and i can not carry on with the transaction.It s just red.

  3. #18
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What is the code you are using??

  4. #19
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    Problem fixed thanks a lot guys,i give some props to this forum where do i go to put problem solve and what can you advise for me to understand more vba(books,websites etc...)

    Is it possible then for the minimum to change color as well on the stock form when the update from the invoice form is done?

    I mean when the stock is on minimum

    Regards

  5. #20
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Do you mean if Stock Amt = minimum amt?
    Maybe something like this:
    Code:
    If stockamt = ts then
          'Set back color = yellow
    ElseIf  stockamt < ts then
          'Set back color = red
    Else
          'stockamt is greater than ts
          'Set back color = Green (or White)
    End if

  6. #21
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    Not really;in my case i have got a stock table as well with a minimum value.This same minimum value is use in DLookup.
    But on the invoice form it is changing ,i ant it to happen at the same time in stock form as well

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 04-25-2016, 02:13 AM
  2. change tab color or header color
    By witz07 in forum Access
    Replies: 6
    Last Post: 03-31-2016, 05:31 PM
  3. Changing font color of just part of a label
    By NGFLNG1 in forum Access
    Replies: 3
    Last Post: 09-11-2015, 11:02 AM
  4. Replies: 5
    Last Post: 09-18-2012, 12:39 PM
  5. Replies: 1
    Last Post: 03-29-2009, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums