Hi All,
I am on a deadline and am really struggling.
I have been working with access for just over a year and recently created a web database which has to be put up onto the sharepoint server.
My Navigation form contains an unbound textbox and an unbound combo box which contains types of the equipment we work with (Equipment, Rack, Battery ect." The user is to type in a key word (Such as a name, manufactuer, height) and they were to then select which form of equipment they were looking for.
My query contains a coding ( Like * & [Form]![Navigation]![Textbox] & * ) which is placed in each collum of the query which may be used to search and ( [Form]![Navigation]![Combo] ) in the look up of the same table used for the combo box but in every coloumn that has the first coding. So both A key word and an equipment type are needed.
It was only upon trying to upload to sharepoint that I realised that these codings wont work within my query.
I am unsure how to go about making paramaters that will allow multiple "OR" objectives.
The main point of my database is for our contractors to be able to look up a specific piece of information for documentation purposes, meaning that the database will be read only for those who access it the search is commpletly neccessary. I am unsure what to do.
Please Help.
Thankyou
I am on a deadline and am really struggling.
I have been working with access for just over a year and recently created a web database which has to be put up onto the sharepoint server.
My Navigation form contains an unbound textbox and an unbound combo box which contains types of the equipment we work with (Equipment, Rack, Battery ect." The user is to type in a key word (Such as a name, manufactuer, height) and they were to then select which form of equipment they were looking for.
My query contains a coding ( Like * & [Form]![Navigation]![Textbox] & * ) which is placed in each collum of the query which may be used to search and ( [Form]![Navigation]![Combo] ) in the look up of the same table used for the combo box but in every coloumn that has the first coding. So both A key word and an equipment type are needed.
It was only upon trying to upload to sharepoint that I realised that these codings wont work within my query.
I am unsure how to go about making paramaters that will allow multiple "OR" objectives.
The main point of my database is for our contractors to be able to look up a specific piece of information for documentation purposes, meaning that the database will be read only for those who access it the search is commpletly neccessary. I am unsure what to do.
Please Help.
Thankyou
