Search results

Could you do all these sums with a query instead, and bind the form to the query? That would probably be faster than either of the options you gave.

Include whatever the checkbox field is in your query for the rowsource for the list box, and put True in the criteria row beneath that field. As far as opening the form, more information is needed. Are you opening the same form regardless of selection in the list box and want the form's data...

TJ, take a look at the thread from this post: http://www.access-programmers.co.uk/forums/showpost.php?p=1324854&postcount=18 and see if that helps you figure out how to do it. Bear in mind when filtering dates that they need to be surrounded by hash signs (#), so a filter based on matching a...

Shane, good job extrapolating from what we'd done already. :) You had a missing space and a missing statement, but this ought to get it: Dim strWhere As String If Me.Ckbnodate = True And CkbNodate2 = True And cbknoinvoice = True Then strWhere = "[Date Work Started] Is Null AND [Date Work...

Rachelle, I'm glad to be able to help. :) I can't count the number of times I've banged my head over some frustration as I've learned my way along with Access, VBA, and SQL, but one of my favorite things about what I do is that I'm still learning, 16 years after I first started. New problems...

Shane, This ought to do it then: Dim strWhere As String If Me.ckDateFilter = True AND ckDateFinishFilter= True Then strWhere = "dtDateStart Is Null AND dtDateFinish Is Null" ElseIf Me.ckDateFilter = True AND ckDateFinishFilter= False Then strWhere = "dtDateStart Is Null AND Not dtDateFinish...

Shane, are you checking for dtDateFinish to be null as well, or are you checking it against a date value or date range? P.S. It'd be great if you'd click the Thanks button on the post that resolved your question. :)

TJ, are you currently outputting your report based on parameters in your query or on a filter generated in VBA code?

Since your problem was resolved, please update the thread subject with "[SOLVED]".

Try the following instead: Dim strWhere As String If Me.ckDateFilter = True Then strWhere = "dtDateStart Is Null" Else strWhere = "Not dtDateStart Is Null" End If DoCmd.OpenReport "report1", acViewPreview, , strWhere It's untested air code but will probably work.

Shawn, I repeat, what is the code you are using to open your report that you want filtered? Marla

CurrentDb.Execute "UPDATE dbo_Reservering.Betaald " & _ "SET Betaald = '" & me.lijstKeuzeBetaaldVeranderen.Value & _ "' WHERE Reserveringnummer = txtReserveringnummerAuto", dbFailOnError Inserted your missing space for you.

Assuming you want donors who donated 60+ days ago and not in the last 60 days, Google "Allen Browne subqueries." He has an example on that page that's virtually identical to your situation.

A few questions: First, can there be only one person per project? If not, you don't want SSN in your projects table (using SSN as ID is of questionable legality in this case, as well). Second, do the employees refer to projects by database ID? If not, you probably want a field for project name...

If that is your code exactly, you are missing a space before SET.

Another way would be If ckCheckbox1 = False and ckCheckbox2 = False and ckCheckbox3 = False Then Msgbox "You must select an option from one of the checkboxes!" Cancel = True End If

Andy, one table for engineers with a field to distinguish between types, another to assign department, and another for branch. You may want to just make it an employees table and put the managers in there as well.

The first thing I'd check with an issue like this is that "Division Manager" is actually that in all cases, not "Division Manager " or " Division Manager " or "Division Mgr." You could try something as simple as changing your Iif expression to a wildcarded version that would cover those...

The easiest way to do this is with a combo box ("the arrow that you click on and get the drop down menu with the name choices there"). Unless your names are more than 255 characters or you've limited the fields to fewer characters than are in the name, there should be no reason for the full name...

TJ, go ahead and add your radio buttons and post here which numbered value corresponds to which option, and kindly provide the name of the date field to be queried. If you post your current search code (in between [co de][/co de] tags, please! -- remove the spaces), I can show you specifically...