Recent content by jamjarr

It Works Thank you very much.

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...

fixed it I forgot to set the References. Thanks for your help.

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...

Thanks very much it works. However it does not interact with the other search criteria. So if I chose a particular Staff and set the option group to Yes it will show all Staff that have the jobs completed. Almost there.

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...

Format Value as Currency Ignore my last post I have worked out the issue. Thanks. Post a reply if you require the way that I got it working.

Format Value as Currency Hello I am new and need some help. I have two fields that I want to pass to a word doc as currency fields. I have fiddled around with my code (hoping for a hit but getting misses) with the suggested code. My code for passing values to the word doc from a form are...

Access Bookmark Problem Hello everyone. I have searched for this problem and there is a lot of discussion about parsing the current record from a form to a Word document. The record source of the form is from a query. I have tried lots of the code submitted in other threads but to no avail...

Ignore my last message. Sorry I found it. Whatta goof. It was in the VBA area and on the toolbar.

Duplicate Record - References on Tools Sorry if my question seems dumb. The microsoft solution says. "On the Tools menu, click References, and then click to select Microsoft DAO 3.6 Object Library. Click OK". For the life of me I cannot find "References". Is there something that i am...

Calculating Dates Thank you very much. It works wonderfully. Now to the next hurdle. Regards

Sorry for the misunderstanding The database works fine for me. However I want to extend the functionality by having the values in the years months and days text boxes in the form. I was wanting to use these values for other uses so i was wanting to write these values to designated fields in...