Search results

tried that as well, no dice. Still gives a runtime error 13 - type mismatch :( Thanks, though

I've got a function that iterates through each control on the form and looks for any required fields that aren't filled in. The function worked great initially by doing the check in the module and the control iteration in the form. However, this results in the recordset (table) being opened...

Fair enough! NoMatch ftw.

Thanks! I didn't think about FindFirst. Is there a way to account for FindFirst not finding a matching record?

This is searching through a table of ~10,000 records to find whether the user-entered project# already exists, and populate the form if it does. I don't want to use a bound form here, with that in mind is this the most efficient way of searching through the ProjID field? thanks! Private Sub...

Cool, that's kind of what I figured. Just wanted to see if there were any dissenting opinions. Thanks!

I was just curious as to what everyone's rule was for when to create a new module/function versus entering the full code in the event sub.

I'm developing an idea I've got for a self-serve query system that my users can take advantage of. The goal is to eliminate some of the ad-hoc requests that I get and enable them to experiment with different datasets to find patterns, correlations, etc. This is all based in a form and...

Here's the SQL for the query. When I include the IIF statement into the WHERE clause, it doesn't return any records (even though it should). I'm guessing it has something to do with how the statement is organized, but I'm not sure. SELECT Tbl_RMS_Current_Day.[ACCOUNT NUMBER]...

On it's own, it works. Embedded into the IF statement, it does not :(

Yes, the criteria is on a numerical field. So based on the option in the combo box (in this case "60-119") I want it to only show the records where this field is > 59 < 120. The fix suggested above doesn't work (I'm guessing because the quotes interpret it as a string criteria rather than a...

I'm trying to use this if-statement in a query: =IIf([Forms]![frmReportCollateral]![cbAge]="60-119",>59<120,"") It doesn't work, though. I can do >59<120 in the criteria box and it will work, but if i put it in this if statement format then it doesn't return any records. Anyone have a hint...

Unfortunately, I can't upload files from my work PC. The functionality is blocked via IT. It wouldn't be difficult to replicate, the chart is tied to a crosstab with date/category/and balance data. The dates make up the columns of the crosstab which is what I'm trying to sort in the data table...

So here's my dilema... As you can see, the crosstab SQL statement that feeds this query doesn't let me sort the date column headers with anything aside from ascending/descending. This causes problems highlighted in yellow where in 2011, Aug is before the other months. Is there a way around...

Hi! There are a few things that will help us help you with your issue. The first is a better description of the table(s) used in your database, any queries used to calculate graph data, etc. For example: "I've got a table "TableName" with fields "FieldName1, FieldName2, ...". Second, what...

Nevermind, I got it. Had to change the X-axis from Auto to Category. :D

I've got a chart based on a query which shows dates from: Short Date Dec 2009 Jun 2010 Dec 2010 Mar 2011 Jun 2011 Jul 2011 Aug 2011 When I try to run a chart off this data, it fills in the gaps between each of the dates (shows Dec 2009, Jan 2010, Feb 2010...). How can I get it to only...

Very odd. We experience some strange things like that from time to time. We have endeared these occurances with the moniker of more "Access Shenannigans"

Is this 'main form' you mentioned populated by a query?

You know your purchasing better than I do, but my worry here would be multiple purchases on the same day with varying prices. If this doesn't occur then it probably wouldn't produce a problem, but it might not be the best way to do it. If it were me, I'd use the transaction ID to lookup the...