Recent content by gtford

Our company operates on a Novell network. Access 2002 is loaded on each desktop and Access databases are loaded on the network under a shared directory. We have shortcuts in a Novell-delivered Applications folder on the desktop which opens a sign-in form in each database. Two weeks ago, on a...

Rich, I just figured it out. I needed to make the top text box overlay transparent so when the condition changed I could view the second text box. I works perfectly. Thanks so much for your help.

Thanks, Rich. It's starting to sink in. Can you explain exactly how to overlay the two text boxes over the DueDate text box - I don't think I'm doing it correctly. I set up the two text boxes and if I overlay one over the other, the one on top is the one controlling the condition. If I...

Please refer to Rich's post above. This method works, but I want all records to be reflected. The records where the [DueDate]<Date()will have the [Task] field ForeColor=255. The records where the [DueDate]=>Date() will have the [Task] field ForeColor=0. I'm not certain how to...

Rich, sorry, I didn't notice the obvious - I didn't insert the = sign in the formula. This now gives me all of my "Tasks" in red up to current date and then from current date forward the "Task" fields are blank. I need for the task fields to be reflected from current date forward, but in a...

Rich, thanks for your reply. Hate to sound dumb, but I'm not certain I know how to overlay a textbox. Let's say I only want the condition to apply to my "Text" field. Do you mean in design view I move a new textbox over the existing "Text" field and insert the font colour and then the Iif...

Thanks for your reply Jerry. Yes I am using continuous forms view. Single form doesn't work because the employees have to be able to view all of their outstanding tasks including the past due tasks. Maybe someone else will have a solution.

Earlier in month I posted the following: I have a "to do" task list which includes a DueDate for completion of the task. I want to design the form so that when it's opened any past due tasks (Task) are emphasized by red fonts. Jerry Stoner posted in response: In the forms current event: If...

I have a "to do" task list which includes a due date for completion of the task. I want to design the form so that when it's opened any past due tasks are emphasized by either a red background or red fonts (whichever is easiest). There's probably a simple way to do this, but I sure haven't...

Jack and David, thanks for your reply. David, I assume your question is will I be replicating one record including all fields 16 times and the answer is no. Such items as the customer number, salesperson, etc. will be duplicated, but other fields such as the task, responsible party and...

This one's got me stumped. I have a data table which is essentially a "to do" list for employees to use in tracking customer renewals. There are 16 separate and distinct tasks that the employee has to complete for each customer. Currently I enter the basic customer data into a form and then...

Thanks, Jack. I had reviewed the DateAdd function, but wasn't certain how to use it in such a way that the calculated date would be reflected in the data table. I need the DueDate field bound to my DueDate field in the Data Table. I also wasn't certain if the "number" part of the formula...

I'm sure there is a simple answer to this, but I can't figure it out (obviously I'm new at this). Included in my form are three fields: ExDate, DaysOut and DueDate. I need to calculate the DueDate by adding the ExDate and DaysOut fields. I need the calculated DueDate to move into my data...

Jack, I tried your suggestion this morning and it worked perfectly. Thanks.

Jack, thanks for your help. I'll give it a try as soon as I get to the office tomorrow.