User Profile

Collapse

Profile Sidebar

Collapse
tbutler
tbutler
Last Activity: Nov 22 '21, 01:09 PM
Joined: Nov 16 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • tbutler
    started a topic Grouping and Sorting a report or form, Please Help
    in Access

    Grouping and Sorting a report or form, Please Help

    I've tried this on both a report and form and have had no luck.
    I have 7 fields and am trying to group my form by 'Part Number' and then sort by 'Date Added' I have multiple of the same part
    number (intentionally) . Right now I have the 'Part Number' grouped together and my form/reports are sorted by 'Date Added' date first.
    However, my problem is that I have to also sort by 'Part Number' using ascending or descending (it won't...
    See more | Go to post
    • tbutler
      started a topic Using checkboxes with a search box
      in Visual Basic

      Using checkboxes with a search box

      Code:
      Private Sub btnSearch_Click()
    Dim SQL As String
    Dim Avionics As Integer
    Dim Powerplant As Integer
    Dim Shops As Integer
    Dim Structures As Integer
    Dim Systems As Integer
    
If IsNull(Me.txtOrderSearch) Or Me.txtOrderSearch = "" Then
    MsgBox "Please Type in your search keyword.", vbOKOnly, "Keyword Needed"
Else
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...