+ Reply to Thread
Results 1 to 7 of 7

Search and ADD Forms Blank Cells In Products

  1. #1
    Banned User!
    Join Date
    08-02-2022
    Location
    US
    MS-Off Ver
    365
    Posts
    188

    Search and ADD Forms Blank Cells In Products

    Hello,

    On the Report sheet when I click on the Search or ADD shapes the popup forms have many blank cells on the products. Why is this and how to fix please?

    Also the font is appearing grayed out in the text fields can these be normal black font?

    Thank you

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Search and ADD Forms Blank Cells In Products

    Just had a quick look...

    Change loop counter in Show_Product sub procedure to

    Please Login or Register  to view this content.

  3. #3
    Banned User!
    Join Date
    08-02-2022
    Location
    US
    MS-Off Ver
    365
    Posts
    188

    Re: Search and ADD Forms Blank Cells In Products

    Thank you that fixes the Search but the Add is still showing blanks.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Search and ADD Forms Blank Cells In Products

    You need to change the same for frm_Update_Inventory.

  5. #5
    Banned User!
    Join Date
    08-02-2022
    Location
    US
    MS-Off Ver
    365
    Posts
    188

    Re: Search and ADD Forms Blank Cells In Products

    Than you. What about the gray text in the form boxes?

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Search and ADD Forms Blank Cells In Products

    Text boxes with grey font are set Enabled propty to false, that means you can not edit.

    If you change the Enabled property to True, it changes the color.

    Is that what you are asking?

  7. #7
    Banned User!
    Join Date
    08-02-2022
    Location
    US
    MS-Off Ver
    365
    Posts
    188

    Re: Search and ADD Forms Blank Cells In Products

    Yes thank you. I will try it.😊😊

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search Range for NonBlank Cells, Fill Down only one cell below NOT all Blank cells belof
    By safari20WDG in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-07-2017, 01:23 AM
  2. sum of products of a search for a value
    By skim123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2016, 04:51 PM
  3. Search products below par and create an order list
    By Danimal39 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2015, 04:17 PM
  4. best way to search duplicate products on two excel sheet
    By intouch01 in forum Excel General
    Replies: 2
    Last Post: 08-01-2015, 12:51 AM
  5. Getting the sum of two products, but leave blank if blank.
    By Talk_4 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2015, 03:27 AM
  6. Lots of Products and blank cells - Most efficient way
    By fiwa in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-15-2011, 12:55 PM
  7. Print on ready blank forms (document forms)
    By gandrinno in forum Excel General
    Replies: 1
    Last Post: 02-16-2009, 06:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1