Search results

So I have made my Link table to link properties to people. PropertyTbl PropertyID Name PersonTbl PersonID Name PropPersonTbl PropPersonID PropertyID PersonID The relationships are set and it works great. Now how would I go about making a form (and query) where I can Load in the...

Thank you my friend, Derek L

I have ProductTBL ProductID Product BuyerID Buyer2ID BuyerTBL BuyerID Name Each product can have more then 1 buyer. In my table when I need to assign buyerID and Buyer2ID to the same person in order for the subtable to show the buyer is associated with it. I have also tried to put 2...

Ok so I have =IIf(Projects![Date Expired]>=Now(),-1,0) Where do I put this? I tried putting it in the before update, then the after update niether worked. Also is it easy to do a ( Now() - #00/01/00# ) to let me know when it is about to expire.

I'm looking for suggestions. I just started using access 3 days ago so I'm plently slow at alot of things. I'm planning on (hence my other post on date) on doing searches on people and on projects to see what people belong to what project and vise versa. Also I want to see if a project dedline...

Hello, I was wondering how to check a date in a table vs current date and then put a yes/no in a colum if the date in the table is past current date. In the form I know it should be wrote in the Upon Open Event But I am unsure of the code. Thank you for your time, Derek L

Hello, I have done some reading in the forums and tutorial site and thanks to the help of many members here I am learning lots thanks! My question of the day (Hour :) ) is I have a ProjectTbl ProjectID *Defined by user* Project.StartDate Project.EndDate PersonTbl PersonID *Autonumber*...

Thank you Mel. Option number 3 is what I needed. Your help was greatly appriciated. On another note is there a way to quickly generate a table that has the PermitID (primary Key) go from say 0-1000 with blanks in the other fields? Or advise on where to put my Do While loop :). Thanks, Derek L

I'm posting under a different title because my last title was confusing. What I am really trying to ask is there a way to use a combo box on a form to move through the forms "records". I have a form that updates a table called permits. I wish to use a combo box on that form to select which...

http://www.functionx.com/access/Lesson26.htm This link is proving helpful. Maybe I wasn't clear in my question though. I know how to make forms to lookup both the permit and the person table. I have a form for configuring the person adn a form for configuring the permit. The permit Table is as...

the forum search returned 500 :)

good thing the search only returned 500 hits, now I wont have to spend days looking through it all :) If you could tell me approximentally what I'm looking for or a more technical term to google it would be appriciated. Doing a search for "combo boxes" dosn't really help when I dont know...

Hello, I'm sorry I just started access yesterday so please bare with me. I was wondering if how to make a drop down combo box to select / go through a tables records. In other words maybe this helps I want to make a drop down box to select ID's on that table instead of using the little...