+ 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
    Lakeville, Carleton County, New Brunswick
    Posts
    695
    Thank Post
    140
    Thanked 197 Times in 138 Posts
    Rep Power
    74

    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. #2
    DT2
    DT2 is offline
    DT2's Avatar
    Join Date
    May 2011
    Location
    Lakeville, Carleton County, New Brunswick
    Posts
    695
    Thank Post
    140
    Thanked 197 Times in 138 Posts
    Rep Power
    74
    [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
  •