Search results

  1. V

    Date Query Issue

    I have a query that includes a [Last_Updated] field. I want to pull records into a report (this query is the report's data source) where the last updated date is less than 7 days from the current date. What I have now is... DateAdd("d",-7,Date()) in the Criteria row of the [Last_Updated] field...
  2. V

    Macro Question

    I have 2 fields, 1 is Impacted Business, and it is a yes/no field, the second is POC field. What I want to happen is when I am on the form, the POC field is invisable, when I select the checkbox for the Impacted Business field, then I want the POC field to become visable. I tried to write a...
    • veder
    • Thread
    • Replies: 2
    • Forum: Forms
  3. V

    Retaining text in a click action

    I have two fields set up on a form, when the user double clicks in field 1, the text that was in Field 1 then moves to field 2. The issue is that the text in field 2 only retains the most recent text change - overwriting the text that was in field 2 previously. How do i make it so that every...
    • veder
    • Thread
    • Replies: 1
    • Forum: Forms
  4. V

    Summing other fields per record

    Is there a way to use a query to sum totals of several fields per record? In the db I have designed, I have 5 seperate fields for estimates from different departments. There is also a field for Total estimates. What I would like to do is have the Total Estimates field autocalculate the total sum...
  5. V

    move text from one field to another automatically

    Hi, I have a form set up, among other fields in the form is a Weekly update free form field. I have another field called Historical Weekly updates. What I want to happen is that when a user clicks in the Weekly updae field, the text that is in there should pop down to the Historical field and...
    • veder
    • Thread
    • Replies: 5
    • Forum: Forms
  6. V

    moving text from one field to another

    Hi, I have a form set up, among other fields in the form is a Weekly update free form field. I have another field called Historical Weekly updates. What I want to happen is that when a user clicks in the Weekly update field, the text that is in there should pop down to the Historical field...
    • veder
    • Thread
    • Replies: 1
    • Forum: Forms
  7. V

    Filtering fields in reports

    Hi, I currently have a report that displays a list of projects. One of the fields within the report is the Project Phase. I am trying to filter out any projects that are in a "Completed" phase. I am new to using Access, though and am having trouble setting up the filter. Thanks! veder
Back
Top Bottom