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...
Thanks Jim! I do want to be able to edit it and save it. The field stores Latefees. So I would like to be able to change it to 0$ after someone pays it. So any suggestions? I'm new to coding (haven't done any).
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 do I solve this problem with filtering then? If I filter and it doesn't find a matching record it displays a blank record (filtered).. how can I make it go back to the form field with a displayed message like "not found"?
THANKS!
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...
Thanks for your suggestion. It worked but now I am having a problem with the first form, when I enter a Video #, how and where can I have it check to see whether they have seen the same Video # before? THANKS!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.