Search results for query: *

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.

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...

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...

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...

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...

I'm sure this has been asked before, but apparently I can't find it in a search query. I have a form that takes a user's four character (alphanumeric) password. Other users are often in a position to "see" what is entered in the text box (standing in line, hanging around the computer...

I have a txtbox on a form that is designed to take the user's input and send it to a parameter query. The user inputs a "secret" PIN number in the unbound field (txtPinNumber) on frmSignIn. The PIN number is then sent to qrySignIn as a parameter [Forms!][frmPinNumber][txtPIN]. The...

My problem is that the question I need to ask has been answered quite well in "Turn Off fields in a form based on selection made from combo box." But I can't make it work in my case... So...here goes. I have a main form and a subform. The main form simply lets the user know they have...

Not sure this is correct forum, but I have a question about a bit of VBA code that opens various forms in my Database... A form gets opened depending upon the PIN code. Here's the code: Private Sub PinCode_Click() Dim strInput as string strInput=InputBox("Enter your PIN Code")...

Have a form used to determine when an employee leaves the building. Similar to a time card. Has two textboxes -- one for LastName and the other CheckOutTime. When the employee enters Last name in LastName, I want CheckOutTime to automatically enter the date and time. Similar to what the Now( )...

I have a report ("rptSchool") that prints exam data on each student population in that school. The report is controlled by a parameter query that selects the school. Usually, I need to print only one school report at a time, so I simply enter the name of the school in the parameter and...

Students report to tutors on a highly flexible, almost random schedule. Student times are tracked in a table with three fields: [Date],[StartTime],[EndTime]. Tutors are paid $25 an hour but only if they are working with one or more students during the time they claim. My problem is...

I have three forms -- a main form called "frmEveryone" and two other forms, one named "frmEmployee" and "frmStudent." These last two are not subforms. On the main entry form (frmEveryone) there is a combo box with an event procedure. When you select either...

I have a "master" form that the user inputs common data (address, phone, etc) for everyone in a school system (FrmEveryone)--"1" side. Everyone placed in the database is classified in a combo box as either an "employee" or a "student." Once this...

Obviously, I'm a novice. Somehow I am missing a basic design philosophy in Access. I've build my tables as carefully as I know how. There are six of them and each one is constructed about a single subject. All six tables are related to one or more of the other tables through a...