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 John Tel 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 mbrichmo

  1. mbrichmo

    How to hide Shortcuts in Shutter Bar/Navigation Pane in VBA

    Hi, I found the code: Application.SetHiddenAttribute(acObjectType, name as string, hidden as boolean) I don't know the rules linking to other sites but to give the person that posted credit, his name is Tim Ferguson
  2. mbrichmo

    How to hide Shortcuts in Shutter Bar/Navigation Pane in VBA

    Thank you for your reply kjv1611. I don't want to hide the shutter bar though. I want to hide a shortcut in the shutter bar with VBA. The shortcut is to a form. I want to set the shortcut Hidden attribute to true using VBA. The use case is providing a single database front end to multiple...
  3. mbrichmo

    How to hide Shortcuts in Shutter Bar/Navigation Pane in VBA

    Hi, Does anyone know how to hide a shortcut from the shutter bar with VBA?
  4. mbrichmo

    Transforming field values to new boolean fields in a query

    Hi, I would like to transform via a select query a table of the form: PatientMeds(PatientID,Med) to the form: TransformedPatientMeds(PatientID,Med1,Med2,...Med_n) I know the names of the specific Meds and can specify them explicitly. After the transformation I would add criteria for example...
  5. mbrichmo

    Find data associated with most recent record

    I would like to know how to get the data associated with the most recent record for each value of a given field i.e.: Orders(OrderID, OrderDate, Customer, Item) Find the most recent order for each customer and return the item for that order. Thanks!
See more

Part and Inventory Search

Back
Top