Recent content by maerts

I am assuming that mylinkfield is the field that links the form and the subform to each other...which is a text field not numbers. How do I adjust the syntax for this?

(I am sorry..I am not a technical user...I am using my husband's account) I have a subform that has a Price column and the next column I want to have a running average of the Price column.

How do you create a running average in an unbound field in a form. For example, line 1 will just be an average of itself. Line 2 will be an average of line 1 and 2, line 3 will be an average of line 1, 2, and 3... and so on.

Thanks Nikita6003, someone found a shorter way but if it does not work for me I will try yours

I am a supervisor, I get reports that I need to find all of the agents that work under me and highlight their rows, I have written some VB script that does this however it is very difficult to change as I add or delete someone from my team, I am sure there is a way to do this without specifing...

Thank you Hobbitk and McPat

I am really new to VB, if you could give me a step in the right direction as in the name of the statement I will look it up and figure out how to use it, thanks in Advance McPat

I have a macro written that searches for a name in a workbook and then highlights the entire row to a different color. This works great when the persons name is in the workbook, however, if the name is not in the workbook I get an error, I need help adding to my macro some sort of IF or IIF...

What is the exact error that you are receiving?

The best way to do this is with conditional formatting, it is on the format menu, then conditional formatting, then choose the options you want and then click on the format button, then choose the patters tab and choose the color you want to use, you can set 3 conditions ie. equal to X one...

I have a correction, I did try the first suggestion that starsky51 suggested, however the hatten.ttf file was not found on the PC. I did try to reinstall Office 97 and still was getting the same error. However I guess the reinstall of Office 97 did reinstall the hatten.ttf file and this time I...

Thank you starsky51, but I already tried that, and it did not work for me, I am running NT4.0 SP6A just as an FYI to anyone that may have any suggestions.

I have Office 97, 2000, and XP installed all on the same computer. I have gotten all applications to work except Access 97. When I try to start Access 97 I get an error that says: Microsoft Access can't start because there is no license for it on this machine. HELP!!!!! please

That worked great carrr, thank you, now I feel stupid

I have two tables in Access, one has all employees in it, the other only has some of the employees, how do you create a query that will compare the two tables and tell me which records are missing from the second table?