Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 4th, 2012, 09:50 AM
seuta seuta is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2010
Posts: 2 seuta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 26 m 24 sec
Reputation Power: 0
Access Form Search

Hello, I could use some assistance. I am trying to create a search/filter for a form but it is not working.

The database I have created is an inventory database. The only complexity is that the field "Location Initials" in the "Assets" table pulls values from another table called "Locations."

In my form, I am trying to do a search of assets based on where they are located. I am using a combo box that pulls the locations from the locations table to perform the search.

I created something like this over a year ago but cannot remember what I did and do not have access to that resource. From what I can tell, I have to create a query to search by in the VB code for this to work.

Any help would be greatly appreciated while I continue to work on this issue.

Reply With Quote
  #2  
Old January 4th, 2012, 11:43 PM
June7's Avatar
June7 June7 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2010
Location: The Great Land
Posts: 256 June7 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 9 h 29 m 29 sec
Reputation Power: 5
Review these tutorials:
http://datapigtechnologies.com/flashfiles/buildcustomfilter.html
http://datapigtechnologies.com/flashfiles/searchform.html

One way to show the location associated with asset is to have the form's RecordSource be an SQL that joins Assets and Locations tables. This will make all related data available for display on the form. The search combobox should not be bound to any field.

Then apply the principles from the tutorials to your form.

Is this form to be used for data entry?

Reply With Quote
  #3  
Old September 15th, 2012, 07:05 AM
dbgurus dbgurus is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2012
Posts: 1 dbgurus User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 34 sec
Reputation Power: 0
One way to show the location associated with asset is to have the form's Record Source be an SQL that joins Assets and Locations tables. This will make all related data available for display on the form.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Access Form Search


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap