Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maerts

    Access: Running Average

    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?
  2. maerts

    Access: Running Average

    (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.
  3. maerts

    Access: Running Average

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

    I am a supervisor, I get reports th

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

    I am a supervisor, I get reports th

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

    VB scripting in Excel

    Thank you Hobbitk and McPat
  7. maerts

    VB scripting in Excel

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

    VB scripting in Excel

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

    Winword

    What is the exact error that you are receiving?
  10. maerts

    Automatically changing Cell backcolor based on value

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

    MS Access can't start

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

    MS Access can't start

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

    MS Access can't start

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

    Comparing tables in Access

    That worked great carrr, thank you, now I feel stupid
  15. maerts

    Comparing tables in Access

    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?
  16. maerts

    Save excel as .xlr file

    .XLR is the file extension for MS Works 2003 ie Works 6.0
  17. maerts

    I.E. Internet vs. Intranet

    does it go to the correct page if you type HTTP://companyhome?
  18. maerts

    The print popup on a word document comes up behind the document

    have you tried to detach the file first and then open it?
  19. maerts

    Count in Access

    I am assuming this is Access that you are using, you can do this in a report but I am not sure you can do this in a form.
  20. maerts

    ODBC error in Excel

    I have linked data into Excel 97 from Access97 Database using Windows 95 and I am creating a pivot table and getting an ODBC error "ms access driver missing syntax (missing operator in query expression)"

Part and Inventory Search

Back
Top