Search results for query: *

any ideas how I can keep an old record (ie. video history with video name and video #) but when I change a video name, the old record's video name also changes? How can I keep the old video name (video # doesn't change) because it points to the new video name when I get a new tape?? Again to...

I have a field in a Query that makes a calculation (ie. datediff) When I put that field in a form, i would like to be able to change the data in it that shows up but it says Field is based on an expression and cannot be edited... Is there any way to edit this field or how to put it in a form to...

I have a field (in a query) that makes a calculation (ie. Latefee) that isn't stored in any table except in the query. How can I insert that field into a form that when I type in the first field (ie. Member #, that member # will look and match the field (latefee in the query) to that member #...

How can I in a form field, after I enter data (ie. phone #) to automatically look up in a query or table to match the exact ENTIRE RECORD to that data I entered? Do I build an expression or run a macro?? Thanks!

I have 2 forms that collect the some of the same data: 1 form- (Ph. #, Video #, Rental Date). 2nd form- (Video#, RETURN Date). Both forms use the same query/table but the 2nd form, when I type in the Video #, if the person has seen the video# already, it says "unsuccessful due to duplicate...

I have 2 forms that collect the some of the same data: 1 form- (Ph. #, Video #, Rental Date). 2nd form- (Video#, RETURN Date). Both forms use the same query/table but the 2nd form, when I type in the Video #, if the person has seen the video# already, it says "unsuccessful due to duplicate...

I have 3 tables: Memberinfo, Videoinfo, Rentalinfo. The Rentalinfo table links/looks up Member Ph. #, and Video # and I've also added a Rental Date. My question is, how and where would I put a RETURN DATE and VIDEO # in a form/table to match the RETURN with the RENTAL record as there may be...

I have 3 tables: Member, Video and Rentalinfo. The Rentalinfo has rel'n to member ph.# and Video# from the other 2 tables. Also, I have a rental date field added. The RENTAL form has all of this enabled. Do I create another form for RETURNING info (ie. Return date and Video#?) I'm not too...