Search results for query: *

Excellent! Thank you Knicks, I knew I was in the right neighborhood with the code but I just couldn't get it to do what I wanted. Now I have this version which works fine: [COLOR=blue] Me.Correspondence.Locked = False Me.Correspondence = Now() & "--" & CurrentUser() & "--" & [ADD] & vbCrLf &...

Well, even if I create a seperate table, it needs to be accessed and added to by all users, but edits and deletes limited to myself and a few others. The request was to have it in a memo field because that is something all the users are familiar with. Is there some way to link this to a word...

I have the following code in a subform which adds the date, user and a dividing line in a memo field: Private Sub Command2_Click() Me!Correspondence = Now() & "--" & CurrentUser() & vbCrLf &...

When I got this it had most of the 175 fields (7x25) bunched into two tables, I simply broke up the info into the more logical grouping (by category) rather than year. When I search a given ID I need to be able to pull up (even if one at a time) all 25 years worth of the 7 categories of...

I have seven tables I need to query at once and display the results requested. Each of the seven tables lists the unique ID and 25yrs of data (ie. certification or state of project) I need a subform within the main form (which lists basics like address and contact info) to query the seven...

About 3 hours after I posted I ran a second query on the same data which totaled exactly as I needed and did the calculated field. I just added it to the report as a sub-report. It seems so obvious now.

I've had great difficulty getting my report to provide a breakdown of totals by three fields, and calculate the final field. I can get a total count no problem, but several dead-ends and now I need a push in the right direction: I have this: Type Quality Size 20 A...