Search results

Hi all I have searched the forums and tried various options but I get an error message about the syntax. The button is to run a SQL query to update a field by calculating on the value of a another field on the form. The query is DoCmd.RunSQL "UPDATE BatchPayments SET BatchPayments.[GST...

Boy am I frustrated. I have searched the forums for similar problem but I was unable to find it. I have some buttons that export the data from a form into a Word Document. It generally works but there are some issues. I have Access 2003 but the people using it only use the runtime version of...

Hello All Talk about frustrating and I am sure the answer will be easy for some. I have a Main form with search criteria and a subform with the data. See the attached image for the layout. The data comes from a query. I have a yes/no field called "CompletedP" that I want to use to search...

Hello All I have a main form that has search filters on it with a subform in that stores the records. The filters I chose in the main filter the records in the subform. In the records there is a yes/no field. I have the filter working ok on the yes or no option but I cannot get it for all...

Hello Everyone. I have a form that gets its data from a query. There is a field in the query called "FinalisedDate" which is a date/time field. I want a button called Current that when pressed it shows all records where the FinalisedDate field is Null which is to be the default of when the...

Hello Everyone I need some help on completing a date range option on a report. I have been reading other posts about date ranges. I have got the usual Between option in the query and that works OK. However I have some records with Null values in the field and I need to pick them up as well...