Search results

by marked MISSING do you mean the available references that are unchecked? Because I'm looking at this now the first four are marked checked but everything else downward is unchecked

Hi I meant the latest version of Access, which is Access 2016. And yes I was using this version on the database because normally I use the 2010 version however yesterday I was relocated to a different computer which had the newest Access installed. I didn't "upgrade" anything though, I just...

Hi everyone This morning when I went to open this project I'm working on, everything was frozen none of the tables, buttons, tabs or anything else worked. I tried opening and closing it a few times but each time it opened, everything was frozen. For the most part I use the 2007 - 2010 version...

Hi everyone, So I'm trying to follow this report dialogue sample (courtesy of Microsoft Community). On the form "frmMultiFieldDlg_1" is basically exactly what I need. This form filters reports based on two combo boxes and a date range criteria. I made a form similar with a date range and two...

Thanks guys!

Hi everyone I have a list box with a number of records but displays 5 out of 13 columns from a query, however I need to include one more column. This additional column will be a drop down that lists items specific to each record. Originally a combo box on the form was used to display the items...

Hey guys So I deleted the previous button, made a new form based on the agency table and added a new button. And now the new entry appears on the list box. So the simple solution here was to delete and add a new button. Even though this problem is now technically solved, I'm still open to...

Yes, SearchResults is the list box name. I tried putting: Me.SearchResults.Requery Into fromAddNewAgency's AfterUpdate event, but I get an error saying Compile Error: Method or data not found With SearchResults being highlighted. I assume this is because SearchResults is not on this...

Do you mean something like this: Me.SearchResults.Requery Be applied to AfterUpdate or AfterInsert event procedure?

Hi Everyone So I have a list box based on a query with a number of records. My last issue was the list box not filtering based on either what the user types in or by date range. However I'm happy to say (thanks to Microsoft Community) that, now both search options work. However a new problem...

Never mind guys I got it (with the help of Microsoft Community) working by adding a confirm button which the on click event handler to Me.lstSearchResults.Requery and declaring parameters for the date/time to prevent values being confused as arithmetic vs dates entered. Thank so much!

Hi guys here's a pic of the SQL in design view. Not sure if this helps but I figured I'd include it. As it currently stands, there is no more syntax error and the date range text boxes filter between dates as intended however, the search bar no longer filters as the user types.

Hi thank you for the reply. I'm working on making those changes you've suggested. The second part of the code And ((tblCompany.CompanyName & tblAssociation.Associate & tblCompany.AAEndDate & tblCompany.ISExpiry) Like "*" & forms!frmMain!SrchTxt & "*")) is for when the user starts typing the...

Hi everyone, as some of you may know I've been working on a search criteria that filters a listbox based on what the user types into the search bar or using a date range criteria. While I finally got the date range to work (thanks to you guys :D) now the search bar won't filter the list box as...

Hi everyone So I've learned recently that splitting the database onto a "live" and "dev" version is beneficial since its more secure and the user interface would be easy to modify. I'm considering doing this but first I would like a little more info. I'm presently the only one working on it...

Hi I don't want the text field to display 0 or -1 but just to display the same text as whats in the list box column which is either yes or no. But thank you for the recommendation. I will play around with it more. I should mention, the listbox's row source is set to a query between two tables.

Hi everyone so I have a list box with a yes/no data type column. I also have a text box set to that specific column and on the list box, each row in the list box appears as either yes or no but on the text box the values are either 0 or -1. How can I make the text box display the same as the...

I'm presently facepalming myself because I didn't know it was that simple. Real rookie mistake but least I'm learning. Thank you so much!

In the builder criteria section of AAEndDate I did this >=#1/1/2000# And #12/31/2009# For the text boxes I have them set as the default values of #1/1/2000# and #12/31/2009# date from and date to respectively. Is this what you mean by "sensible expression?" Thank you.

I should mention I have a search bar that filters the list box based on what the user types. This following SQL statement selects the all important columns but the search bar filters through Company and/or Association values. The two date columns I would like the listbox to filter by are...