Search results for query: *

In answer to the second question, I changed to "Null" instead of "" and that fixed the filtering issue. THANK YOU for all of the help gents. Stars all around.

I have another question related to this. If I want to create a button to clear this filter and reset the combo boxes that control it, what is the best way to do that? I'm currently using: Private Sub btnClearFilters_Click() Me![frmSubActivity].Form.Filter = "" Me![cboCategory].Value...

The values are dates. In that particular instance they were: Start: 1/21/2008 End: 1/31/2008

It's a "Runtime Error '13'" if that helps.

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])...

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...

Thanks jbarnett, that was the problem.

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?

Thanks all. Those are the answers I was looking for.

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?

Shift+Control+B works. Thanks!

Yep, you have to type a few letters of the contact first but that works as described. Is there a shortcut to bring up the list that doesn't require typing?

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?

I guess I don't understand what you are saying. I am looking up the address that the hyperlink should point to. When I use the look up it returns the URL I want but not in hyperlink format so a user can click on it.

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...