Search results

Thanks. I will give it a try and let you know how I get on.

I know I can't assign a value to the primary key, however, can it I pass the value? (might be the same as assigning, I suppose) Here's the problem: I have a main form that a user will fill out (the form has tab control with several tabs). Once the user fills out the main form, I would like...

I got it. Sorry. It's funny when you look as something as plain as the nose on your face, you can't see it.

I'm having a bit of a block as I know I've done this before. I want to be able to open a form with certain fields hidden based on the user's selection. I have a form with a combo box that has several values from which to chose. If the user selects value a, code would read: If...

Thanks SOS. I think we're getting somewhere. Still having issues, however, I've been able to isolate some points. First, I shortened the code and made it explicit. I also put in a statement that if none of the conditions are satisfied, a form would open. When I click on the search button...

Here's the code that runs for the search button (it's shortened for this thread): If Exterior.Value = "Snow Hauling" And Me.statecmbo <> "" And Me.zipcmbo <> "" Then Me.Filter = "[Vendor State] Like '" & Nz(statecmbo.Value, "") & "*' And [Vendor Zip] Like '" & Nz(zipcmbo.Value, "")...

I think this is the problem but I'm not sure... I have a form with several combo boxes and a button on the form whose code is IF ElseIf statements based on the entries in those combo boxes. When the button is clicked, the form gets filtered. The first click on the button filters properly...

I've searched through the old threads and can't find anything that solves my problem. I have multiple conditions that need to run and produce a result. I've tried Case statements and IF ElseIf statements. Essentially, when I run them, nothing happens, though I know data exists to satisfy the...

Since I posted the previous reply, I've been playing around with the code...When I run this, I receive a Run-time error '2101': The setting you entered isn't valid for this property. The code: Private Sub Button_Search_Click() Dim strWhere As String If Me.Company > "" Then...

I'm still having some issues with the from statement. I've modified my code and this is what I now have. Private Sub Button_Search_Click() Dim strWhere As String If Not IsNull(Me.Company) Then strWhere = "WHERE [Company_Name_on_W9] LIKE " & Me.Company & "" Else...

Hello All, I'm trying to create a search within a form and keep receiving a "sytax error in FROM clause" and I can't figure out why. Any help/insight would be appreciated. From a button labeled "search" on the form, I have in the OnClick property: Option Compare Database Option Explicit...