Search results

  1. S

    Problems with Null

    My DB is in Access 2002. The problem now is I have a field called "CE number" that I want to either have a value in the form of (Input Mask: "CE"######? or null) First of all what exactly do I put into input mask? However, I've fiddled around with it a lot. My main problem is this... When...
  2. S

    Add items to LISTBOX

    I want the listbox in my form to display 3 strings. How can I add these 3 strings to the listbox?? P.S. Don't thinkg Additem works for me...
  3. S

    AfterUpdate() vs. Click()

    MICROSOFT ACCESS The situation is: I have a listbox that lists cord blood ID #'s. When an item is selected from this list, information (such as Date, Type, etc.) are displayed in text boxes; this is taken directly from the table, I made it with a wizard. You can also select a date from the...
  4. S

    AUTOselect LIST BOX

    When the form is opened I want the first item in the list box to be selected and highlighted...you can do this with a combo box but what would I need to type (Under Private Sub Form_Open) to do this with a list box?? THANKS
  5. S

    SELECTION for list boxes

    My Database keeps track of blood samples and the date they were frozen. Right now I have a combo box connected to a listbox...so that when you select a date in the combo box all the blood samples frozen on that date appear in the list box. However, I also added a "ALL" entry in the combo box...
  6. S

    Stumped on LISTBOXES

    I'm writing a DB to keep track of CORD DNA samples. Right now I have all my sample names in a list box. I also have a combo box with all the dates and a search button. I want it so when I select a date in the combo box then click the search button only the samples that were frozen on that...
  7. S

    Getting rid of duplicates in ComboBOX

    Alright, in my Database I have many samples that are frozen on different dates. What I'm trying to do is create a combo box with all the dates included. And when a date is selected, display all the samples that were frozen on that date in a listbox. However, I've run into a problem already...
  8. S

    Can I use a LOOP?

    In my program that's connected to a form I have code like: 'Row 1 If TextExist("A-2-A1") Then Me.L1.BackColor = 16776960 End If If TextExist("A-2-A2") Then Me.L2.BackColor = 16776960 End If If TextExist("A-2-A3") Then Me.L3.BackColor = 16776960 End If If...
  9. S

    ComboBOX autoselect

    The deal is I have a form that is based on a table in Access. IT's hard to explain so I just give an example. if I have Dude A, 5'8", White abd Dude B, 5'7", Asian.... In the form the person can be chosen from the combobox and depending on the person that is selected, the text boxes...
  10. S

    Easy Microsoft Access/VB question

    I have a combo box in a form and I want to search it for certain strings. Right now I'm only doing If Me.Combo0.text = "hello" then whatever... But that only tests the text that is currently selected. How would I test every entry in the combo box to see if any entry was "hello". If I...
Back