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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BDCarrillo
  • Content: Threads
  • Order by date
  1. BDCarrillo

    "Filter by on load" problem with dates

    Trying to do the following: Filter records to show only those whose "End_Date" is equal to or greater than today. This will be set on the form properties. I've tried the following: End_Date>=Today() End_Date>=Now() End_Date>=Date() All of the above with #End_Date#, and all of the above with...
  2. BDCarrillo

    MS Excel VBA: Using .Find to search in cell comments

    I'm not sure how to go about this... I need to find the row.id of text in a cell COMMENT that matches a string. Dim Rng2 As Range If Trim(strTCrsName) <> "" Then With Sheets("Transcript").Range("Q1:Q100") Set Rng2 = .Find(What:=strTCrsName, _...
  3. BDCarrillo

    Filter string formatting help

    TM and TY are temporary strings pulling a formatted Month and Year from hidden columns on a combo box. Filtering the year OR month only works just fine, but the string below with "AND" throws a runtime error 13 type mismatch. strWhere = "Month([Expense_Date])=" & TM '^ Works fine strWhere =...
  4. BDCarrillo

    Multi-Word search/filter from a text field--working prototype

    This bit of code will search a text field and display matching records. It will search forrecords that contain multiple keywords, in any order. Form/table items: btnSearch-Button to initiate search btnSearchClear-Button to show all records/clear search txtSearch-Unbound text box, no default...
  5. BDCarrillo

    Write to a specific record with VBA?

    Here's the info: tblShop_Names Shop_Name Shop_Code Locked - Yes/No Locker - Text (used to store username) I've written the following code: 'check if shop is locked If Me.Locked.Value = 0 Then 'open shop_form And [Shop_Code] = 502, load global variable DoCmd.OpenForm "Shop_Form", acNormal, ...
  6. BDCarrillo

    DCount Multiple Criteria-Formatting Issue/Data Mismatch

    Trying to prevent a duplicate record from being added by the following logic: "If there arent any records that already have the same start date and shop code, allow record creation" In the Roster_Data table, [Start_Date] is a date and [Shop_Code] is a Long. sDate and sCode are pulling data...
  7. BDCarrillo

    Linking multiple tables and presenting a combined output

    Here is the basic data model & background info: -12 different work centers, each with distinct information -Weekly recurring shifts with up to three employees per week (simple friday-friday, no issue with holidays/time off) -Ability to generate a weekly roster report of workcenter supervisor...
  8. BDCarrillo

    Correct implementation of database concept? Insight needed/execution

    Here is the basic data model & background info: -12 different work centers, each with distinct information -Weekly recurring shifts with up to three employees per week (simple friday-friday, no issue with holidays/time off) -Ability to generate a weekly roster report of workcenter supervisor...

Part and Inventory Search

Back
Top