Search results

I wish to do this Newdate = Olddate I have tried that and Olddate = 03/03/2003 oldate = cdate(03/03/2003) Im missing something. Thanks, Derek L

Hello, I could use some help on the following code and event I wish to run this when a Certain form opens, and everyday at 7:00 am. Run query If query returns results display query (or another form) Else Exit Form I tried running something like IIf (testquery <> Empty, 1, 0) But it always...

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...

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...

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*...

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...

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...