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!

  • Congratulations TouchToneTommy 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: mkrets
  • Content: Threads
  • Order by date
  1. mkrets

    Type Mismatch on Form

    I've got a form with a start date and an end date field that I'm trying to use to apply a filter to a sub form. I used a snippet of code from the FAQ that looks like: strFilter = "" 'Start with a blank filter 'Verify the both ends of the start date range are valid If (IsDate(Me![txtStartDate])...
  2. mkrets

    Email link to specific record in Access

    Would there be a way to send someone a link in an email that would open up a specific form in an Access database and filter for a unique record key? For instance, you have an issue #323432 that you want someone to look at so you would send them a link that would open up Access and direct them...
  3. mkrets

    Dlookup: What am I doing wrong?

    I'm trying to set the value of a text field on the AfterUpdate event of a combo box with: Me.txtCustName = DLookup("[CustName]", "tblCustomers", "[IntCustNum] = '" & [cboIntCustNum] & "'") But I keep getting a data mismatch error. Is there something wrong with the format of my Dlookup?
  4. mkrets

    Table Design Best Practice Question

    I'm creating a new table that is going to have quite a few fields that will be lookups with set values. Is it best in that case to use other tables for the lookup values or to use set values within the Table Design?
  5. mkrets

    Outlook: Keyboard shortcuts

    This seems like a simple question that could be easily answered by Google but I can't seem to find it. When composing a message, is there a keyboard shortcut to access your contacts list?
  6. mkrets

    Excel: Hyperlink format

    I have a table of values that I'm using for a vlookup on another sheet. One of the fields in the table is a field containing a hyperlink to a pertinent page for the record on our intranet. My problem is that when I vlookup the value, it doesn't retain it's format as a hyperlink and I can't...

Part and Inventory Search

Back
Top