Search results
-
T
Findfirst with Variable Field Name
@Gemma: This solution worked, thank you @Galaxiom: SearchFor Me, [Field].Name, SearchBox.textI was passing the form, the name of the field I wanted to search, and the text inside the searchbox to use as the value to search for. I'm fairly certain the error occurred due to how I was passing...- Trucktern
- Post #9
- Forum: Modules & VBA
-
T
Findfirst with Variable Field Name
frmCurr.RecordsetClone.FindFirst chr(34) & [varf] & "=" & valf & chr(34) This code returns "Runtime Error 3001: Invalid Argument". I had tried adding quotes to this code before with similar results before. Dim strFind as String strFind = varf & "=" & valf...- Trucktern
- Post #6
- Forum: Modules & VBA
-
T
Findfirst with Variable Field Name
I've recently been rewriting the code for a search function I had, so I don't have to replicate the code on every single form I create, but can call it using a sub on a module. However, I can't get findfirst to work properly. Currently, my code is set up like this...- Trucktern
- Thread
- Replies: 9
- Forum: Modules & VBA
-
T
Access Beginner trying to consolidate table
Hey everyone, I'm currently an intern just getting started with access, which not that many in my department use. I'm currently working on prototyping a proof of concept database for some financial data, and while everything I've done has been simple enough so far I've run into a bit of a...