Search results for query: *

Thank you. The coding you suggested worked beautifully. Lee

Could you be more specific? Here's what I have in the module. Perhaps it would help if I include some sample code.As I noted earlier, it's only the PhysicianID bookmark that's giving me a problem. Public Function CreateMerge_ROFCoverLetter(strDocPath As String) If IsNull(strDocPath) Or...

I apologize ahead of time if this question has already been addressed- I couldn't find anything relevant after doing a site search. I am merging data from Access into a Word document. Opening a form calls code in the specified Module, and merges data from the form into bookmarked locations in...

Thanks. With a little tweaking, the expression worked just fine. Can you suggest a reference (preferably net-based) that I can use to learn more about how to write these kinds of expressions in VBA? Lee

well, at least for me it's complex :-) I'm using this expression: =Sum(IIf([Refused]=-1,1,0)) to calculate the number of records that have a -1 value for the field "Refused". I want to expand this so that the sum reflects the number of occurrences of this field, but ONLY if a second field...

Hmmm. I don't see how I could use that.

I want to know when data is entered for the first time into a specific field, of an already created record.

I would like to be able to determine when (mm/dd/yy) data is entered into an empty field in a form. Is there a way to do this?

It was really more of a "want" than a "need"- a lot of our data really doesn't even need a report- a query works fine, except that visually the data is sometimes a little more tiresome on the eyes due to the lack of formatting options. Oh well, thanks for giving it a shot! Lee

No, the default field size is set for 50 characters. My data is only 5 to 6 characters. Lee

Now it's getting bizarre. Instead of pulling data from the ICD1 field, the code populates the field with the same data ("32"), for every record in the query. Actual field data should be 4 to 5 characters long and include numbers and a decimal- e.g., 315.5, 286.90, etc.

Where exactly should I put that code in the query? If I insert in place of Referrals.ICD1 as Referrals.asc(right(referrals.icd1 & ",1), or as asc(right(referrals.icd1 & ",1) then I get an error message that I have a missing operator. BTW, the field in questions is a basic text field which...

Changed to Lucida Console. Text is still left aligned. Lee

The format menu indicates Arial 10, Font style= regular

Thanks, that took care of the problem with null values. But the cell contents are still left aligned. Lee

It's in bold as follows: SELECT Clients.LastName, Left([FirstName],1) AS [First Initial], Referrals.SchedDate, Space((6-Len(Trim(Referrals.ICD1)))/2) & Trim(Referrals.ICD1) AS Centered_ICD1, [Case Coordinators].CCName, Results in #Error being displayed in the field cell. Lee

Just get ### in the field when I run it. Here's the way the first line of SQL code looks. I changed the 15 to a 6 as the field I want to center is 6 characters long. SELECT Clients.LastName, Left([FirstName],1) AS [First Initial], Referrals.SchedDate, Space((6-Len(Trim(Referrals.ICD1)))/2) &...

Wow. This is getting complicated. Unfortunately, SQL didn't like that solution either.

Hmmm. Doesn't seem to work. Not knowing that much about SQL, I assumed that I should locate the field name in the SQL line and insert ".TextAlign=2" after it. For example: Referrals.ICD1.TextAlign = 2, where Referrals is the name of the table, and ICD1 is the field that I want to Center align.

no more than 15 characters