Recent content by Conner

Your solution is closer to what I need than any I have yet been able to develop; however, what happens is that the conditional format "changes" the font color for ALL months that have passed before September (the month that is "now" as of today) regardless of the year....how do I conditionally...

Have a range of cells, all in a row. The first column contains the month and year "mmm/yyyy". IF it can be done, need a function that will automatically change the color of the font in each cell of the row from black to red when that month "gets here," as in Now().

I have managed to develop the following elementary code for a cmdbutton on an excel spreadsheet... Private Sub CommandButton1_Click( ) 'Open an input box Dim DateYear as String DateYear=InputBox ("Enter a Year") If DateYear="" Then exit sub else......'here's where I get lost...

I have an excel spreadsheet with a date column. The dates are entered in sequence -- 1700, 1701, 1702 and so on. I need a command button with a VBA procedure that will take the cursor to the cell of a specific date when the user enters that date in a text box.

You solved the problem. Security was on "high." (Default?). Changed it to "low" because this is an internal application and tried it out. It worked. Gonna' field test it some more. Thanks. A star in your crown. This is saving this school system a ton of work in the way we...

PHV made a helpful hint that worked like a charm. I needed a "tally" procedure in excel. He proposed a solution and the solution worked UNTIL I closed out the excel spreadsheet,shut down the computer, went to lunch and then tried starting things back up again. When I did, the following...

PHV, Skip Thanks for the bit of code. I tried the solution PHV suggested first and it worked like a charm...Then I closed out the Excell Workbook to go to lunch, came back, and now the code doesn'w work. What happened?

The functio I need would let a user "click" on a cell and the cell would automatically add "1" to whatever value is already present. Each additional click would add 1 more... Can this be done? User --- "click on cell"--value in cell increases by 1.

I continue to have problems with "not saving a record" until all data fields are complete.... I have reduced my database to as simple as it can be: tblPINcode tblDateTime PinCode (Prim.Key) DateId LastName PinCode (for.Key) FirstName...

Despite my efforts and some good tips from Tek-Tips, my "final" goal continues to elude me. What I want is a vary simple report: John Doe Date Time In Time Out Total Time Feb 1 8:00 4:00 8 Hr 0 Min Feb 2 7.55 4:10 8 Hr 15...

A user clicks on a cmdButton with the click event set to store the date/time in a table "tblDateTime." The date and time are automatically entered with the Now() function. My problem is that later in the day, that same user can come back, click on the same cmdButton (Sign-In or...

Steve,Golom,Rudy: Suggestions as to what follows? Thanks for the quick responses. I think the real problem may be that I'm trying to use the Now() function to do more than it was really designed to do...it may be better for me to go back,redesign the tables and queries, and use the Date...

Need to compare two "complete date" (m/d/yyyy) in a query.I can use the DatePart function to extract a month, or a day or a year, but apparently not all three at the same time. The fields in the query are populated with the Now() function, so I get something like this: 1/22/2004...

Jr- I tried testing for null (IsNull) in the query criteria. I get the error message "Data Type Mismatch in criteria expression." Didn't work. The "greater than" approach didn't work either. What is in an empty date/time field that doesn't get populated by the Now() as it...

On a form there are two date/time fields. The first field is sign-in and the second is sign-out. Both fields use the Now()function to get the user sign-in and sign-out times. Obviously, the form gets used at the beginning of the workday and the end of the workday. Sometimes a user gets...