Recent content by kez

Sorry if this has already been discussed on this forum, but I haven’t found it as yet. I am using Access 2013 and have 4 currency fields, the first 2 with amounts, the 3rd to calculate the tax owed on a calculation of these 2 fields and the 4th to calculate the total of the previous 3 fields. I...

Hello All Please excuse me as I am a novice. I have searched the forum but need a little bit of extra help. I have an application form with a command button to duplicate a record (created from the wizard). All works well but users forget to change the date field to the current date, so I end...

Many Thanks I hadn't thought of that solution I was looking for a combo box or list box. But your solution will work better for me. Once again thanks again I don't know what we (the not so well informed)would all do without this forum. Kez

Hi All I have created a report based on a query based on 2 tables - one with client name & client id and the other with client visits eg date, details, invoice amt and paid etc. The report shows all clients with all client visits. I would like to select from a list box a single client and...

Hi All I am a big novice when it comes to access so please excuse my ignorance. I need to create a word template from a form created with a query. My problem is that I don't want the null fields to merge to the template (there can be up to 30 blank fields), currently the useres have to delete...

YOU ARE A GENIUS this works great and has made my database much more foolproof so THANK YOU very very much. Kez

Many Thanks for taking the time to help. I've attached a test mdb for you - similar to what I am currently using (without additional fields of course).

Auto Fillin Fields Thanks that was a really big help and it worked in his example - But I couldn't get it to work for my form. His example only used 1 table and one form based on that table. I have two tables and one form. I have a main table with client name and a second table with a combo...

Hi I am a real novice at code but was wondering if anyone could help. I have a from called Forms Request with the following fields: Client (Combo Box), Address, Suburb, State, Post Code etc... I also have a table called Client with the following fields: Client Id:, Client:, Street Address...