Search results
-
C
Auto fill calculation in textbox based on entry in another textbox
I have a two fields(actually textboxes on subform) "Mileage" and TravelCost" When data is entered in "Mileage", "TravelCost" should auto fill. I have tried "=[Mileage]*.31" in the TravelCost Control Source property, this auto fills the textbox but doesn't update data to travelCost field on... -
C
update text box data to other than record source
David, Thanks for the post. I'll Try to follow your recommendations as soon as I get the chance, which will be a few days. We have a site inspection to prepare for so my time on this database project will be very limited until afterwards. If I'm visualizing it right this should do it. Most of... -
C
update text box data to other than record source
Rich I don't have seven date fields on Staff Hours table, I want to have seven date text boxes on one form/or if I have to one date text box on individual sub form to update the one date field on table.As the entry form exist now the user enters the date for Monday,selects employee then enters... -
C
Update text box data to more than one record source
David, No I haven't had a chance to work on it today(re-structuring), hopefully tomorrow if things calm down at work.I'm sure I need to make some of the fields in my staff hours table into separate tables and set relationships(which is why I'm having such problems designing this form)-- I... -
C
Update text box data to more than one record source
This is a re-post from original dated 4/13/02, I still need help with this proplem. Is this possible??? I have text boxes on sub forms that hav/e either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a... -
C
update text box data to other than record source
I still need help, Let's see if I can explain what I'm trying to do. I have a table for staff hours with fields for NAME,DATE,DEPT,ID#,REGHRS,OTHRS,VACHRS,etc. I want to populate this table by using one form with as little keystrokes from user as possible. Data will be entered at end of a work... -
C
update text box data to other than record source
Thanks for the reply. You are right, I started work on a query just before reading your reply. Will post back to say how I made out. Again THANKS Rory -
C
update text box data to other than record source
Is this possible??? I have text boxes on sub forms that have either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a given table even though another text is the record source, If so could someone explain... -
C
Want to force order of data entry on a form
Try adding "not null" in the validation property.Let me know if this is what you're asking. -
C
Date Ranges
I Have a report with a query as record source. Report parameters are by date range set in criteria of query 'Between[Enter start date] And [Enter end date]'. Question, how can I get the date range user enters at parameter prompts to appear on the report. I'm new to Access, Can someone please...