Hi,
I hope someone can shed some light on this issue.
I'm pretty novice at creating Access Databases, but have managed to butcher the Contacts template for a Web Database I'm creating.
I have it working mostly, but part of the requirement is to have a search form created so any fields can be searched on, and the results displayed in a clickable list.
From looking in the forums, I've found a couple of posts that seem to address the issue (creating a form with a search button, and a query that the macro calls when clicked).
However, when trying to create the macro the "Update Parameters" hyperlink in the macro builder does nothing when clicked, so I'm unable to enter the parameters for my query in the macro.
Is this the right way that I should be trying to configure a search form? Or is there another way that I could be addressing it.
The database is a Web database and sync'd with Sharepoint online.
The fields of the table being called are:
first name, last name, PhoneMobile1, PhoneMobile2, WorkPhone, Company, Sector, Job Title, Email Work, Email Personal, LinkedIn, Notes, lastContacted, App Created, App Modified, ContactName
If anyone is able to point me in the right direction I'd be extremely greatful.
Thanks
John
I hope someone can shed some light on this issue.
I'm pretty novice at creating Access Databases, but have managed to butcher the Contacts template for a Web Database I'm creating.
I have it working mostly, but part of the requirement is to have a search form created so any fields can be searched on, and the results displayed in a clickable list.
From looking in the forums, I've found a couple of posts that seem to address the issue (creating a form with a search button, and a query that the macro calls when clicked).
However, when trying to create the macro the "Update Parameters" hyperlink in the macro builder does nothing when clicked, so I'm unable to enter the parameters for my query in the macro.
Is this the right way that I should be trying to configure a search form? Or is there another way that I could be addressing it.
The database is a Web database and sync'd with Sharepoint online.
The fields of the table being called are:
first name, last name, PhoneMobile1, PhoneMobile2, WorkPhone, Company, Sector, Job Title, Email Work, Email Personal, LinkedIn, Notes, lastContacted, App Created, App Modified, ContactName
If anyone is able to point me in the right direction I'd be extremely greatful.
Thanks
John
