Search results

  1. E

    create tab control with continuous form

    Hi All. I'm new in Access. I would like to know how to create a Form that contains a Tab control and locate in one of a page of Tab Control the continuous form that I created yet. If it is possible. Can someone show how it to do? Thanks
  2. E

    textbox filter records in continuous form

    Hi CJ_London. Thanks for continue help. I substitute RowSource query and also made changes like you suggested. Now a filter is working. Thanks.
  3. E

    textbox filter records in continuous form

    OK I changed like you suggested Private Sub txtSearch_Change() On Error GoTo errHandler Dim filterText As String 'Apply or update filter based on user input. If Len(txtSearch.Text) > 0 Then filterText =txtSearch.Text If InStr(Format(filterText...
  4. E

    textbox filter records in continuous form

    I modified the code: Private Sub txtSearch_Change() On Error GoTo errHandler Dim filterText As String 'Apply or update filter based on user input. If Len(txtSearch.Text) > 0 Then filterText = [Forms]![Form2]![txtSearch].[Text] If InStr(Format(filterText...
  5. E

    textbox filter records in continuous form

    Hi CJ_London. Thanks for reply. It is my first Access project. I also saw online like Me.Filter but code that posted from this site: https://www.comeausoftware.com/2019/01/create-dynamic-search-filter-microsoft-access/ I modified the code for my data: Private Sub txtSearch_KeyUp(KeyCode As...
  6. E

    textbox filter records in continuous form

    Hi All. I created continuous form and trying create filter textbox. Online I found code exactly that I expecting to create. Private Sub txtNameFilter_KeyUp(KeyCode As Integer, Shift As Integer) On Error GoTo errHandler Dim filterText As String 'Apply or update filter based on user input. If...
  7. E

    alternating row colors in ListBox

    Thanks a lot. Works exactly like I expected. Now I will looking for how create search function for that. Thanks.
  8. E

    alternating row colors in ListBox

    Thanks for link. I found many helpful information since I'm new in Access. I created code for double click event for continuous form to open child form. But unfortunately it doesn't work: Private Sub txtHighLight_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As...
  9. E

    alternating row colors in ListBox

    Hi MajP. I figured out how to modify highlighted color and font for selected record in continuous form. Can you show how to create double click event anywhere on a record of the continuous form to open another form? Thanks.
  10. E

    alternating row colors in ListBox

    Hi MajP. Thanks for reply. That is interesting decision. But in that case would be better to change font color when row is selected. Can you modify and resend attached file? Thanks
  11. E

    alternating row colors in ListBox

    Hi Ranman256. Thanks for reply. I don't have purpose to make busy view of ListBox. But if possible to create alternate color (light grey, white) and keep highlight row like black I don't think that will look like mess. But contrast of of alternate row color will help to view records in a...
  12. E

    alternating row colors in ListBox

    Hi All. Is it possible to create alternate row colors in a form ListBox control in VBA Access? If yes. Can someone show how it to do? Is it possible to change font in header ListBox? Thanks
  13. E

    query for cascade combo boxes

    I mean. How create condition for certain Facilities and/or Buildings where parameter Wing should be ignore? Thanks
  14. E

    query for cascade combo boxes

    I create query for cascade combo boxes: SELECT tblLocations.LocationID, tblLocations.FacilityID, tblLocations.BuildingID, tblLocations.WingID, tblLocations.FloorID, tblFacilities.Facility & " " & tblBuildings.Building & " " & tblWings.Wing & tblFloors.Floor & "-" & tblLocations.Room AS Location...
  15. E

    how to pass rowsource from parent to child form

    And this IF statement must be in the Form_Open() or Form_Current() procedure of the child form? I coded in in Form_Open() but don't know if it is correct. Thanks
  16. E

    how to pass rowsource from parent to child form

    Thanks useful information. That is my first project and any new information is very helpful. I used code that suggested June7. It works fine. But it works for one ComboBox and two queries. That is exactly like I asked before. But I modified the form and now I have two similar ComboBoxes and...
  17. E

    how to pass rowsource from parent to child form

    Hi All. I call child form from parent form using two events First event I created to click button btnNew. It is using to open child form to create new record. Also by this event I would like to pass query1 to populate ComboBox1 rowsource in child form. Second event is double click record in...
  18. E

    Avoid duplication entries on an input form

    Thanks for sample. In you post you said that BrandID not correct have in Device and DeviceType tables. In first case if I create new device record and save data into Device table that table must to has BrandID. If need to add new device type I select value in cboBrand (BrandID), type new...
  19. E

    Avoid duplication entries on an input form

    I briefly describe my script. The f_Device form gives user ability to add new device to the system. That form has cascade combo boxes cboBrand, cboDeviceType and cboModel. When user selected all required value data will saved. In case when user need add device but brand of new device doesn't...
  20. E

    Avoid duplication entries on an input form

    Hi Pat. Thanks for reply. Didn't try yet. Can you explain you code. I mean how in your code specify BrandID and related cboBrand like first parameter. And text/string value entered in txtDeviveType text box. Thank
Back
Top Bottom