Search results

Hey guys A thought just occurred to me. Am I doing more than necessary? I was thinking if i set the form's record source to be the query qryCompanyAndAssoc then the two text boxes could be bound to the two dates date columns in the query, but then my question is, how would the list box auto...

I changed it back to srchCriteria = "([AAEndDate] >= #" & Me.txtFrom & "# And [AAEndDate] <= #" & Me.txtTo & "#)" And also added Debug.Print task before setting the record source.But still no avail. I will still keep playing with it. Thank you for sharing your knowledge :)

Sub Search() Dim srchCriteria, task As String Me.Refresh If IsNull(Me.txtFrom) Or IsNull(Me.txtTo) Then MsgBox "Please enter the date range", vbInformation, "Date Range Required" Me.txtFrom.SetFocus Else srchCriteria = "([=lstSearchResults.[Column](2)] >= #" & Me.txtFrom & "# And...

I tried that and nothing shows up when I select two dates

So I deleted the DoCmd.ApplyFilter task and replaced qryCompanyAndAssoc with the listbox name (lstSearchResults). The error is gone but the listbox itself doesn't do anything. Not sure what I'm still missing. Also, would this method work for both date columns or do I have to include the other...

Hi everyone So i have a list box that's row source is bound to a query (qryCompanyAndAssoc) that filters company information. There's two columns in this list box that display dates. Right now I'm trying to implement a date range filter, where the user selects a from and to date via two text...

Thank you! That worked. Now my next question is I was thinking of adding a dropdown for the user to select a list of date ranges (Oldest, 2005-2010, 2010-2015, Recent, etc) and the list box filtering based on what the user selects. I'm not sure how about to go about this, I know i need to do...

Also, do I need to create more queries? Or can I use the same query just have a different criteria under each field?

Thank you for the reply. I will play around with the date field format. Much appreciated! However do you know why when I copy Like "*" & [forms]![frmMain]![SrchTxt] & "*" into the second column field which is also text (e.g. business owner's name) nothing appears in the search bar? I know "*"...

Hi everyone So I have a working search bar that filters data from a listbox based on what the user types in. The list box has 5 columns, 2 are text, 2 are date/time and 1 is yes/no data types. The search bar filters based the first column (company name) and the criteria is as follows in the...

Thanks everyone!

I went ahead and did that but how do i make the textboxes reference the other hidden columns? I click the dropdown under control source and nothing appears. Thanks!

I changed the query to only show the desired columns in the list box, but when I try to set the textboxes' control source to the rest of the column values, I don't see them in the dropdown. I also set the form's record source to the query as well. Thoughts? And much thanks from a rookie.

Hi everyone I have a table with 14 column fields and on a separate form has a list box with the record source set to this table and text boxes bound to the first 11 columns, so when the user selects a row in the list box, the text boxes autopopulate with their respective column info. However my...

Sorry, where is the instructions for recovering damaged database into an empty one? Thank you

Just out of curiosity, I notice sometimes when I get this error, I constantly try to open VBA in various ways but this error won't let me into the VBA window. But after constantly closing then reopening the database, does Access automatically save a backup file of the database?

Hello all So this error still keeps coming up, even though literally a few minutes earlier, the form was working just fine. Why does this keep happening? It is rather frustrating. If anyone has advice thank you!! :banghead:

How am I able to use a "changelog" and also version numbers under "current database"?

Ok so before the long weekend I managed to work on creating a classic login form for the database I'm working on, everything worked fine before leaving. This morning upon opening the login form I entered a random user's credentials, pressed enter and I got the same error I encountered...

Thanks everyone!