Search results

The reason that the syntax isn't working for you could be the fact that you're running an older version of Excel than I am. Maybe someone in this forum who is also running the same version as you could verify this. Good luck with it. Chris

Syntax? Brian, Can you post the syntax of your formula? I can have a look and see if anything jumps out at me. Also, are you running Excel 2003? Chris

Problem Solved I finally figured it out. The following syntax did the trick. ActiveCell.FormulaR1C1 = "=TEXT(TODAY(),""d-mmm-yy"")& CHAR(10) & CHAR(10) & ""UPDATE!""" This gets me the desired result. 6-Aug-08 UPDATE! Regards, Chris

Progress Well I managed to make some progress. Currently my macro is setup as follows. ActiveCell.FormulaR1C1 = "=TEXT(TODAY(),""d-mmm-yyyy"")&"" "" & ""UPDATE!""" This results in, 6-Aug-2008 UPDATE! What I want the output to look like is, 6-Aug-2008 UPDATE! I have tried to add...

TEXT Function Thanks for the reply. I believe that I have to use the TEXT function to convert the DATE to a text string and then concatenate the text "UPDATE!" to it. Unfortunately I have no idea what the syntax should be. Additionally the cell that this will be entered will not always be the...

Hello, I am running Excel 2003 and I want to use a macro that will enter the current date in the format dd-mmm-yy and the text UPDATE! into the selected cell. The result should look as follows. 04-Aug-08 UPDATE! The problem that I run into is when I run the macro the date format changes to...

Mystery Solved I managed to figure it out myself. Instead of having a heading for each month of the attendance period I dropped all of the names into a single column labeled Student. Next, I selected Data, Pivot table and dragged the Student heading into the table and a count of the number of...

Hello, I have a spreadsheet that displays which students had perfect attendance for each month. What I would like to do is to count the number of times each student's name is found in the spreadsheet. I've tried to do this using the pivot table wizard but I'm having difficulty getting the...

Hi Le, I have the following in my On Open event in one of my reports that can only be opened if my main Members form is open. If Not (IsLoaded("Members")) Then Cancel = True MsgBox "To preview or print this report, you must open the Members Form in Form view.", 48, "Must Open...

Success I was able to solve this issue by using the Count function. Here is the correct control source entry. ="(" & Count(*) & " " & "Members Found)" Regards, Chris

Hello, I have a small anoying problem that I'm hoping someone can help resolve. On my main form I have a text box that shows the current number of members that are in the database. The default count is for all members whether they are active or inactive. On this same form I have a list box...

Solution Thanks FoFa, All I had to do is add the following to the AfterUpdate event of the ViewActive combo box. cboMembers.Requery Take care, Chris

Hello, I have a main form that contains a combo box named ViewActive that lets me selective Active=Yes, No or when I double-click it all records are displayed. When I select Yes then I only see active students when I use the record navigation to scroll through the records. On the same form I...

Thanks Pat, I appreciate your feedback. I tend to forget about sorting and grouping. Thanks for the reminder. Chris

Seth, Thanks for the explanation. Cheers, Chris

Hi RV, That gives me the desired result. Thank you. Chris

Additional Assistance Please. Hi Seth, Thanks for the quick reply. I tried your suggestion but I still get the trailing ;. Size Chord, Rising Sun - Nunchaku; Size Chain, Rising Sun - Nunchaku; This is what the combine section looks like now. ' combine Info. Do While Not rsDetails.EOF...

Hello, I am using the following code which combines detail records from 1 table into another. Private Sub cmdAppend_Click() On Error GoTo Err_Handler Dim cnn As ADODB.Connection Dim rsStu As ADODB.Recordset Dim rsStuList As ADODB.Recordset Dim rsDetails As ADODB.Recordset Dim SQL...

Additional Details To further clarify what I'm trying to accomplish I've attached a screen shot of what my posted query results look like. As you see I have 2 lines for the same member. What I want to be able to do is combine the information from both lines into one. The finished query would...

Question Hi Pat, Thanks for taking the time to reply. Currently I do have it set up as a select query so each item is on a seperate line which means that I end up printing 2 receipts for the same member. I was hoping to consolidate everything on 1 line so that I only have to print one receipt...