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...
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?
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?
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.