Office Software Thread, Access Web database 2010 in Technical; Hi guys/girls,
I'm in the process of building an asset tracking system for the business. I've built the databatase, forms ...
19th December 2012, 12:23 PM #1
Access Web database 2010
I'm in the process of building an asset tracking system for the business. I've built the databatase, forms and macros, and published using sharepoint 2010 access services.
When I use access to test the forms it works great, there's navigation bars at the bottom with record references and a search bar. When I publish it, the search bar disappears and I can't for the life of me create a search field on a form without it changing data. I've tried lookup fields, combo box selection, but it just appends data to the record which I don't want. I only need to search one field (ID - Computer name) and bring up the resulting record in its entirety. Anyone got any tips/ideas? I'm not all that good with access and could be missing something quite simple.
IDG Tech News
19th December 2012, 06:27 PM #2
I built a blank form with unbound text fields, then added a command button with an embedded macro containing a TempVar and OpenForm object. You can now search the databse in a web browser and it opens the corresponding option in a new window. Perfick.
Something I didn't realise - you have to use TempVars otherwise the browser doesn't recognise the object reference( [Forms]![Formname]![Field] ).
Last edited by DT2; 19th December 2012 at 06:28 PM.
By adamf in forum Enterprise Software
Last Post: 12th May 2012, 02:34 AM
By Jobos in forum Enterprise Software
Last Post: 2nd October 2011, 10:45 AM
By srochford in forum Windows
Last Post: 2nd May 2010, 09:33 PM
By ryan_powell in forum Web Development
Last Post: 31st January 2008, 02:52 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)