Recent content by swarm6

123dstreet -- I have been looking for a macro to back up my back end. Are you willing to share? Thanks!!

Great idea - here is the subquery: SELECT Count(tblStatistics.StatID) AS CountOfStatID FROM tblStatistics WHERE (((tblStatistics.VisitDate) Between [Forms]![frmOpenMonthMonitorRpt]![txtBeginDate] And [Forms]![frmOpenMonthMonitorRpt]![txtEndDate]) AND...

You are so kind to help. I believe it is a null because no records meet the criteria I gave it in the subquery. SQL is not my strong point either. Here it is in the build window: Expr2: Nz([CountOfStatID],0)

Hmmm. Can we see if we can resolve without me uploading my database? Here is the new SQL with your suggestion. SELECT Nz([CountOfStatID],0) AS Expr2 FROM qryFPCNNewParentSub; What am I doing wrong? Thanks for your help!!

Thank you, I tried it, but I still get null. (I left out one of the original fields, because it said wrong number of arguments.)

I have a report that is connected to the query (below). I want a number to show on the report, but if it is null it is blank, so I want a null to show as 0. Here is my SQL: SELECT Nz([CountOfStatID],0)+0 AS NP...

New information! Don't give up on me now :) When I leave form view and go to design view and back the form works correctly. What happens when I go to design view and back that would trigger this response? I have tried saving the form while it is working, but when I open it afresh it does...

Anyone else have a suggestion of why it is not working as it should?

Thank you, JHB. That got me on the right track. I tweaked it a little. I used "SetValue" in the after update of the first text box to be entered. I also have the default in the property so the user can see the default will work. I would still prefer it to work the regular way because if the...

In Access 2010 I have a Data Entry Form on which I have an unbound textbox in the header that the user can put a default date in. In the body of the form is a bound textbox that records the date and the default value is set as =defaultdatestat (obviously the name of the box in the header)...

Thank you for helping Sean. Before you posted, I started over. Made a new query, and new form. It worked fine. IDK - just one of those things? Thank you again for trying to help.

Looking for help!! I have built a couple of databases, but now am trying to "normalize" and not use the lookup field in my tables. I created a form based on a query. I added a drop down list to it so that field can be edited. However, when that field is chosen, it writes to the lookup table...