Recent content by veder

thanks!!! Actually, both suggestions help!!! thanks so much!! veder

thanks but now something else is happening... Thanks for the help, small issue though... I entered that into the criteria cell and now I'm getting a parameter window popping. When I tried to enter anything, an error message was returned saying that 'the expression is typed incorrectly or the...

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

thanks! thanks Wayne!!! Works great now!

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

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

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

OK - thanks for the help - I am very close now!! - now one final item - how do i make it so that every time the text moves to the historical field, that it keeps a running history of the text? Right now every time I click in the Weekly field, the text moves to the historical field, but it...

Thanks so much!! works great now!

thanks so much! A great help!

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

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

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