Search results

Problem solved !!! On the continuous form for Luncheons display/update I have a button for 'Add New Luncheon'. This has an 'On Click' event that ... 1. Opens an unbound form to collect the basic identifiers for a new luncheon 2. Runs an append query to add the new record 3. Closes and reopens...

Reply to Pat Hartman. Thanks for your input. The use of a form to add a record is specific to the new luncheon where data must be input by the user. I am in the process of changing this to a form with unbound fields that will be assigned to TempVars used by a new append query. The creation of...

To put it in context, this refers to the luncheon events management for a sports club. The continuous form supports the update of past and future events in Table C and the button on-click opens up a form to add a new luncheon. When a luncheon is added it is necessary to create a ticket...

The event sequence is ... From a continuous form for Table C - button on-click event runs macro. Macro Closes continuous form Opens another form to add a new record to Table C Form closes on exit Opens continuous form again On Load event of continuous form Tests for new...

No triggers

Thanks JHB. I have already tried your first two suggestions and do not have any timer running. I will look at the decompile option now.

Running full Access 2016 (O365) on MS Windows 10 with linked MySQL database. I have a simple append query that creates one record in Table A for each record in Table B. (Table B contains 189 records.) When run directly it runs from beginning to end without problem. When run as part of a...

Thanks for the welcome. I look forward to learning and sharing.

Hi, I'm robinatsel located in North East England. I was a programmer long before Access or even PCs were invented but left my coding career behind many moons ago. The requirement to put something together for a sports club inspired me to pick up Access and experience again the pleasure of...