Search results

I figured it out. Because the field was a Yes/No it did not like the True or False. I changed the statement to the one below and it worked fine. All I needed to do was put the field name in place of True or False Thanks for you suggestion...

I have an option group on a form that us used as criteria for a query. There are 3 options in the group. The field being filtered is a yes/no. Below is my statement. I cannot get the true and false records to show. 1 = both, 2=True, 3=False...

I think I have found the answer. Adding set rs = nothing, rs.close, and CurrentDb.Close after I use a record set seems to have done the trick. Does anyone have recommended standards for how to open and how to close recordsets properly? Thanks, vmon

Yes I am using recordsets. I "set rs = nothing" at the end of the section of code. I am so new at recordsets I don't know what I should be doing. vmon

I am not sure I follow you. I put docmd.quit on the switchboard close event but get the same result. The code I run updates a few fields on the form. The application is not exited after the button push. vmon

I have not been programming much. What are the standard closing activities for screens, modules, and applications? What event are they put on? thanks, vmon

I have a form that runs some code and when it runs I can close the form and database window but Access will not close. I have to use task manager to kill it. This is a big problem for my app. Code is involved and long but runs and finishes without error but something is hanging Access. I am...

I have graph in a report that show data by week. Problem is the sort is looking at the week as text and not sorting properly. Below is the code. Am I using function wrong or how do I convert "ww" to a number? (Format([Date],"ww")) Thanks, vmon

I am trying to insert records into a table and want to use a form control as one of the columns. This is what it looks liek right now. strSql = "INSERT INTO tblRate ( ModelId as " & strQuote & Forms!frmCopyModelRates!cboToModel & strQuote & ", " _ & "RateNumber, Activity...