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
Hi guys/girls,
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.
Thanks
Darren
-
-
IDG Tech News
-
19th December 2012, 06:27 PM #2 [SOLVED]
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.
-
SHARE: 
Similar Threads
-
By adamf in forum Enterprise Software
Replies: 45
Last Post: 12th May 2012, 02:34 AM
-
By Jobos in forum Enterprise Software
Replies: 4
Last Post: 2nd October 2011, 10:45 AM
-
By srochford in forum Windows
Replies: 5
Last Post: 2nd May 2010, 09:33 PM
-
By ryan_powell in forum Web Development
Replies: 0
Last Post: 31st January 2008, 02:52 PM
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules