Search results
-
A
Blank Last Name Field to Display as Company
Bob, your suggestion work perfectly. Thank you! Now I have to spend a little more time with some unfamiliar nomenclature, such as Len and NZ. The learning curve is straight up!!!! Hopefully, I will be able to help others in due time. I wish I was up in your neck of the woods. I am from... -
A
Blank Last Name Field to Display as Company
Thank you, plog! I have attache two screenshots for you. I think I have entered the code correctly, but I am getting an error of "#type!" in the report. I have been unable to nail down the difficulty. I am only guessing here, but maybe the error is indicating a mismatch in data types, but I... -
A
Blank Last Name Field to Display as Company
Appreciate your reply, Gina, but I have no idea what to do with the code. I created a query using the query wizard including all of the fields from the underlying table. Beyond that, I do not know what to do. Where does the code go? Thank you, Norm -
A
Blank Last Name Field to Display as Company
MS Access 2010 I have a report in which some records are companies where as others are individuals (First Name, Last Name). For a record in a report where there is no Last Name, I would like the Company to display. Please also tell me where the code is to be inserted, for example, the... -
A
Enter Date On Click
You have done it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Moving the expression to On Double Click did it! Thank you, Rick. Bob I really appreciate your help too!!!!!!!!! Rick, I found a website for beginners that just may work for me. I wish you both well, Norm PS, since I am new to this... -
A
Enter Date On Click
Here is the most recent code iteration: Private Sub Memorandum_Enter() Dim CUser, MN As String MN = Nz(Memorandum, " ") Me.Memorandum = Format(Now(), " m/d/yyyy hh:mm") + Chr(13) + Chr(10) + Chr(10) + MN If Me.Dirty Then Me.Dirty = False End If End Sub When I click in the Memorandum field a... -
A
Enter Date On Click
Absolutely... Private Sub Memorandum_Enter() Dim CUser, MN As String MN = IIf(Me.Memorandum <> Null, Me.Memorandum, "") Me.Memorandum = Format(Now(), " m/d/yyyy hh:mm") + Chr(13) + Chr(10) + Chr(10) + MN End Sub Norm -
A
Enter Date On Click
Gentlemen, we are almost there. I have attached a screenshot of the code. Here is what happens. When I click in the Memorandum field, the date and time is inserted and highlighted. If I move the cursor to the end of the string, I can then type a memo. If I leave the Memorandum field and go... -
A
Enter Date On Click
If I am overloading you, please say so! I used the following: Dim CUser, MN As String MN = Memorandum Me.Memorandum= Format(Now(), " dd/mm/yyyy hh:mm") + Chr(13) + Chr(10) + Chr(10) + MN The error I got is attached as a screenshot. Best wishes, Norm Kerrville, Texas -
A
Enter Date On Click
Rick, I am glad you found my inquiry! Thank you!! You are light years ahead of me. I would never have known that the result for Now() is a data type and not a string, but your remark now makes perfect sense. You experiences were the same as mine. I modified your code, without first... -
A
Enter Date On Click
You suggestion worked perfectly. Thank you! The string produced remains highlighted after the expression executes. I tried to click at the end of the string to have an insertion point for additional text and I am not able to do so. Is there something else I need to do? Norm -
A
Enter Date On Click
I have attached an image of where and what I entered in the Properties Sheet for the Memorandum field. I am really new at this, so don't laugh, okay? Thank you for your help! Norm -
A
Enter Date On Click
I have a Memorandum field on a form where I would like to automatically enter the date and time when I click in the form. I tried to use the "NOW" expression in the On Click properties field but I am doing something incorrectly because it does not work. Thank you for any help you are able to...