Recent content by Rgrea

vbaInet Many thanks for this information. When i go to set this up and run the process i end up with Run-Time error'94': Invalid use of Null. The code which i have entered in form Load is Private Sub Form_Load() AppCopy.X5reference = Me!X5reference End Sub My AppCopy Data code is...

many Thanks Uncle Gizmo Sorry i should have thought of that. I have updated the query as below SELECTTblApplications.ShortTitle, TblApplications.ProjectTitle, TblApplications.Funder, TblApplications.Scheme, TblApplications.DPAGInvestigator, TblApplications.X5reference...

Hi vbaInet, The Fields which i intend to copy will be TblApplications.X5reference TblApplications.DPAGInvestigator TblApplications.Funder TblApplications.FunderType TblApplications.Scheme TblApplications.ShortTitle TblApplications.ProjectTitle The intended locations for this information...

Thank you for helping me with this. When i run the SQL on the query i get the following data SELECT TblApplications.ID, TblApplications.ShortTitle, TblApplications.ProjectTitle, TblApplications.Funder, TblApplications.Scheme, TblApplications.InternalApplication...

Many Thanks Uncle Gizmo i have a managed to complete the forms and generate the query which is returning the single transaction i was expecting.

Hi Uncle Gizmo The intention is that only one record would be copied if the check box is ticked for that record.

Hello i have prepared a table in a database which includes a yes no box to one of the fields. The idea of the yes/no field is that this is recording if the record is awarded. What i would like to achieve is that if the yes no box is checked "True" i would like to be able to copy some of the...

Hello, i am a new user to access from the UK, looking to utilise this tool to prepare and maintain databases and looking to learn new knowledge of the access system, and thankful for any advice? Best Wishes Rob