+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1
    DT2
    DT2 is offline
    DT2's Avatar
    Join Date
    May 2011
    Location
    the locals call it buttf*** nowhere...
    Posts
    665
    Thank Post
    120
    Thanked 187 Times in 130 Posts
    Rep Power
    70

    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

  2. IDG Tech News
  3. #2
    DT2
    DT2 is offline
    DT2's Avatar
    Join Date
    May 2011
    Location
    the locals call it buttf*** nowhere...
    Posts
    665
    Thank Post
    120
    Thanked 187 Times in 130 Posts
    Rep Power
    70
    [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:
+ Post New Thread

Similar Threads

  1. Replies: 45
    Last Post: 12th May 2012, 02:34 AM
  2. Limiting access to Exchange 2010 GAL
    By Jobos in forum Enterprise Software
    Replies: 4
    Last Post: 2nd October 2011, 10:45 AM
  3. Problems accessing web sites with certificates
    By srochford in forum Windows
    Replies: 5
    Last Post: 2nd May 2010, 09:33 PM
  4. Open password protected access 2007 database with ASP
    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
  •