Recent content by Kanga

Thanks for that JHB. However if you put your code into the OnClick of the navigation button; it opens the form as a separate form and not within the Navigation Form.

Access 2010 newbie. I’ve set up a horizontal tab, 2 levels navigation form and under one of the main tabs l’ve created two tabs as pic1. When a user clicks either of the buttons they are taken to the same form but l would like the create button to open the form with a new empty record and if...

Hi Jiri - perfect... Thats just what l wanted, works perfectly. Thanks very much. Regards Kanga

Hi Jiri I would replace the existing variable. This table would be stored locally on each users computer to create an individuals record. Regards Kanga

Thanks Solo712 - I would be selecting the one CustomerID and storing that so at a later date (even after closing the program) it could be brought back in to generate a report.

Hi everybody, I'm using Access 2010 and am trying to pass a variable in a form field and store it in a table i.e. I have a customer database with various fields: Customer_ID, Customer_Name, Customer_Address etc. After selecting a particular record i.e. Customer_ID = 20 l need to store the...

Thanks very much for that but l had already tried that but with no success - it keeps giving a #Name? error.

Hi - sorry if this has been asked before but l cannot find it. I've just upgraded to Access 2010 and have started to learn to use the navigation forms. I've created the navigation form and have 2 forms titled Orders and Reports. The orders form has multiple records containing various fields of...

Hi everybody Newbie so please be gentle I'm developing a new database and have an opening form (A) with 2 options. 1) select an existing record number on Form (A) and open Form (B) only showing data belonging to that record. This l can achieve ok. 2) click a new record button on Form (A)...