Entertainment Search Form is not showing any data

[wire_jp]

Hi Hans,

I have attached a linked Excel spreadsheet (which was linked to Google Sheet connected to a Google Online Survey)called tbLFormResponses where its data is imported into the Mcirosoft Access database called BCTSurvey Database. The qryEntertainmentResponsesCrossTabQuery and the frmEntertainmentSearchByName do not show any data (you helped me to setup the CrossTabQuery from my previous help requests), although Entertainment data is present in the Linked Excel spreadsheet.

The OneDrive weblink with the Excel spreadsheet and the Microsoft Database are attached: -
https://1drv.ms/f/s!AtOdPG-IN8CYgcV-YYl ... Q?e=b8vZOg

Another question: Do I have to append the queries each time new data is added to the linked Excel spreadsheet called tblFormResponses in order to separate the data into their own fields?

Thank you in advance

[HansV]

The linked Excel table has only one record, and in that record, the column Entertainment Activities is empty:

S0008.png

[wire_jp]

Hi Hans,

Thank you for the information. I met with the Trust Committee members to demonstrate the database, as I am running a test to see if everything is working okay in the database which is linked to the online Google Survery Form. The linked Excel spreadsheet was updated with some data but I found that the following tables, queries and forms are not populating with data:-
tblAnyOtherIdeasResponses
tblAnyOtherVolAreasResponses
qryEntertainmentResponsesCrossTabQuery
frmEntertainmentSearchByName (some of the field names are invalid).
frmAnyOtherIdeasSearchByName

I tried to use the modules called "modPopulateAnyOtherIdeasOptions", "modPopulateOtherOptions" and "modPopulateOtherVolAreasOptions" but I get a debug error

The Microsoft Access database and the Linked Excel spreadsheet can be found at this OneDrive weblink:-
https://1drv.ms/f/s!AtOdPG-IN8CYgcV-YYl ... Q?e=YnTczd

[HansV]

We seem to be encountering the same problems repeatedly.
See BCTSurveyFormDatabase - Prototype

[wire_jp]

Hi Hans,

Thank you very much for fixing the issues. Everything is working well. I really appreciate all of your help.

[HansV]

The main change was to add Nz to some expressions to handle Null values

[wire_jp]

ok, thank you for the information.