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!

Recent content by czechmate55

  1. czechmate55

    Combo Box with Bound Text Boxes

    Hi MajP. I'm not sure if I still have a question or not. Your suggestion worked in that it changes the dates by the room number and I am able to edit them, but the dates are defaulting to January 1900. I'm trying to find out where it is getting the 1/14/1900 info to see if I am pulling...
  2. czechmate55

    Combo Box with Bound Text Boxes

    Hi MajP It is a hospital Rehab and the combo box shows the room numbers on the floor. When the room number is selected, the patient's information is displayed. I have 2 text boxes that need edited. Admission Date and Discharge date. As the nurse pulls room 612, enters the date 5/5/2010 as...
  3. czechmate55

    Combo Box with Bound Text Boxes

    Hello, I have a combo box that needs to fill some text boxes when selected. However, the user will also need to edit the text boxes. Everywhere I've looked, I can only find info on UNbound text boxes. This is what I have for the onChange event for my combo. Private Sub Cbo_UnitNo_Change()...
  4. czechmate55

    Creating VCD in Access

    I identified each field with the Control Source. With the unbound fields, there is no control source so I don't know how to identify that field.
  5. czechmate55

    Creating VCD in Access

    In my form, I have a button that creates a vcd card so it can then be saved in Outlook. I am able to capture bound fields in the VCD, but I can't capture unbound fields. Do you know if it is possible to capture unbound fields or not? If it is possible, can you tell me how? here is an example...
  6. czechmate55

    Form View is Blank after making a change

    It works! I removed the Group By and I changed the join to display All GeoDataSet. I had it wrong and had it to display all Attributes. Thank you very much for your help and patience.
  7. czechmate55

    Form View is Blank after making a change

    Ok, I see the group by. The GeoDataSet.GeoDataSetID is the primary key and the Attribute.GeoDataSetID is the foreign key. The relationship is one to many...GeodataSetID is one and Attribute.GeoDataSetID is many
  8. czechmate55

    Form View is Blank after making a change

    Here is the SQL SELECT GeoDataSet.GeoDataSetID, GeoDataSet.GeoDataSetName, GeoDataSet.SourceID, GeoDataSet.GeoDataSetDescTitle, GeoDataSet.Purpose, GeoDataSet.Abstract, GeoDataSet.Notes, GeoDataSet.ProjectionID, GeoDataSet.DHS_SectorID, GeoDataSet.DHS_SubSectorID, GeoDataSet.DHS_SegmentID...
  9. czechmate55

    Form View is Blank after making a change

    Sorry for my confusion. I have a form for a user to fill out..First Name, Last Name, Address, etc as well as drop down boxes to select Data (segment, Sector, Scale). All information for this is on one table called GeoData. The form was working fine until I tried to add another text box for...
  10. czechmate55

    Form View is Blank after making a change

    I guess my understanding is the row source is for a combo box or list box. I am trying to bind a text box so the user can add data into that box. The only way I know how to add the field I need into the list box is to go into the record source and add the table I need. Thanks!
  11. czechmate55

    Form View is Blank after making a change

    Newbie here! I have been working on an existing form for about a week. This morning, I added a text box. I needed to add the information into the list box, so I went into the query and added the table and information. Under properties, I was then able to add the data in the Control Source...
See more

Part and Inventory Search

Back
Top